ONLINE EXCEL COURSE OUTLINE
Basic Excel
BASIC

Course - 1 : Fun with Excel – Basic 

Duration:  12 Hours (6 sessions of 2 Hrs each)

Course Outline:

  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. 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. Graphs & Charts (2 Hour)

    1. Different Types of Charts

    2. Making charts practically


Intermediate Excel
INTERMEDIATE

Course - 2 : Fun with Excel Intermediate

Duration:  12 Hours (6 sessions of 2 Hrs each)

Course Outline:

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

    1. Validation of Data 

    2. Dropdowns  

    3. Custom Validation 

  2. Pivot Tables (2 Hour)

    1. Create basic Pivot tables

    2. Apply Filters 

    3. Auto-refresh 

  3. Professionally format spreadsheets (2 Hour)

    1. Basics of Formatting 

    2. Number Formatting

    3. Date Formats 

    4. Tables 

    5. Conditional Formatting 

  4. Advanced Charts (2 Hour)

    1. Advanced charts 

    2. Multiple axis charts 

  5. 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

  6. Wrapping Up & Quiz (2 Hour) 

    1. Recap of Topics 

    2. Quiz

    3. Clearing of Doubts about Quiz  

    4. Introduction to Topics for Advanced Course with Use Case












Advanced Excel
ADVANCED

Course - 3 : Fun with Excel – Advanced

Duration: 12 Hours (6 sessions of 2 Hrs each)

Course Outline: 

  1. Multi-Conditional Logic Functions (2 Hours)

    1. SUMIFS (Multiple conditions) 

    2. COUNTIFS 

    3. Other Multi-conditional functions 

  2. Advanced formulae (2 Hours)

    1. INDEX

    2. INDIRECT  

    3. Nested IF and other Nested Formulae 

    4. Dependent dropdowns 

  3. 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. Mail Merge (2 Hours)

    1. Basics of Mail Merge 

    2. Examples of Real-life use cases 

    3. Process of implementing it 

  5. Tips on how to self-learn for particular use case (2 Hour)

    1. Continuous learning 

    2. Learning Sources 

    3. Practice

  6. Wrapping Up & Quiz (2 Hours)

    1. Recap of Topics 

    2. Quiz

    3. Clearing of Doubts