Curriculum
Course:
Advanced Excel Mastery with AI Integration
Login
Curriculum
Advanced Excel Mastery with AI Integration
Basic Excel Foundations (Week 1-3, 6 Sessions)
0/9
Introduction to Excel: Interface, ribbons, workbooks, and worksheets.
7m00s
Data entry formatting (fonts, colors, borders).
8m25s
Relative vs. absolute references.
3m04s
Preview
Simple formulas: IF, basic arithmetic (+, -, *, /),
20m56s
Data organization Sorting, filterin
4m45s
Basic charts: Bar, line, pie, and chart formatting. freeze panes.
15m29s
Printing and saving: Page layout, PDF export, and file management.
1m43s
Filter & Condition
9m31s
Hands-On: Create a personal budget tracker with basic formulas and a chart.
18m13s
Advanced Formulas and Functions (Week 4-6, 6 Sessions)
0/7
Test Function Class 1
22m31s
Test Function Class 2
15m54s
Lookup functions: VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP.
32m25s
Text functions: LEFT, RIGHT, MID, CONCAT, TEXTJOIN.
27m07s
Financial functions: PV, NPV, IRR.EDATE, DATEDIF, NETWORKDAYS.
13m28s
Build a dynamic inventory tracker using advanced formulas.
Video lesson
Advance Chart and Waffle chart
16m49s
Module 1: Excel Fundamentals Refresher (Week 1-2, 4 Sessions)
0/8
Spreadsheet navigation, shortcuts, and customization.
Video lesson
Data types, formatting, and conditional formatting basics.
Video lesson
Essential functions: SUM, AVERAGE, IF, COUNTIF, VLOOKUP, HLOOKUP.
Video lesson
Data validation and error-checking techniques.
Video lesson
Introduction to tables and structured references.
Video lesson
Hands-On: Create a formatted sales tracker with basic calculations.
Video lesson
AI Teaser: Overview of AI-driven data cleaning tools (e.g., Power Query with AI suggestions).
Video lesson
Data cleaning
16m15s
Advanced Formulas and Functions (Week 3-5, 6 Sessions)
0/9
Master complex formulas for data manipulation and analysis.
9h
Logical functions: IFERROR, IFS, AND, OR, nested IFs.
12m27s
Lookup functions: INDEX, MATCH, XLOOKUP, XMATCH.
Video lesson
Text functions: LEFT, RIGHT, MID, CONCAT, TEXTJOIN, FIND, SEARCH.
Video lesson
Date and time functions: EDATE, EOMONTH, DATEDIF, NETWORKDAYS.
Video lesson
Array formulas and dynamic arrays (FILTER, SORT, UNIQUE, SEQUENCE).
Video lesson
Financial functions: PV, FV, NPV, IRR for business calculations.
Video lesson
Hands-On: Build a dynamic employee payroll system using advanced formulas.
Video lesson
AI Integration: Use Excel’s built-in AI (e.g., Ideas/Insights) to suggest formula optimizations.
Video lesson
Module 3: Data Analysis with PivotTables and PivotCharts (Week 6-8, 6 Sessions)
0/9
Objective
Text lesson
Creating and customizing PivotTables.
4m9s
Grouping, filtering, and sorting data in PivotTables.
Video lesson
Calculated fields and items in PivotTables.
Video lesson
Slicers and timelines for interactive dashboards.
Video lesson
PivotCharts: Types (bar, line, pie) and formatting.
Video lesson
Connecting multiple PivotTables for complex analysis.
Video lesson
Hands-On: Analyze a retail dataset to identify sales trends using PivotTables/Charts.
Video lesson
AI Integration: Use Microsoft Copilot (if available in Excel) to generate PivotTable suggestions or Power BI for enhanced visuals.
Video lesson
Module 4: Data Visualization and Dashboards (Week 9-11, 6 Sessions)
0/7
Advanced charting: Combo charts, sparklines, waterfall, funnel charts.
Video lesson
Conditional formatting for visual insights (data bars, color scales, icon sets).
Video lesson
Designing interactive dashboards using slicers and form controls.
Video lesson
Best practices for dashboard layout and storytelling with data.
Video lesson
Linking charts with PivotTables for dynamic updates.
Video lesson
Hands-On: Build a sales performance dashboard with multiple KPIs.
Video lesson
AI Integration: Use AI tools like Tableau Public or Power BI (connected to Excel) to suggest visualizations or predict trends.
Video lesson
Module 5: Power Query for Data Transformation (Week 12-14, 6 Sessions)
0/6
Importing data from various sources (CSV, Excel, databases, web).
9m30s
Handling missing data, duplicates, and inconsistencies.
Video lesson
Advanced transformations: Pivoting, unpivoting, custom columns.
Video lesson
Automating repetitive tasks with Power Query scripts.
Video lesson
Hands-On: Clean and transform a messy customer dataset for analysis.
Video lesson
AI Integration: Explore AI-driven data profiling in Power Query or third-party tools like Alteryx for automation suggestions.
Video lesson
Module 6: Power Pivot and DAX (Week 15-17, 6 Sessions)
0/9
Introduction to Power Pivot and data models.
Video lesson
Creating relationships between tables.
Video lesson
Introduction to DAX (Data Analysis Expressions): SUMX, CALCULATE, FILTER.
Video lesson
Time intelligence functions: TOTALYTD, SAMEPERIODLASTYEAR.
Video lesson
Building measures and KPIs for advanced analysis.
Video lesson
Optimizing Power Pivot models for performance.
Video lesson
Hands-On: Create a financial dashboard with Power Pivot and DAX calculations.
Video lesson
AI Integration: Use AI to suggest DAX formulas or optimize data models (e.g., via Copilot or external tools).
Video lesson
Why?
Text lesson
Module 7: AI Implementation in Excel (Week 18-19, 4 Sessions)
0/6
Excel + Copilot Tutorial For Beginners! Master AI-Powered Spreadsheets in Minutes
7m42s
How to Use AI in Excel | Complete Beginner Tutorial (Step by Step)
20m40s
AI-driven forecasting and trend analysis in Excel.
Video lesson
Automating repetitive tasks with AI-powered macros or Power Automate flows.
Video lesson
Hands-On: Build an AI-assisted sales forecasting model using Excel and Python/Power Automate.
Video lesson
AI Focus: Explore how AI can predict outcomes or automate report generation.
Video lesson
Module 8: Job-Ready Projects and Soft Skills (Week 20, 2 Sessions)
0/6
Capstone project: End-to-end analysis (e.g., retail, finance, or HR dataset) using all learned tools.
Video lesson
Resume building with Excel and AI skills highlighted.
Text lesson
nterview preparation: Common Excel-related questions and case studies.
Video lesson
Presentation skills for showcasing dashboards to stakeholders.
Video lesson
Best practices for collaboration (e.g., OneDrive, SharePoint integration).
Video lesson
Hands-On: Present capstone project to peers, simulating a corporate meeting.
Video lesson
Video lesson
Relative vs. absolute references.
Sign In
The password must have a minimum of 8 characters of numbers and letters, contain at least 1 capital letter
I want to sign up as instructor
Remember me
Sign In
Sign Up
Restore password
Send reset link
Password reset link sent
to your email
Close
Your application is sent
We'll send you an email as soon as your application is approved.
Go to Profile
No account?
Sign Up
Sign In
Lost Password?