Transform Your Finace Career With…

Power Query for Finance and Accounting Professionals

Does any of this sound familiar?

You wade through file after file of raw data, an amalgamation of disparate financial reports, and a disjointed network of spreadsheet files. Your eyes strain from scanning tiny cells, while your fingers ache from typing complex formulas -- and your mind is grappling with the jigsaw puzzle that is your data.

You've spent countless hours cleaning, sorting, and reshaping it, yet your analysis is not complete.

The situation is clear - there's a mismatch between the demands of your FP&A role and the capabilities of traditional Excel. This is a narrative all too familiar for many finance professionals. 

Luckily, there is a better way…

Now You Can Experience A New Era of Data Transformation with Power Query

In this era where data is the new gold, Power Query is your modern-day pickaxe. Designed to handle the specific challenges of finance professionals, this course will empower you with the ability to extract, transform, and load your data in the most efficient manner possible.

From unpivoting data and dissecting "Frankentables," to grouped calculations and handling nested headers, this course covers a plethora of Power Query essentials.

We designed each module to address the unique needs of finance and accounting professionals, enabling you to transform raw data into meaningful insights with ease.

Course Syllabus:

Module 1: Power Query Overview

  • How Power Query transforms the work you do

  • How Power Query simplifies managing data

Module 2: How to combine data

  • Load files (csv, xls, Tables in Power Query)

  • Combined files together

Module 3: How to transform data

  • Basic Transformations (Dates, Columns, Text, etc)

  • Pivot/Unpivot Data

Module 4: Completing common finance tasks in an automated manner

  • How to simplify combining your budget load files

  • How to automate your monthly tasks

2024 Course Dates:

April Course

  • April 16th and 19th from 11:00 AM - 4:00 3PM EST

June Course

  • June 13th and 20th from 12:00 PM - 4:00 PM EST

What Are People Saying?

TESTIMONIALS

Love to say, that thanks to the import from folder function I saved at least 2 hours and avoided manually entering financial information into a financial model this week already. We received eight password protected pdf's from a data room and Power Query got me there in about 20 minutes.

Thanks again for the new skill!

Chris Pawluk

"The instructors were very knowledgeable and complemented each other very well.

Anonymous Course Feedback

Transformative Outcomes:
What You Stand to Gain

Upon course completion, expect to:

  • Learn Power Query to streamline your day-to-day work

  • Combine disparate data sources into one easy-to-use file

  • Clean and transform your data without having to maintain 1,000’s of Excel formulas

  • Automate your manual data tasks and make life easier for yourself

  • And so much more.

    Interested?

Get Reimbursed by Your Employer

Use your employer’s training and development budget

  • Many of our former students have had the course paid for by their employer because the skills learned in the course are job-relevant skills and prepare you to be a better employer at work.

Make the request using our template

  • The attached e-mail template lists course benefits to assist you in asking for company funding.

100% Satisfaction Guaranteed

 At "The FP&A Guy", we stand unwaveringly behind the transformative potential of our courses. We deeply understand the value of your time and investment. That's why we assure you, our commitment is set in stone – we offer you a comprehensive 100% Guarantee. If you are unsatisfied for any reason get a 100% refund.

Meet Your Instructors

Paul Barnhurst spent 12+ years in FP&A roles in several industries and is an influencer in the world of FP&A. He currently hosts two popular finance podcasts FP&A Today and Financial Modeler's Corner. He provides training and development for Finance & Accounting teams globally. Paul worked for leading organizations, including American Express, Solera and DigiCert.

Khaled Chowdhury is a visionary leader in Data and Finance. He has a track record of delivering organizational transformation and building world-class teams. Khaled specializes in unlocking value by empowering businesses with modern technologies. Khaled is an expert teacher when it comes to the subjects of Power Query, Power Pivot, and Power BI.