Insight into Advanced Excel – (7th Batch) – E-Learners Pakistan

+923359999187
info@courses.qanoonforall.com

Last updated November 13, 2022

Insight into Advanced Excel – (7th Batch)

(9 Ratings)

240 students

Insight into Advanced Excel – (7th Batch)

Overview

Curriculum

Curriculum

17 Sections
22 Lessons
15 Days

Expand all sectionsCollapse all sections

How to access portal
1
- 2.1
  How to access portal
Class 1 & 2 - Basics
2
- 3.1
  Class 1 – 7th Batch
- 3.2
  Class 2 – Batch 7
Class 3 & 4 - Conditional Calculations
4
Class 5 - Pivot Tables
1
- 5.1
  Pivot Tables
Class 6 - Filters (Basic, Advanced & Auto)
1
- 6.1
  Excel Class 6
Class 7 - Text to Column, Flash Fill & Date Functions
1
- 7.1
  Class 7 – Text To Column and Dates
Class 8 - Vlookup & Index Match
2
- 8.1
  Excel Class 8 – Batch 7
- 8.2
  Index Match Practice Discussion
Excel file for Shortcuts
1
- 9.1
  Excel file for Shortcuts
Visualization
1
- 10.1
  Visualization (Graphs and Charts)
Concatenate, Left, Right & Middle
1
- 11.1
  Excel Class 10
Middle (Last Case) & Index Match Advanced
1
- 12.1
  Excel Class 11 – Batch 7
Conditional and Custom Formatting
1
- 13.1
  Excel Class 12 – Batch 7
Infinite Index Match
1
- 14.1
  Excel Class 13 – Batch 7
Sumproduct
1
- 15.1
  Excel Class 14 – Batch 7
Offset
1
- 16.1
  Excel Class 14 – Batch 7
Data Tab, Hyperlinks and Misc
1
- 17.1
  Excel Class 15 – Batch 7
FInal Assessment
1
- 18.1
  Final Assessment – Excel Batch 7

Instructor