Import financial statements into Excel

#1

Lesson 1: What is Power Query?

#2

Lesson 2: Phases in Power Query

#3

Lesson 3: Why Power Query?

#4

Lesson 1: Introduction to Data Sources in Power Query

#5

Lesson 2: Connecting to data from Current workbook

#6

Lesson 3: Connecting to data from Excel Workbook

#7

Lesson 4: Connecting to Data From CSV or Text file

#8

Lesson 5: Connect to Data from Databases: MS Access

#9

Lesson 6: Connect to data from Database: SQL Server

#10

Lesson 7: Import data from PDF

#11

Lesson 8: Import data from web

#12

Power Query Data types

#13

Filter columns

#14

Sorting columns

#15

Rearrange columns

#16

Filling missing values

#17

Splitting columns

#18

Split data with delimiter

#19

Keep rows

#20

Transpose columns

#21

Lesson 1: Load destinations

#22

Lesson 2: Load destinations Demo

#23

Append queries

#24

Append queries with different column names

#25

Append multiple Excel files

#26

Merging queries

#27

Introduction to Join kinds

#28

Join kinds sample Dataset

#29

Left Outer Join

#30

Right outer join

#31

Full outer

#32

Inner Join

#33

Left Anti Join

#34

Right anti join

#35

Join Kinds demo

#36

Lesson 1: Grouping data with GROUP BY

#37

Lesson 1: Pivot rows

#38

Lesson 2: Pivot rows 2

#39

Lesson 3: Unpivot columns

#40

Adding columns Introduction

#41

Adding Conditional columns

#42

Adding Columns from Examples

#43

Adding Columns from numbers

#44

Adding custom columns

#45

Adding Columns from Dates

#46

Lesson 1: Introduction to data profiling

#47

Lesson 2: Data profiling demo

#48

Custom column: IF Statement

#49

Lesson 1: Copying queries

#50

Lesson 2: Duplicte vs reference

#51

Lesson 2: Data Source error

#52

Lesson 3: Column not found error

#53

Lesson 4: Cell Level errors

#54

Lesson 5: Handling errors with If otherwise

#55

Lesson 4: Supported Excel versions for Power Query

#56

Introduction to the Power Query editor

#57

Identify column headers

#58

Lesson 9: Importing Data from folder

#59

Remove Rows

#60

Lesson 1: Introduction to errors in Power Query

#61

Course conclusion

#62

Course Introduction

#63

Course Community

#64

Project 1

#65

Project 2

#66

Get started

#67

Import financial statements into Excel

View full lessons Check course learning page