Please choose between the following three options for navigation.
• What We Will Cover• Understanding Dates in Excel• Common Date Functions• Today’s Date• Date Extractions - Day and Month• Date Extractions - Year and Week• Date Conversion• Date Creation• What Have We Done
• Santa’s Receivables• Extracting Key Statistics• Purchases and Interest - Part 1• Purchases and Interest - Part 2• Calculating Interest• Cumulative A/R Balances• What Have We Done
• Understanding Time in Excel• Manipulating Time in Excel• Creating Time Sheets• Pay Periods• Calculating Regular Hours• Calculating OT Hours - Part 1• Calculating OT Hours - Part 2• Calculating Banked Time• Total Hours Payable• What Have We Done
• Calculating Workdays and Holidays• Labour Hour Forecasting 02:13 Creating a Production Schedule• Statutory Holidays - Part 1• Statutory Holidays - Part 2• Statutory Holidays - Part 3• Creating a Labour Hour Forecast - Part 1• Creating a Labour Hour Forecast - Part 2• What Have We Done
• In Review• Conclusion• Final Quiz
Join our financial literacy volunteer program for CPA members.
September 18, 2017
Jointly presented by CPA Canada and CPA Ontario, The ONE is the must-attend, multi-track event of the year, designed for all CPAs who want to be at the top of their game.
July 10, 2017
CPA Canada and Canadian CPAs celebrate Canada’s 150th anniversary and tell us why they are #CPAproud.