Description

Table of Content

Unit 1: Basic Excel
Introduction to Excel
Excel Interface and Navigation
Data Entry and Formatting
Basic Formulas and Functions
Cell Referencing and Ranges
Working with Rows and Columns
Simple Chart Creation

Unit 2: Intermediate Excel
Advanced Formulas and Functions
Data Sorting and Filtering
Advanced Charting
PivotTables and PivotCharts
Data Validation
Conditional Formatting
Data Tables and What-If Analysis

Unit 3: Advanced Excel
Advanced PivotTable Techniques
Power Query and Data Connections
Macros and Automation
Advanced Data Analysis with Excel
Collaborative Features (Comments, Sharing)
Excel Add-ins and Customization
Excel Tips and Tricks