Zenler Player
Your course is loading. Hang tight.
Excel BI - Power Query (Excel 2013)
Back to curriculum
0% Complete
0% Complete
How to take this course
Download and set up Power Query
Getting set up
Course Files
Case Study - Scenario
How to connect to an Excel file
Activity 1
How to connect to an Text file
Activity 2
How to connect to web data
Activity 3
How to Merge and Analyse the data
Activity 4
Connect to Folders of Data
Activity 5
Bad Data
Activity 6
Unpivot data and carry out same query on different file
Activity 7
Useful Resources
Course conclusion
Introduction to Excel BI - Power Query
How to take this course
Download and set up Power Query
Preview
Getting set up
Course Files
Practical Application of Excel BI - Power Query
Case Study - Scenario
Preview
How to connect to an Excel file
Preview
Activity 1
How to connect to an Text file
Preview
Activity 2
How to connect to web data
Activity 3
How to Merge and Analyse the data
Activity 4
More advanced options
Connect to Folders of Data
Preview
Activity 5
Bad Data
Activity 6
Unpivot data and carry out same query on different file
Activity 7
Useful Resources
Course conclusion
×
This is an unpublished lesson. This lesson will not be shown for students unless you set it as Public.
Back to Dashboard
No contents are available in this lesson!
No lessons available !
Back to Dashboard
Lesson contents locked
Enroll to unlock this lesson.
Enroll to unlock
Next Lesson