Microsoft Excel Data Analysis: Become a Data Analysis Expert
What you'll learn
- Overview of Data Analysis Concepts
- Introduction to Excel Data Types and Structures
- Sorting and Filtering Data
- Data Validation Techniques
- Using Text Functions for Data Cleaning (TRIM, SUBSTITUTE, CLEAN)
- Descriptive Statistics in Excel (Mean, Median, Mode)
- Conditional Formatting for Data Insights
- Using Excel Tables for Dynamic Data Analysis
- Analyzing Data with Excel's Data Analysis Toolpak
- Advanced Pivot Table Techniques (Calculated Fields, Slicers)