Power Query in Excel Free Course Skills you will learn

  • Connect External Data
  • Shaping Data
  • Merge Tables
  • Create Charts and Reports

Who should learn Power Query in Excel Basics

  • IT Professionals
  • Developers
  • Project Managers

What you will learn in Power Query in Excel Course

  • Introduction to Power Query in Excel Basics Course

    • Lesson_01_Intoduction_To_Excel_Formatting

      01:54
      • 1.01 Introduction
        01:54
    • Lesson_02_Excel_Power_Query

      57:00
      • 2.01 Excel Power Query
        57:00
    • Lesson_08_Business_Analytics_With_Excel

      23:44
      • 8.001 Introduction
        01:52
      • 8.002 Learning Objectives
        00:37
      • 8.01 Introduction
        02:02
      • 8.02 Learning Objectives
        00:41
      • 8.03 Histogram
        05:03
      • 8.04 Solver Add in
        04:28
      • 8.05 Goal Seek
        02:47
      • 8.06 Data Table
        01:47
      • 8.07 Descriptive Statistics
        01:30
      • 8.08 Exercise Introduction
        00:53
      • 8.09 Excercise
        01:18
      • 8.10 Quick Recap
        00:46
    • Lesson_09_Spotlight

      01:59
      • Spotlight
        01:59
    • Lesson_10_Data_Analysis_Using_Statistics

      40:18
      • 10.01 Introduction
        01:53
      • 10.02 Learning Objectives
        00:40
      • 10.03 Moving Average
        02:32
      • 10.04 Hypothesis Testing
        03:54
      • 10.05 Anova
        02:32
      • 10.06 Covariance
        01:57
      • 10.07 Correlation
        03:44
      • 10.08 Regression
        05:08
      • 10.09 Multiple Linear Regression
        03:36
      • 10.10 Logistic Regression
        02:32
      • 10.11 Normal Distribution
        06:13
      • 10.12 Exercise One Introduction
        00:34
      • 10.13 Exercise One
        01:12
      • 10.14 Exercise Two Introduction
        00:22
      • 10.15 Exercise Two
        01:11
      • 10.16 Exercise Three Introduction
        00:26
      • 10.17 Exercise Three
        00:48
      • 10.18 Quick Recap
        01:04
    • Lesson_11_Using_Macros_for_Analytics

      07:22
      • 11.01 Learning Objectives
        00:35
      • 11.02 Using Macros for Analytics
        01:17
      • 11.03 Mean of Data Using Macros
        00:46
      • 11.04 5 Point Summary Using Macros
        01:50
      • 11.05 Correlation Coefficient Using Macros
        01:09
      • 11.06 Removing Duplicates Using Macros
        01:00
      • 11.07 Quick Recap
        00:45
    • Lesson_12_Spotlight

      02:12
      • Spotlight
        02:12
    • Updated

      23:34
      • 10.03 Moving Average
        02:32
      • 10.04 Hypothesis Testing
        03:54
      • 11.02 Using Macros for Analytics
        01:17
      • 2.02 Learning Objectives
        00:45
      • 2.04 Areas of Analytics
        03:57
      • 4.02 Learning Objectives
        00:49
      • 4.03 Introduction to Custom Formatting
        00:57
      • 6.06 Grouping in Pivot Table Example One
        01:55
      • 6.07 Grouping in Pivot Table Example Two
        01:57
      • 6.10 Calculated Field Example
        01:26
      • 7.01 Introduction
        01:14
      • 7.08 Pareto Chart
        02:51

Get a Completion Certificate

Share your certificate with prospective employers and your professional network on LinkedIn.

FAQs

  • What are the prerequisites to attend the free Power Query in Excel course?

    To attend this course, you might need basic knowledge on MS Excel

  • How do beginners learn this free Power Query in Excel course?

    Beginners can start with the Introduction to MS Excel course to have a basic understanding

  • How long is this free Power Query in Excel course?

    This course consists of 1 hour of video content to help you thoroughly understand the concepts

  • Will I get a certificate after completing the free Power Query in Excel course?

    Yes, You will receive a course completion certificate after completing the course

  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.
  • *According to Simplilearn survey conducted and subject to terms & conditions with Ernst & Young LLP (EY) as Process Advisors