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