Microsoft Excel – Excel from Basics to Advance

Course Curriculum

Chapter 1: Basics of Excel

Lecture 1: Demo of Time Calculation in Excel

Lecture 2: Demo of 3D SUM

Lecture 3: Introduction to Excel

Lecture 4: Learn various methods of opening a new or an existing Excel file.

Lecture 5: Learn how Excel recognises different data, i.e date, time, text, digits.

Lecture 6: Difference between Function & Formula:

Lecture 7: Learn the application of BODMAS in Excel.

Lecture 8: Learn to customise Tabs, add/delete new tabs, hide/unhide tabs

Lecture 9: Learn various uses of Paste Special, Transpose etc.

Chapter 2: Fill Series:

Lecture 1: Fill Series:

Lecture 2: Flash Fill:

Chapter 3: References

Lecture 1: Relative Reference

Lecture 2: Absolute Reference

Lecture 3: Mixed Reference

Chapter 4: Conditional Formatting:

Lecture 1: Basics of Conditional Formatting:

Lecture 2: New Rule in Conditional Formatting:

Lecture 3: Advance Conditional Formatting:

Chapter 5: 3D SUM:

Lecture 1: 3D SUM

Chapter 6: Hyperlink

Lecture 1: Hyperlink

Chapter 7: Drop-Down List:

Lecture 1: Simple Drop-Down List:

Lecture 2: Dependent Drop-Down List:

Lecture 3: Multiple Dependent Drop-Down List:

Chapter 8: Date Functions

Lecture 1: Default Date

Lecture 2: Basics of Date in Excel

Lecture 3: Find Day from Date

Lecture 4: Learn to add date, months & years in a particular date with the help of e-date.

Lecture 5: Learn more date functions

Lecture 6: Learn to know the last date of next month, or the following month.

Lecture 7: Learn how to compute working days considering different weekends.

Lecture 8: Learn to calculate exact number of years, months & days from a historic date.

Chapter 9: Subtotal

Lecture 1: Learn the use of SUBTOTAL function in Excel, learn how to use SubTotal under Dat

Lecture 2: Learn the amazing use of adding filter & slicer in a given data.

Chapter 10: MOD QUOTIENT:

Lecture 1: Learn the use of MOD & QUOTIENT functions in Excel with an amazing example.

Chapter 11: ERRORS

Lecture 1: Learn the list of 8 different types of common errors we get in Excel.

Lecture 2: IFERROR, Difference between System Generate Errors & Manual Errors.

Lecture 3: Various Error Alerts

Chapter 12: LOOKUPS

Lecture 1: Learn to use LOOKUP function in vertical and horizontal tables

Lecture 2: Learnt the use of LOOKUP with Absolute Reference (locking the cell)

Lecture 3: HLOOKUP on a horizontal table

Lecture 4: VLOOKUP on a vertical table

Lecture 5: Learn the difference between TRUE & FALSE, Exact & Approximate Match.

Lecture 6: Advance V-Lookup with Mixed Reference

Lecture 7: Multi-Dimensional V-Lookup with CONCATENATE Function

Chapter 13: Time Calculation in Excel

Lecture 1: Time Calculation in Excel

Chapter 14: Financial Functions

Lecture 1: Learn to calculate depreciation by different methods

Lecture 2: Learn to calculate EMI & the portion of principal & interest in EMI

Lecture 3: Learn to calculate future value in Excel

Lecture 4: Learn to calculate Net Present Value & Internal Rate of Return of any investment

Lecture 5: Calculation of NPV IRR for cash inflows on different date in Excel

Chapter 15: Freeze Panes

Lecture 1: Freeze Panes

Chapter 16: IF Function

Lecture 1: Learn the use of logical test & parameters in IF function

Lecture 2: IF AND: Learn to use more than one logical test in IF function

Lecture 3: IF OR: Learn to use of OR function in IF function to provide options in logical

Lecture 4: IF NOT: Learn to use of NOT function in logical test to get false or blank.

Lecture 5: NESTED IF: Learn how to use multiple IFs to get answer to multiple parameters.

Lecture 6: Make Profit & Loss Account with the help of IF, SUM functions & Name Manager

Lecture 7: Learn to prepare Income Tax Slabs for various % or Tax Rates.

Lecture 8: Income Tax Computation for USA

Lecture 9: Income Tax Computation for India

Lecture 10: Income Tax Computation for UK

Chapter 17: WhatifAnalysis:

Lecture 1: Goal Seek

Lecture 2: Learn advance use of Goal Seek

Lecture 3: Learn Data Table to calculate various interest rates

Lecture 4: Learn advance use of Data Table with both row and column input cells.

Lecture 5: Scenario Manager in different scenarios, create & compare Best & Worst Scenarios

Chapter 18: INDEX & MATCH FUNCTIONS

Lecture 1: Learn the basic use of INDEX & MATCH Functions in Excel.

Lecture 2: Learn advance use of INDEX & MATCH with IFERROR Function.

Lecture 3: INDEX + MATCH + MATCH Functions together

Lecture 4: INDEX + MATCH (left to right & right to left use)

Lecture 5: INDEX MATCH with MAX Functions

Lecture 6: INDEX MATCH(Array) Ctrl + Shift + Enter

Lecture 7: VLOOKUP + MATCH Functions together

Lecture 8: Good to know usage

Chapter 19: Macros & Relative Reference

Lecture 1: Basics of Macro

Lecture 2: Macro records all Excel Data Types.

Lecture 3: What is VBA Editor?

Lecture 4: How to Save a Macro File

Lecture 5: More Examples of Macros

Lecture 6: How to maintain chronology?

Lecture 7: The Fantastic use of Relative Reference in Macro

Chapter 20: Protect Sheet