If you’ve worked with Excel Power Pivot for any amount of time, you know that it has incredible potential to change your reporting game. But while building a simple sales report may be easy, have you struggled to re-create a full set of financial statements in DAX?
Let’s face it, generating your current month’s sales may be easy, but how do you display that next to year to date, or same period prior year? Then comes the balance sheet. While calculating a year-to-date balance for assets and liabilities is not super difficult, what about current earnings? How about retained earnings to the end of the prior period?
Next up comes everyone’s most dreaded statement: the Statement of Cash Flows. Many users find this hard enough to work out with a regular Excel spreadsheet, but how about using DAX Measures?
Finally, we’ll explore the Forecasted Actual statement, which allows you to dynamically pull from historical actual values – where they exist – and report budget (or forecast) for the months that haven’t happened yet.
In this course we will explore creating the key requirements behind building a robust set of financial statements. Concepts that will be covered include:
This training is an expert level, hands-on Excel course which leverages Power Query and Power Pivot. Please see the “Who is the Course For” section below to ensure that you have the background knowledge required before attending.
This is an advanced course which targets users with Power Pivot experience who are struggling with the DAX formulae required to build financial statements. It is geared toward those with:
First release of the course.
This course is built on an annual subscription format. Your registration comes with 12 months of access to the course materials, so you can refer back to the videos and example files whenever you like. Your subscription also gives you access to our private Discussion Forum, where you can ask questions related to the course materials, as well as how to apply those teachings to your own work. This forum is an invaluable resource that also allows students to practice their own learnings by helping others with those questions.
On your annual renewal date, your subscription will be automatically renewed with the credit card information on file, unless you cancel your subscription beforehand. You will be emailed a renewal reminder about one month before the renewal date. Please see the FAQs below for information about subscription renewals and cancellations.
Continue your learning journey with our other training offerings. We’ll help you take your skills to the next level.
Subscribe to our newsletter for
information on Power BI,
Power Query, DAX, and more,
plus details on courses, events,
and promotions.
Marvin Rivas (verified owner) –
I was excited when I saw it listed in the course catalog in Skillwave.
Eric (verified owner) –
This course is awesome. Ken did a great job. I’m slowly making my way through the first time, knowing I will do a deeper dive afterwards. It is the best course I have found on integrated 3-way statements using power query, power pivot and DAX.
Carl (verified owner) –
I liked the step by step instructions.
Tim Arrington (verified owner) –
Ken Puls is a great instructor, no pauses, no backtracking, he is smooth. It is great that Kens is an accountant and not just an IT geek. Really, really good course!
Thomas Allan (verified owner) –
I liked that it was taught by a CPA with experience in all areas of the course. Many thanks for preparing the level of detail contained in “Building Financial Statements in Excel”.
Prior to starting the course I had successfully completed a set of financial reports for a medical packaging company; had I this course in my background, I would have saved substantial time in upfront research. A key benefit to me in signing up for this course was to watch Ken Puls as he assembled the financial reports while also learning insights and best practices along the way.
If someone wants to be more efficient in building financial reports and they have the following as a starting point:
• Familiarity with the concepts behind the Balance Sheet, Income Statement, and Statement of Cash Flows
• Familiarity with basic bookkeeping rules
• Experience with the basics of Power Query, Power Pivot, and DAX
I believe they will also enjoy and benefit from this course.
Rafal Jagniewski (verified owner) –
I loved the structure and the way it was presented. Very interesting and practical subject.