Sign In
Sign Up
Sign Up
Course Content
Module 1. Spreadsheet fundamentals
0/2
1.1 Introduction Microsoft Excel
22:12
Course Files
Module 2. Shortcuts for Navigating Data in a Spreadsheet
0/8
2.0 Navigating Excel interface
11:10
2.1 Shortcuts for Entering & Editing Data
07:49
2.2 Data Types
09:43
2.3 Dates in Excel
13:30
2.4 Number Formatting
09:05
2.5 Data Validation
14:04
2.6 Removing Duplicates, conditional formatting
11:08
2.7 Filtering Data and sorting Data
07:02
Module 3. Data Analysis with Pivot tables
0/7
3.1 Creating a Pivot Table
17:32
3.2 Modifying Pivot Table Views
07:51
3.3 Automatic Date Grouping
06:32
3.4 Summarize Values By Options
07:10
3.5 Slicers & Timelines
09:57
3.6 Calculated Fields
10:37
3.7 Microsoft Copilot/Google Gemini
08:40
Module 4. Data Visualization in Excel
0/4
4.1 Basic Charts (Bar, Line, Pie, Column)
21:00
4.2 Advanced Charts (Waterfall, Sunburst, Funnel, Treemap)
13:33
4.3 Interactive Dashboards (Form Controls, Linked Charts, Dynamic Ranges)
10:36
4.4 Conditional Visualizations (Sparklines, Icon Sets)
07:21
Module 5. Advanced Data Analytics Features
0/3
5.1 Power Query (Data Extraction & Transformation)
17:41
5.2 Power Pivot (Data Models & Relationships)
07:51
5.3 DAX Functions for Analysis
08:48
Module 6. Excel with AI
0/5
6.1 Excel Chatgpt (AI Assistant for Analytics)
08:49
6.2 AI-Powered Forecasting & Predictive Analytics
15:10
6.3 Automated Data Cleaning & Smart Suggestions
08:56
6.4 AI-Generated Charts & Dashboards
14:50
6.5 AI-Powered Data Storytelling (Automatic Report Narratives)
13:00
Module 7. Practical Applications of Excel in Data Analytics
0/6
7.1 Financial Data Analysis
17:19
7.2 Sales & Marketing Analytics
18:04
7.3 HR & Workforce Analytics
14:30
7.4 Supply Chain & Logistics Analytics
14:45
7.5 Part 1 Academic / Research Data Analytics
24:27
7.5 Part 2 Academic / Research Data Analytics
07:01
Module 8. Case Studies & Projects
0/4
8.1 Part 1 Building a Sales Dashboard with Pivot Tables & AI Insights
26:56
8.1 Part 2 Building a Sales Dashboard with Pivot Tables & AI Insights
13:37
8.2 Cleaning messy datasets with Power Query & Smart Fill
09:55
8.3 Forecasting future demand with AI-powered Excel forecasting
05:52
Modern Excel for Data Analysis (2025)
0% Complete