Course Syllabus:

Week 1: Introduction to MS Excel

Understanding the MS Excel interface
Creating and saving worksheets
Entering and editing data
Basic arithmetic operations
Using formulas and functions
Week 2: Working with Data

Sorting and filtering data
Creating and using charts
Using conditional formatting
Working with data validation
Protecting worksheets
Week 3: Advanced Formulas and Functions

Using logical functions (IF, AND, OR)
Using financial functions (PMT, PV, FV)
Using statistical functions (AVERAGE, SUM, COUNT)
Using lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
Creating custom functions
Week 4: Data Analysis and Reporting

Creating pivot tables and pivot charts
Using data analysis tools (Descriptive Statistics, Regression)
Creating professional reports
Sharing and collaborating on worksheets