Microsoft Excel Course – Basic to Advanced Level

Course Curriculum

Chapter 1: Getting started in Excel

Lecture 1: Understanding Excel Structure and Customize Ribbons

Lecture 2: Data Entry and Formatting

Chapter 2: Autofill and Cell Reference

Lecture 1: Autofill Number and Text

Lecture 2: Autofill Date

Lecture 3: Autofill Series and Custom Option

Lecture 4: Flash Fill – Updated

Lecture 5: Cell Reference in Excel

Lecture 6: Draw Tab in Excel – Updated

Chapter 3: Mathematical Operators and Math Functions

Lecture 1: Math Operators Based Equation in Excel

Lecture 2: Math Functions in Excel

Lecture 3: Advance Math Functions

Lecture 4: Advance Math Functions Part 2

Lecture 5: Using of Wild Card in Math Functions

Lecture 6: Database Math Functions

Chapter 4: How to Print Excel Data

Lecture 1: Print related options in Excel Part 1

Lecture 2: Print related options in Excel Part 2

Chapter 5: What if Analysis Tools

Lecture 1: What if Analysis – Goal seek

Lecture 2: Analysis Add in – Solver

Lecture 3: What if Analysis – Scenario Manager

Lecture 4: PMT function – EMI calculator

Lecture 5: Data table – Create Loan Table

Lecture 6: PDURATION Function – Updated

Chapter 6: Text Functions and Text to Column

Lecture 1: Text Function – Upper, Lower, Proper, Trim

Lecture 2: Text Function – Right and Left Function

Lecture 3: Text Function – Find Function and task

Lecture 4: Text Function – Task Solution and Nested Left

Lecture 5: Text Function – Find and Left Nesting

Lecture 6: Text Function – MID Function

Lecture 7: Text Function – Mid task and solution

Lecture 8: Text Function – Concatenate Function

Lecture 9: Text Function – Concatenate task and solution

Lecture 10: Concat and Textjoin Function – Updated

Lecture 11: Text Function – Replace Function

Lecture 12: Text Function – Replace task and Solution

Lecture 13: Text Function – Substitute Function

Lecture 14: Text Function – Len, Rept, Exact and Search Function

Lecture 15: Numbervalue Function – Updated

Lecture 16: Text to Column

Chapter 7: Define Name, Hyperlink and Data Outline

Lecture 1: Working with Define Name

Lecture 2: Hyperlink in Excel

Lecture 3: Group, Ungroup and Subtotal

Chapter 8: Handling Data Security in Excel

Lecture 1: Workbook protect

Lecture 2: Protect Worksheet Data

Lecture 3: Hide Formulas and unlocked Cell

Lecture 4: Protect File with password

Lecture 5: Share workbook

Chapter 9: Logical Operators and Logical Functions

Lecture 1: If Function – Logical Test

Lecture 2: If Function – with Equation and task

Lecture 3: If Function – Nested If

Lecture 4: If Function – advance

Lecture 5: If Function – advance – 2

Lecture 6: IFS Function – Updated

Lecture 7: AND , OR Function

Lecture 8: AND, OR, IF Nested

Lecture 9: AND, OR Advance

Lecture 10: XOR Function – Updated

Chapter 10: Pivot Table in Excel

Lecture 1: Pivot Table – Intro

Lecture 2: Pivot Table – Manage Field Area

Lecture 3: Pivot Table – Value Field, Report and more

Lecture 4: Pivot Table – Slicer and Duplicate Pivot

Lecture 5: Pivot Table – Group to Manage Date and Value

Lecture 6: Pivot Table – Insert Calculated Field

Lecture 7: Power Pivot – Updated

Chapter 11: Chart Preparation in Excel

Lecture 1: Chart Preparation

Lecture 2: Chart Preparation – Advance

Lecture 3: Chart Preparation – Customize

Lecture 4: Power Map in Excel – Updated

Lecture 5: Quick Analysis and Chart Recommendation – Updated

Chapter 12: Date and Time Management in Excel

Lecture 1: Date and Time setting

Lecture 2: Date and Time Format

Lecture 3: Date and Time Functions

Lecture 4: NETWORKDAYS Function

Lecture 5: DATEDIF Function

Chapter 13: Using Filter and Sorting option

Lecture 1: How to use Filter

Lecture 2: Date and Color Filter

Lecture 3: Advanced Filter option

Lecture 4: Sorting and Custom Sort

Chapter 14: Conditional Formatting in Excel

Lecture 1: Conditional Formatting – How to Apply

Lecture 2: Conditional Formatting – Types of Rules

Lecture 3: Conditional Formatting – Icon Set

Lecture 4: Conditional Formatting – Manage Rules

Lecture 5: Conditional Formatting – Create New Rules