Introduction to Power Query in Excel Basics Course

Free Power Query Course with Certificate

4.57678 Learners EnrolledBeginner Level

Unlock the power of data transformation with SkillUp’s free Power Query course. This practical training covers everything you need to master Power Query in Excel. The certification is simplified, making it easy to grasp data transformation techniques. Learn from our expert trainer and effortlessly elevate your skills in shaping and transforming data.

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.

Get your team a digital skilling library

with unlimited access to live classes

digital skilling library

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

prevNext

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