Power Query Mastery

Wishlist Share
Share Course
Page Link
Share On Social Media

Course Content

Module 1: Data Analysis in Excel
The module takes learners through the key data analysis tools and commands in Ms. Excel

  • Data skills-Intro
  • How To Use Filters
  • Using Advanced Filters
  • Basics of Number Formats
  • Advanced number formatting
  • How to Move/copy Sheet
  • How to Select and Boarder
  • Using a Form for Data Entry in Excel
  • How to format data as an Excel Table for Easier Data Management
  • Benefits of converting data as Excel Table
  • Techniques of Excel Table management
  • Techniques for multiple Sheet Operation
  • How to sum all/multiple sheets concurrently
  • Summing multiple sheets from Start to End
  • Exploring the techniques of data validation
  • How to remove duplicates in a list
  • Exploring the “Text-to-Column” Command
  • Further techniques: Page Lay Out – Print Titles, Print Options Gridlines, Freeze panes etc

Module 2: Graphs, Charts and Visualizations in Excel
As power query is about reporting, this module provides toolkits for report generation through visualizations, charts and graphs,

Module 3: Pivot Tables for Data Analysis in Excel
Master Pivot Tables. Pivot Tables are arguably the gold standard for Excel Reporting and Analytics. Pivot Tables are also a foundation for reporting the results of Power Query Data Management. This module prepares the learner to fully exploit the magic of power query by first mastering Pivot Tables.

Module 4: Introducing Power Query for data cleaning, transformation and reporting automation
Gain Insight into the interface and functionality of the Power Query Editor and sample data transformations.

Module 5: Power query: Extract data from Website Upload, clean and transform data for report automation
In this module, extensive coverage is given to extracting, cleaning and transform data from an excel upload on a website. The lessons in this module give a broad first hand experience with the Power Query Editor.

Module 6: Data Transformation Techniques
Explore endless possibilities of transforming data into an analyzable format

Module 7: Other Data merging and data cleaning techniques
You will learn how to merge files from a folder with opening the folder; How to clean, transform and arrange delimited data; How to merge data and map data points based on a Lookup-like criteria

Module 8: Basics of Power Pivot and Data Modelling
Introduction to Calculation of Measures as alternatives to columns in a data model

Student Ratings & Reviews

No Review Yet
No Review Yet