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.
4 activities • 10 videos • duration: 53m
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.
Professional development requirements vary by profession, country, and regulatory body. Before enrolling, review the course details and confirm that the content, learning format, and any listed credits meet your specific requirements. You are responsible for confirming eligibility with your regulator or professional association and keeping the records required for reporting.
Very informative lecture. The concepts were explained clearly and in a practical way. I found it really useful and easy to follow.
Very informative video!! Thank you!
Very helpful, learned Hlookup & Xlookup. Thank you very much, course was very easy to follow.
Good course. I use VLOOKUP all the time but didn't use XLOOKUP so now know how to use it, and the intro to using CoPilot. I liked the incidental formulas he used, keyboard shortcuts, and that there was an error that really helps you learn. Didn't need the F-bombs.
