Power Query Skills you will learn

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

Who should learn this free Power Query course?

  • IT Professionals
  • Developers
  • Project Managers

What you will learn in this free Power Query training?

  • 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.

About the Course

In this free Power Query training, you'll learn to harness the power of Power Query in Excel through hands-on and practical training. This SkillUp course covers everything you need to know about transforming and organizing data. 

Guided by an experienced instructor, the Power Query Excel course simplifies complex concepts, making it easy to grasp and apply in real-world scenarios. The focus will be on building practical skills to boost your confidence and proficiency in using Excel effec

Read More

FAQs

  • What is a Power Query in Excel?

    Power Query in Excel is a powerful tool developed by Microsoft for transforming and preparing data. It provides a visual interface that allows users to extract, transform, and load data from various sources into Excel or Power BI, making data handling more intuitive.

  • How is Power Query different from traditional Excel data tools?

    Unlike traditional Excel data tools, Power Query offers a broader scope by enabling connections to diverse data sources such as databases, web services, text files, and online data.

  • Can Power Query handle big data?

    Absolutely. Power Query is designed to efficiently handle large volumes of data, making it a valuable asset for processing and transforming substantial datasets without compromising performance.

  • Will I receive any certification upon completing this Power Query in Excel?

    Yes, upon completing the course, you will be awarded a Power Query certification, acknowledging your mastery of this valuable tool.

  • How long will I have access to the course materials?

    You will have a generous 90-day access period to the free Power Query course materials. This provides ample time for self-paced learning, allowing you to revisit and reinforce your understanding as needed.

  • What is the course duration?

    The Power Query certification course spans a user-friendly 3-hour duration, with self-paced video lessons.

  • How long does it take to complete the free Power Query course?

    The Power Query training course is designed for flexibility, allowing participants to complete it at their own pace based on individual preferences and schedules.

  • How can Power Query benefit my career?

    Proficiency in Power Query enhances your data processing and transformation skills, making you a valuable asset in roles involving data analytics, business intelligence, and data-driven decision-making. It widens your skill set, contributing to improved career prospects in data-related fields.

Related Courses

  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.