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:
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.