Microsoft Excel Data Analysis: Become a Data Analysis Expert

Introduction to Excel Data Types and Structures

Sorting and Filtering Data

Data Validation Techniques

Using Text Functions for Data Cleaning (TRIM, SUBSTITUTE, CLEAN) 

Handling Duplicates and Missing Data

Descriptive Statistics in Excel (Mean, Median, Mode)

Using Excel Functions for Basic Data Summarization (SUM, COUNT, AVERAGE) 

Introduction to Pivot Tables and Pivot Charts

Conditional Formatting for Data Insights

Advanced Filtering and Sorting Techniques

Lookup and Reference Functions for Data Analysis (VLOOKUP, HLOOKUP, INDEX, MATCH) 

Using Excel Tables for Dynamic Data Analysis

Analyzing Data with Excel's Data Analysis Toolpak

Advanced Pivot Table Techniques (Calculated Fields, Slicers) 

Performing Statistical Analysis (Regression, Correlation, ANOVA) 

Introduction to Power Pivot for Data Modeling

Creating and Customizing Charts and Graphs

Using Sparklines and Data Bars for Quick Insights

Advanced Charting Techniques (Combo Charts, Dynamic Charts) 

Building Interactive Dashboards with Excel

Introduction to Excel Macros for Data Analysis

Automating Reports with VBA

Using Solver for Optimization Problems

Scenario Analysis and What-If Analysis