
Take your Excel skills to the next level with this engaging 3-hour course designed for foundational to intermediate users.
Discover how AI can simplify your workflow, automate complex formulas, clean and analyze data, and optimize spreadsheets for efficiency. Through real-world examples, interactive demos, and
hands-on exercises, you’ll learn how AI can suggest formulas, identify patterns, and improve spreadsheet accuracy.
No AI experience needed—just bring your curiosity and get ready to revolutionize how you work with Excel!
Excel as a Tool for AI
• Exploring Excel’s capabilities with data analysis
• Introduction to Microsoft Excel’s AI features (e.g., Ideas, Data Types,
Predictive Analytics)
• Overview of integrating AI services with Excel (Power Query, Power BI)
AI Driven Data Analysis with Formulas
• Overview of essential Excel functions that support AI (e.g., AVERAGE,
SUMIF, TEXTJOIN)
• Key trend analysis functions (e.g., FORECAST, TREND)
• Leveraging Excel’s Ideas feature for trend prediction and insights
Hands-On Activity: Using forecasting formulas for sales data
projection
• Task: Participants will create a simple forecasting model in Excel using
historical data