Financial Consolidations & Reporting with Microsoft Power Products

Build custom integrated solutions today using Excel 2016, Power Query & Power Pivot. The course I wish was available when I started out!

  Enroll in Course
div class="preenrollment-form-wrapper col-sm-10 col-sm-offset-1">

Pre-enroll now as space is limited to the first 10 students. Course will be available on Wednesday, February 21.

The goal of the consolidation process is to collect and transform data into financial statements.

But, does your financial close process suffer from any of these common ailments?

Unstructured - No commonality in account structure? No corporate hierarchies for dimensions such as accounts, entities, departments and products?

Complex - Use of multiple spreadsheets for consolidation? Poor controls, no process standardization and limited communication between users?

Inflexible - Lack of multidimensional financial reporting that can quickly adapt to changing business needs?

Use the power of Excel 2016, Power Query and Power Pivot to solve these problems.

Create structure - define a common chart of accounts and reporting dimensions shared by all locations, departments and reports

Reduce complexity - dramatically improve controls by having 'one version of the truth' accessible to multiple users; eliminate need for multiple spreadsheets while communicating close status to all users throughout the process

Introduce flexibility - create updatable multidimensional hierarchy structures that quickly meet accounting and Finance reporting requirements

Learn To Build Financial Consolidations & Reporting Solutions

. . . with tools you already have but don't yet know how to use. I will show you.

I use the 'learn by doing' teaching method. Hands-on and very interactive.

By the end you'll have built a working financial consolidations and reporting application that you can customize for your own use.

  • 27 personalized video lessons
  • downloadable exercises
  • 10 reference worksheets

Bonus: your enrollment also includes 30 minutes of one-on-one video consultation! Let me personally answer your questions and guide you along the way.

I will also incorporate your needs into my lessons. Want to see something specific? Let me know and I will add it so we can all share.

It's all designed to get you started properly and get results quickly.

Begin your transformation today!

Class Curriculum

Your Instructor

Doug Burke
Doug Burke

If you're like me, you see tremendous value in developing your career in data analytics and creating financial systems. Companies need these skills more than ever.

But did you know . . .

The hardest part of any useful financial system is getting it to meet your specific data needs

This statement comes from my 20+ years of experience building data analytics systems at Fortune 500 companies. Let me share my secrets so you can build first-rate financial systems and fill them with clean data.

My specialty is creating financial systems using Excel 2016, Power Query, Power Pivot and Power BI.

I love this topic and use it every day . . . Learn from me.

  • I read the software user manuals so you don't have to
  • I enjoy teaching complex topics in a clear, simple manner
  • I'm very involved in the financial analytics community as a member of Microsoft's Power BI User Panel, and a frequent speaker at Oracle analytics events

Courses like mine are not widely available so I decided to create one.

Thanks to the internet, a global audience now shares this knowledge. Don't believe me? Here is an instructor dashboard snapshot from when I taught on Udemy. This stuff has gone global!

Now I have my own site at so I can offer students even more opportunities for learning.

Take my courses and enter a community of like-minded people who want everyone to succeed. I will personally answer any question posted and provide frequent updates on what's happening in the financial analytics and Power BI communities.

There is so much value here and I encourage you to join.

Frequently Asked Questions

When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Get started now!