Excel PowerQuery and PowerPivot

These days, there are tons of data coming in from many sources. You are expected to import all of that data, and then get meaningful results from that data. This course is specifically designed to enable you n how to …

User Avatar

These days, there are tons of data coming in from many sources. You are expected to import all of that data, and then get meaningful results from that data. This course is specifically designed to enable you n how to go about it effectively & efficiently.

 

On Completion of this course, you’ll be a pro in the following concepts & processes:

  • Normal Pivot Table Formulas
  • Sorting & Filtering the Pivot Table
  • Calculated Items
  • Calculated Fields
  • Conditional Formatting in the PivotTable
  • Consolidated Pivot Tables
  • Importing data from Excel into PowerQuery–normal data
  • Splitting & Merging Columns in the PowerQuery
  • Calculate age in the PowerQuery
  • Adding Custom Calculations in PowerQuery
  • Importing data from a website into the PowerQuery
  • PowerQuery–formatted tables
  • Importing Access, SQL Server, and textfiles into PowerQuery
  • Append Queries
  • GroupBy Queries
  • Merge Queries
  • Managing Table Relationships
  • Slicers & Timelines in PowerPivot
  • Using Sets in PowerPivot
  • Importing Data directly into the PowerPivot
  • Measures & KPI’s in PowerPivot

 

Some exceptional benefits associated with this course enrolment are:

  • Quality course material on Excel PowerQuery and PowerPivot
  • Lifetime access to the course
  • Instant & free course updates
  • Access to all Questions & Answers initiated by other students as well
  • Personalized support from the instructor’s end on any issue related to the course
  • Few free lectures for a quick overview

 

It’s time for you to grab the opportunity and make the most out of this course.

Enroll today!!

Course Curriculum

Total learning: 26 lessons Time: 4 hours

ABOUT INSTRUCTOR

I am a Microsoft Certified Trainer with over 35 years of professional IT experience, and my passion is teaching people how to get the most out of their computer.

Leave A Reply