Course Description :
Excel has evolved into a powerful data analytics and AI-enabled tool. Modern Excel for Data Analysis teaches you how to clean, analyze, visualize, and automate data using modern Excel features like PivotTables, Power Query, Power Pivot, DAX, and AI tools. Whether you’re a beginner or a professional, this course helps you turn raw data into insights, dashboards, and smart, data-driven decisions for real-world business and research use.
Course Content
1. Spreadsheet fundamentals
1.1 Introduction Microsoft Excel
You don't currently have access to this content
2. Shortcuts for Navigating Data in a Spreadsheet
2.0 Navigating Excel interface
You don't currently have access to this content
2.1 Shortcuts for Entering & Editing Data
You don't currently have access to this content
2.2 Data Types
You don't currently have access to this content
2.3 Dates in Excel
You don't currently have access to this content
2.4 Number Formatting
You don't currently have access to this content
2.5 Data Validation
You don't currently have access to this content
2.6 Remove Duplicates and Condtional formatting
You don't currently have access to this content
2.7 Sortig and Filtering
You don't currently have access to this content
Downloadable resources
You don't currently have access to this content
3 Data Analysis with Pivot tables
3.1 Pivot table analysis
You don't currently have access to this content
3.2 Modify Pivot table
You don't currently have access to this content
3.3 Automatic Date Group
You don't currently have access to this content
3.4 Summarize value
You don't currently have access to this content
3.5 Slicer and Time line
You don't currently have access to this content
3.6 Calculated Field Pivot table
You don't currently have access to this content
3.7 Data Analysis Using AI
You don't currently have access to this content
Downloadable resources
You don't currently have access to this content
4. Data Visualization in Excel
4.1 Basic Charts (Bar, Line, Pie, Column)
You don't currently have access to this content
4.2 Advanced Charts (Waterfall, Sunburst, Funnel, Treemap)
You don't currently have access to this content
Xirfadlay