Master Excel to analyze, clean, and merge data effortlessly!
Learn Excel Functions to better analyze your data, clean it, and merge lists. In this quick course, you will learn everything you need to know about the VLOOKUP and XLOOKUP functions.
This course is designed for beginners and professionals alike, focusing on practical applications of these powerful tools. You'll explore how to use VLOOKUP and XLOOKUP to efficiently find, compare, and retrieve data across spreadsheets. By the end of the course, you'll be equipped with the skills to streamline your workflow and make smarter data-driven decisions.
Chartered Professional Accountant & Microsoft MVP
David Fortin is a Chartered Professional Accountant (CPA) and a 2024 Microsoft MVP. He runs Piggy Bank Accountant, a YouTube channel where he shares practical insights on Excel and Microsoft Copilot. With a background in Financial Planning & Analysis (FP&A) for a SaaS startup, David was instrumental in raising $30 million in venture capital funding and played a key role in the company’s successful exit, valued at hundreds of millions. Known for his dynamic and energetic personality, David is all about helping people, which he does through his online courses on Excel and Copilot. What sets David apart is his ability to make learning fun and engaging, bringing a unique energy to his videos that resonates with his audience.
This portal is provided as a training and development resource for City of Markham employees. Every course is delivered by a qualified subject matter expert or learning organization, is quantifiable in hours, and is verifiable — you receive a documented certificate of completion for every course you finish, stored on LearnFormula indefinitely.
If you hold a professional designation (for example in engineering, accounting, human resources, or law), courses may be counted as professionally relevant, verifiable learning activities toward your continuing professional development. Individual practitioners are responsible for confirming that an activity meets the requirements of their professional body. For questions about the City of Markham's training and development policies, please speak with your people leader or Human Resources.
