The FP&A Guy’s…
Modern Excel Course Bundle
The Modern Excel Course Bundle includes over 5 hours of content. The course covers important topics including Microsoft Excel Tables, Power Query, and Dynamic Arrays. Learning these skills will change the way you work in Excel for the Better.
Here’s the modules included in the Modern Excel Course Bundle
Module 1 - Excel Tables
The Gateway to Modern Excel
The Excel Tables course by The FP&A Guy dives into the power of structured data management within Excel. Learn how to use Excel Tables to organize, analyze, and automate your workflows efficiently. This course covers creating, formatting, and leveraging table features like structured references, dynamic ranges, and automatic updates to streamline your data processes and enhance productivity.
Learning Excel Tables is necessary to use Power Query and to take full advantage of Microsoft Excel Co-Pilot
Module 2 - Dynamic Arrays
Transform the way you write formulas forever
The Dynamic Arrays course by The FP&A Guy introduces the transformative capabilities of Excel's dynamic array functions. Explore powerful tools like FILTER, UNIQUE, SORT, and SEQUENCE to handle complex calculations and automate dynamic data analysis. This course equips you with skills to create flexible, efficient formulas that effortlessly adapt to changes in your datasets.
Module 3 - Power Query
End the Manual Madness Today
The Power Query course by The FP&A Guy teaches you how to automate data preparation and transformation processes in Excel. Master importing, cleaning, and combining data from multiple sources with ease, and unlock the potential of your datasets. This course is ideal for anyone looking to save time, reduce errors, and improve the accuracy of their analysis with Excel's robust Power Query tool.
Plus These Bonuses Come Standard
Forever Access
Every student will receive access for ever to the courses including any new content added to the existing courses in the course bundle.
Practical Exercises
Every course has hands-on exercises and Excel files that will help you master each concept throughout the course.
Meet Your Instructor
-
Paul Barnhurst, The FP&A Guy, is a highly respected FP&A (Financial Planning and Analysis) professional, corporate trainer, consultant, and dynamic public speaker. As the founder of www.thefpandaguy.com, Paul is committed to sharing expert knowledge and resources in the fields of finance and Microsoft Excel, helping both individuals and organizations upskill their employees.
Paul’s academic credentials include a Master of Science in Information Management and an MBA in Finance. He also holds the prestigious FPAC (Financial Planning & Analysis Certified Professional) certification from AFP and is recognized as an Advanced Finance Modeler (AFM) by the Financial Modeling Institute (FMI). These qualifications reflect his dedication to mastering the technical and strategic elements of financial planning.
In addition, Paul has earned the elite distinction of Microsoft MVP for his excellence with Microsoft Excel, demonstrating his ability to harness and teach the advanced capabilities of the software. As a recognized thought leader in the FP&A community, Paul regularly engages with his audience of nearly 100,000 LinkedIn followers, providing valuable insights, best practices, and tools to optimize financial processes.
Paul has over a decade of hands-on experience in Microsoft Excel, analysis, forecasting, budgeting, and business strategy. His real-world expertise and approachable teaching style have made him a sought-after trainer and mentor, helping professionals at all stages of their careers develop the skills needed to succeed in today’s fast-paced business environment.