Preview Advanced Excel Live Course with Recorded Sessions| Dashboard Building | No Theroy Only Practical Learning Approach

Back

Let's see what we will learn in this course

Chapter 1: Excel Overview - Goal Seak & Formulae

Excel Overview & Goal Seak

Excel File for Session-1st

Excel Formulae & Functions (Math & Text)

Excel File For Session-2nd

Chapter 2: Cell Reference & Advanced Functions (AND OR)

Cell Reference & Types of Cell Reference

Excel File For Session- 3rd (Cell Reference)

Advanced Functions Session 1 - AND , OR

Excel File for Session - 4 ( AND OR)

Chapter 3: Important Advanced Functions (IF, VLOOKUP, INDEX & MATCH)

Advanced Functions Session 2 - IF, Vlookup Basic, Column, Row

Excel File for Session - 5 (IF & Vlookup Basic)

Advanced VLOOKUP with using INDEX & MATCH

Excel File for Session - 6 (Advanced Vlookup , Index, Match)

Chapter 4: More Advanced Formulas and Functions and Important Shortcut with using Excel Features

Advanced Functions with More Realworld Examples (Index with Match & Approx Vlookup)

Excel File for Session - 7 (Advanced Functions More Realworld Examples)

More Advanced Functions - LEFT VLOOKUP, SUMIF & SUMIFS, COUNTIF & COUNTIFS) & SHORTCUTS, FIND & REPLACE OPTIONS

Excel File for Session - 8 (More Advanced Functions - LEFT VLOOKUP & SUMIF, COUNTIF....)

Chapter 5: Pivot Table (Basic) & Conditional Formatting

Advanced Conditional Formatting & Text to Column Feature

Excel File for Session - 9 (Advanced Conditional Formatting & Text to Column Feature)

PIVOT TABLE ( BASIC)

Excel File for Session - 10 (Pivot Table Basic)

Chapter 6: HR DASHBOARD PROJECT WITH USING ADVANCED PIVOT TABLE

Advanced Pivot Table with Examples

Excel File for Session - 11 ( Advanced Pivot Table)

HR Dashboard Practical Project

Excel File for Session - 12 ( HR DASHBOARD)

Final Quiz for Advanced Excel