Fun With Excel – Full FastTrack Course 

Duration:  4 Weeks - 2 Sessions per Week (8 sessions of 1:15 Hours each, Over 10 Hours live Classes)

Teaching Mode:  Online with Live Instructors (Not recorded videos, immediate doubt clearing)

TOPICS COVERED

1. Perform basic calculations with formulas and functions

1. Addition, Subtraction and other Mathematical functions

2. Min & Max functions 

3. Absolute & Relative Cell reference 

4. Basic IF statements 

2. Text and Date (in text format) functions  

1. Working with Text

1. LEFT, RIGHT

2. LEN

3. TRIM

4. Concatenate 

2. Date functions 

3. Logic & Conditional formulae

1. Logic functions (AND, OR etc.) 

2. Conditional Functions - SUMIF / COUNTIF etc. 

3. IFERROR 

4. Lookups (Both)

1. VLOOKUP

2. HLOOKUP

5. Working with Data (filtering, sorting etc.)

1. Filtering

2. Advanced Filters 

3. Sorting 

6. Basic Graphs & Charts

1. Different Types of Charts

2. Making charts practically 

7. Data validation, Dropdown lists etc.

1. Validation of Data 

2. Dropdowns   

8. Pivot Tables

1. Create basic Pivot tables

2. Apply Filters 

3. Auto-refresh 

9. Professionally format spreadsheets

1. Basics of Formatting 

2. Number Formatting

3. Date Formats 

4. Tables 

5. Conditional Formatting 

10. Multi-Conditional Logic Functions

1. SUMIFS (Multiple conditions) 

2. COUNTIFS 

3. Other Multi-conditional functions 

11. Advanced formulae (2 Hours)

1. INDEX

2. MATCH 

12. Basic automation using Macros (No coding)

1. Introduction to VBA Basics with use case 

2. Intro to Macros 

3. Recording of Macro 

13. Excel Tips & Tricks  

1. Shortcuts 

2. Auto-filling

3. Transpose

4. Working with multiple sheets / Links

5. URLs in Excel

6. Text to Columns

14. Wrapping Up & Quiz  

1. Recap of Topics 

2. Tips for Self-study and continuous learning