Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
TOPICS INCLUDE:
- Understand key concepts to formula building
- Explore the concept of range names and how they can make complex formula-building simple and error-free
- Introducing the advanced concept of Array formulas and their potential for greatly enhancing effectiveness in data analysis and reporting.
- Learn about arrays of constants and their use in formulas with relevant examples
- NEW - Introduction to Dynamic Arrays in Office 365
- NEW - Introduction to new Functions with Dynamic Arrays in Office 365
This is a live online session. PLEASE read the FAQs and test your computer system at this link BEFORE registering.
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.
- Office 365 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.