Fun With Excel – Full Mastery Course 

Duration:  30 Hours (15 sessions of 2 Hours each, Final Quiz)

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

1. Perform basic calculations with formulas and functions (2 Hours)

1. Addition, Subtraction and other Mathematical functions

2. Min & Max functions 

3. Absolute & Relative Cell reference 

4. FLOOR & CEIL

5. Basic IF statements 

2. Text and Date (in text format) functions (2 Hours) 

1. Working with Text

1. LEFT, RIGHT

2. LEN

3. TRIM

4. Concatenate 

2. Date functions 

1. Basics of Date & Time (DATE, DAY, NOW, TIME etc.) 

2. Convert date to text

3. Convert text date to date 

3. Logic & Conditional formulae (2 Hour)

1. Logic functions (AND, OR etc.) 

2. Conditional Functions - SUMIF / COUNTIF etc. 

3. IFERROR 

4. Lookups (Both) (2 Hour)

1. VLOOKUP

2. HLOOKUP

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

1. Filtering

2. Advanced Filters 

3. Sorting 

6. Basic Graphs & Charts (2 Hour)

1. Different Types of Charts

2. Making charts practically 

7. Data validation, Dropdown lists etc. (2 Hour)

1. Validation of Data 

2. Dropdowns  

3. Custom Validation 

8. Pivot Tables (2 Hour)

1. Create basic Pivot tables

2. Apply Filters 

3. Auto-refresh 

9. Professionally format spreadsheets (2 Hour)

1. Basics of Formatting 

2. Number Formatting

3. Date Formats 

4. Tables 

5. Conditional Formatting 

10. Advanced Charts (2 Hour)

1. Advanced charts 

2. Multiple axis charts 

11. Multi-Conditional Logic Functions (2 Hours)

1. SUMIFS (Multiple conditions) 

2. COUNTIFS 

3. Other Multi-conditional functions 

12. Advanced formulae (2 Hours)

1. INDEX

2. INDIRECT  

3. Nested IF and other Nested Formulae 

4. Dependent dropdowns 

13. Basic automation using Macros (No coding) (2 Hours)

1. Introduction to VBA Basics with use case 

2. Intro to Macros 

3. Recording of Macro 

4. Inserting a Button and Link a Macro

14. Excel Tips & Tricks (2 Hour) 

1. Shortcuts 

2. Auto-filling

3. Transpose

4. Working with multiple sheets / Links

5. URLs in Excel

6. Text to Columns

7. Spelling, Thesaurus

15. Wrapping Up & Quiz (2 Hour) 

1. Recap of Topics 

2. Quiz

3. Clearing of Doubts about Quiz  

4. Tips for Self-study and continuous learning