About This Course
Course Curriculum
Data Analytical With Excel
00:13:18
Activating
00:03:34
Logging operational
00:05:34
Power pivot
00:01:02
Office with power pivot
00:01:32
Enable power pivot in Excel
00:01:29
Power query
00:03:30
Connecting a source
00:04:26
Preparing query
00:04:51
Cleansing data
00:07:37
Enhancing queries
00:09:21
Creating a model
00:06:02
Building
00:06:56
Creating lookup
00:07:01
Analyse data tables
00:08:42
Analyse charts
00:08:14
Refresh data source
00:07:34
Update queries
00:09:18
Create new report
00:07:18
First 5 videos free!
Already have an account? Sign in
This course includes:
- 19 video lessons
- 00:16:39 of content
- Lifetime access
- Access on mobile and desktop
- Certificate of completion
Created: Jan 04, 2023
Updated: Dec 18, 2025