完整的 Microsoft Excel 数据分析训练营
- Chapter_1-Module_1_Excel_Basics
- 1. Navigating the Excel Interface
- 2. Basic Excel Functions and Formulas
- 3. Entering and Editing Data
- 4. Sorting and Filtering Data
- 5. Data Validation
- Chapter_2-Module_2_Data_Cleaning_and_Preperation
- 6. Removing Duplicates
- 7. Handling Missing Values
- 8. Data Transformation Techniques
- 9. Structuring Data
- 10. Using Text Functions
- Chapter_3-Module_3_Data_Analysis_Techniques
- 11. Mean, Median, Mode
- 12. Standard Deviation and Variance
- 13. Data Visualization with Charts
- 14. Creating Pivot Tables
- 15. Analyzing Data with Pivot Tables
- 16. Using Pivot Charts for Visualization
- Chapter_4-Module_4_Advanced_Excel_Functions
- 17. IF, AND, OR Functions
- 18. Conditional Formatting
- 19. VLOOKUP, HLOOKUP, INDEX, MATCH
- 20. Using Dynamic Ranges
- 21. Install Data Analysis Toolpak
- 22. Using Analysis Tools (e.g., regression, correlation)
- Chapter_5-Module_5_Data_Visualization
- 23. Types of Charts and their Uses
- 24. Customizing Chart Elements
- 25. Using Sparklines
- 26. Creating Interactive Dashboards
- Chapter_6-Module_6_Case_Studies_and_Real_World_Applications
- 27. Analyzing Sales Data
- 28. Monthly Budget Analysis
- 29. Sales Projection and Forecast Calculation