Sep 08, 2022
CPA Ontario - King, Toronto
Nov 14, 2022
FEB 13 - Feb 14, 2023
JUN 01 - Jun 02, 2023
JUL 12 - Jul 13, 2023
SEP 05 - Sep 06, 2023
NOV 01 - Nov 02, 2023
DEC 11 - Dec 12, 2023
DEC 11 - DEC 12
8:30 AM - 12:30 PM
WHO CAN ATTEND
Registration open until
Dec 06, 2023
This course has shifted online into two, half-day sessions.
This seminar is aimed at exposing participants to advanced techniques in building spreadsheets to be used in the planning and accounting process. Participants will work hands-on along with the facilitator on a practice data-file with supplied examples and learn techniques in managing and consolidating data, and in constructing powerful formulas including tier-based lookups. Participants will also work on examples that bring out the power of Pivot Tables in managing data and reports, examine techniques for representing accounting data effectively, discover tips and tricks to link data and build formulas spanning multiple sheets quickly, and many other tips and tricks to enhance output and increase productivity.
WHO WILL BENEFIT:
This seminar is designed for those who are involved in making budgets, plans, recurrent reports, or whose work involves consolidating data, tier-based calculations, and reporting data.
Registration open until Dec 06, 2023
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, Colgate Palmolive GSSO, Tetra Pak (I), ICICI Prudential, to name a few.
This course is a live webinar. You must attend the live course to receive verifiable CPD hours. We recommend you join five minutes prior to the scheduled starting time. To get the full experience of this interactive course, use a computer that has video and microphone capabilities.
Electronic material can be accessed one week prior to the course at https://pdlms.cpaontario.ca/ and should be downloaded in advance.
Registration, cancellation, withdrawal and all other CPA Ontario PD Seminar policies can be found here.