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