• LOGIN
  • ABOUT
  • CONTACT
  • ACCREDITATION
  • FAQ
  • Login
0 Items
Select Page
CPA Self Study -Self Study CPE for CPAs
  • CPE SUBSCRIPTION
  • COURSE CATALOG
  • CPA EXAM TEST BANK
  • BLOG
  • REVIEWS

Using Workday to Calculate Invoice Dates

by CPA Self Study | Feb 20, 2015 | Date functions, Functions

This is just a quick tip as Excel is not necessarily that date friendly. If you want to calculate an invoice date or a project completion date use the WORKDAY() function. Select a cell and then select the Formula tab and then select Date& Time The syntax is as...

Preventing Duplicate Entries using Data Validation in Excel

by CPA Self Study | Feb 10, 2015 | Data Validation, Functions

If you are setting up a spreadsheet for someone else to enter data this is a neat trick. You can use the Data Validation and the CountIF feature to check for duplicate entries and then not allow the user to enter the duplicate data. Let’s assume that the data...
Next Entries »

Course Quick Links

  • Accounting & Auditing (24)
  • Accounting & Auditing Update (7)
  • Business Law (2)
  • Business Management (2)
  • Business Tax (2)
  • CPA Exam Test Bank (1)
  • Estate Tax & Planning (3)
  • Ethics (62)
  • Excel (16)
  • Federal Tax (9)
  • Fin. Planning/Investments (3)
  • Form Prep Training (1)
  • Fraud (3)
  • Individual Tax (6)
  • Industry (6)
  • LLC/Partnership/S Corp (3)
  • New (20)
  • Specialized (1)
  • Tax Staff Level Training (1)
  • Tax Update (2)
  • Technology (16)
  • Unlimited CPE Subscription (2)
PRIVACY POLICY TERMS OF USE © 2023 CFO Resources, LLC. All rights reserved. CFO Resources, LLC | 201 N. King of Prussia Road, Suite 370, Radnor PA 19087