Tutorialspoint

Power Query 2 - Building an Instant Consolidation

Fully automated Self-service Reports

Course Description

If you find it takes ages to consolidate data from various sources and process them before generating a report, or if your report users always ask you to provide snap-shots of certain entities or periods, and you may want to have a quicker way of consolidation and a one-size-fits-all report for your report consumers, then this course is for you.

Join me in the course:

- to learn the powerful formulas and advanced functions in Power Query

- to learn how to build an instant consolidation model from scratch

- to understand how to automate your Power Query model for Self-service Reporting!

It does not matter if you are an Excel novice, or an Excel Advanced user, everyone is sure to learn something new, I can guarantee you on that, as this happened to me time and time again when I tuned in to other master’s Excel lessons.

Goals

  • Intermediate to Advanced Excel skills that will help you
  • to ace your Excel skills
  • to find state-of-the art Excel functions
  • to make yourself the go-to-person in their office, or
  • to be well positioned for your next promotion!

Prerequisites

  • Basic Excel and Power Query knowledge
  • Example: be able to open one Excel file and connect to external data files, etc.
  • Recommended prerequisite: Power Query (Part 1): Ultimate Data Transformation
Show More

Curriculum

  • Introduction
    00:32
    Preview
  • Instructor's background
    01:14
    Preview
  • Why this course?
    00:34
    Preview
  • What you will get from this course?
    00:38
  • How this course is compared with "other similar courses"?
    01:32
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Feedbacks
  • No Feedbacks Posted Yet..!
Power Query 2 - Building an Instant Consolidation
This Course Includes
  • 1 hours
  • 27 Lectures
  • 1 Resources
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee

Sample Certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registered users and counting who have advanced their careers with us.

X

Sample Certificate