Insight into Advanced Excel

Curriculum

18 Sections
22 Lessons
15 Days

Expand all sectionsCollapse all sections

Gripping the basics
First two classes of the course to ensure you have a strong grip over the basics of MS Excel
2
- 2.1
  Class 1
- 2.2
  Class 2
Conditional Calculations
2
- 3.1
  Class 3 – How to write a formula, Cell References, If and Nested If
- 3.2
  Class 4 – Practice of IF & SumIf
Pivot Tables
1
- 4.1
  Class 5 – Pivot Tables (Basic to Advanced with Slicers and Timelines)
Filters
1
- 5.1
  Class 6 – Filter, Advanced Filter, Auto Filter & Removing duplicates
Copy paste tricks
1
- 6.1
  Copy paste tricks
  35 Minutes
Excel Shortcuts
1
- 7.1
  Basic Excel Shortcuts – Excel File
Text to column, flash fill and Date Functions
1
- 8.1
  Class 7 – Text to column, flash fill and Date functions
Match and Vlookup
1
- 9.1
  Class 8 – Match and Vlookup
Index Match
1
- 10.1
  Class 9 – Index Match & Find and Replace
Discussion of 1st Assessment
2
- 11.1
  Assessment (Part 1) – Nested If for City Names
- 11.2
  Assessment (Part 2) – SumIf for Sales
Concatenate, Left, Right & Middle
1
- 12.1
  Class 10 – Left, Right & Middle (Simple to Complex)
Middle (Last case), Custom formatting & Other short formulae
1
- 13.1
  Class 11 – Middle (Last case), Randbetween, Custom Formatting
Fill in series & Practice of Index Match
2
- 14.1
  Class 12 – Part 1 (Fill in series & Index Match Example)
- 14.2
  Class 12 – Part 2 (Index Match Example)
Data Tab and Offset
1
- 15.1
  Class 13 – Consolidate, Grouping, Subtotal & Offset
Infinite index match
1
- 16.1
  Class 14 – Infinite index match
Conditional formatting, Charts and other misc.
1
- 17.1
  Class 15 – Conditional formatting, SumIf with Not, Precedent, Quick Analysis, Charts and Graphs
Final assessment
1
- 18.1
  Final Assessment
How to register and access courses
1
- 19.1
  How to register and access course

Class 1

Summary of Basics

3 Comments

03066930209

April 3, 2022

Reply

nice
iamnaveedbasheer

August 1, 2022

Reply

brother you are great with great understanding
Qaisarabbas

September 30, 2022

Reply

Nice

Insight into Advanced Excel

Curriculum

Class 1

3 Comments

Leave a Comment

Register

Modal title