Excel 预测分析、自动化和 AI - 无代码
Excel Predictive Analytics, Automation, and AI - No-Code
- 1 - Introduction - Course Outline and Learning Objectives
- 1 -Introduction
- 2 -Learning Objectives
- 2 - Foundations of Predictive Analytics with Excel
- 1 -Foundations of Predictive Analytics
- 2 -Forecast sales using 2D line chart and forecast sheet
- 3 -Trend and Linest
- 4 -Forecasting with Exponential smoothing and Excel Exercise
- 3 - Advanced Forecasting and Automation in Excel
- 1 -What - If Analysis Intro
- 2 -What - If Analysis Data Table in Excel
- 3 -Scenario Manager
- 4 -Solver Intro
- 5 -Excel Solver Exercise
- 4 - Automating Workflows with Excel Macros, VBA, and AI Tools
- 1 -Macro in Excel
- 2 -Python in Excel
- 3 -Results Interpretation of Python Exercise
- 4 -ChatGPT_for_Excel_Tips
- 5 -ChatGPT response to Excel - Excel Functions and OCR
- 6 -Chatgpt response to query - Excel Pivot Table
- 7 -Chatgpt response to Excel 4 - Generate VBA code
- 8 -Chatgpt response to Excel 5 - Your Personal Tutor
- 9 -Chatgpt response to Excel 6 - Analyze Excel File
- 10 -Chatgpt response - Summary
- 5 - Advanced Machine Learning Models without Coding
- 1 -Intro to Logistic regression model
- 2 -Logistic regression model - example
- 3 -Logistic regression model - example interpretation
- 4 -Intro to K-means clustering
- 5 -K- means clustering in excel
- 6 -Intro to Weighted Scoring
- 7 -Weighted Scoring - Excel Example
- 6 - Dynamic Data Visualization and Interactive Dashboards
- 1 -Introduction to PowerBI
- 2 -Introduction to Powerpivot with example in excel and interpretation
- 3 -Utility Bills Tracking
- 4 -Machine Learning in Excel
- 5 -Sparklines
- 7 - Connecting Excel to Easy Data Sources for Analysis
- 1 -Power Query and Pivot Tables in Excel
- 2 -Auto Update
- 8 - Conclusion and Next Steps
- 1 -Conclusion and Next Steps