Dates and location
Registration open until
December 10, 2024
Start date
December 13, 2024
End date
December 13, 2024
Location
Virtual
Pricing
$169.00
Member
$169.00
Student
$205.00
Public
$119.00
Personal PD Passport Pricing
Hours
Time
9:00 a.m.-11:00 a.m.
PD hour(s)
2 hours
Ethics hour(s) included
0
hours
Dates and location
Registration open until
December 10, 2024
Start date
December 13, 2024
End date
December 13, 2024
Location
Virtual
Pricing
$169.00
Member
$169.00
Student
$205.00
Public
$119.00
Personal PD Passport Pricing
Hours
Time
9:00 a.m.-11:00 a.m.
PD hour(s)
2 hours
Ethics hour(s) included
0
hours
Description
Topics Include:
- Understanding date and time concepts and how they are handled in the spreadsheet
- Revision of the dynamic date and time functions TODAY and NOW
- Exploring more date functions for planning and scheduling DATE, and its corollary functions, Workday, Networkdays and their International variants
- Exploring date functions that allow Week-related and Month-related scheduling and control Weekday, Eomonth and more
- Using Date functions in calculating Fiscal Quarters and Months
- Using Date functions with Conditional formatting and Data Validation
Who Will Benefit
Those wishing to increase their proficiency in Microsoft Office with the convenience of taking courses at their own location.
How to Access The Course
- Two hour, Live, Instructor-led online webinar workshop with hands-on practice and instruction.
- Essential requirements are a Computer with broadband internet access, audio headset or speakers, and working copy of Microsoft Office 2007 or later. Microsoft Office Starter Edition will not be adequate.
- Version 2013/2016 will be used in the demonstration of techniques of this workshop.
PLEASE read the FAQs and test your computer system at this link BEFORE registering.
Registration, cancellation, withdrawal and all other CPA Ontario PD Seminar policies can be found here.
Speaker(s)
Paul Mascarenhas, BSc. MBA., President of Avancer Learning Inc., is a specialist in Strategic Analysis, and Communications. Paul has conducted his much sought after brand of hands-on IT Skills workshops, to globally renowned names as the Canadian Forces, Canadian Tire, Carlson Wagonlit, SKF Bearings (I) Ltd, CGI Inc, Scotiabank, Colgate Palmolive GSSO, Tetra Pak (I), ICICI Prudential, to name a few.