Free Power Query in Excel Course for Beginners

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