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