Transform from a complete novice into a high-performing spreadsheet pro by mastering formulas, pivot tables, dynamic charts, and advanced data analysis.
This course provides a comprehensive overview of Excel 2019, covering functional areas from fundamental setup to intermediate list management. It details the interface components, file operations, and data entry techniques required to build and edit spreadsheets. Instruction includes the application of formulas, basic mathematical functions, worksheet modification, and data formatting tools such as conditional formatting. Additional sections cover the integration of visual elements, printing configuration, and the creation of custom templates.
30 activities • 123 videos • duration: 7h 33m
Office 365 - Engineer
Hi there, my name is Andries and I have been working with Excel for over 20 years. I have worked with major corporate companies such as Nespresso and various Banks. I currently am one of the preferred in classroom trainers for Office and I am dedicated to helping you create outstanding tools and reports in Excel. Our courses are for those who want to learn Excel, accelerate your careers and achieve more in less time. For over 20 years I have worked in the Finance and IT departments implementing reporting systems based on SQL and XML. All the while using Excel VBA to automate and improve processes. Our courses include examples based on real-life experience as well as the consulting work I have done for many international companies. I place great value on keeping my Excel courses not only informative but also engaging. For this reason, students will find enough challenges, exercises, and downloadable files to practice so they can maximize the value gained from each course.
Provincial regulators of CPAs in Canada do not require that independent providers of CPD be approved to offer courses. Instead, individual CPAs are responsible for assessing whether a CPD activity meets their requirements, and may take activities from any source provided those requirements are met.
Every course offered on LearnFormula is delivered by a qualified subject matter expert or learning organization, and advances learning objectives that are relevant to the responsibilities or professional competencies of Canadian CPAs. All activities on LearnFormula are quantifiable in terms of hours, and are also verifiable, in that users receive documented evidence of their attendance via a certificate of completion after finishing a course (and this certificate is stored by LearnFormula indefinitely). Nearly 100,000 Canadian CPAs successfully satisfy their CPD requirements via LearnFormula on an annual basis.
