Advanced Excel – Batch 10 – E-Learners Pakistan

+923359999187
info@courses.qanoonforall.com

Last updated May 27, 2024

Advanced Excel – Batch 10

(0 Ratings)

766 students

Advanced Excel – Batch 10

Overview

Curriculum

Curriculum

12 Sections
14 Lessons
15 Weeks

Expand all sectionsCollapse all sections

Gripping the basics
1
- 2.1
  Basic Excel – Class 1
How to access portal
1
- 3.1
  Demonstration – How to access portal
Conditional Calculations (And, Or, If, If And, If Or, Count if, Sumif, Sumifs)
2
- 4.1
  Conditional Calculations – Class 2
- 4.2
  Count (All types), Find, Replace, Find & Select, Spell check, Sumifs, Tab options
Sumifs practice, Date functions, Filters
1
- 5.1
  Advanced Excel – Class 4
Duplicates, Auto Filter, Group, Subtotal, Name Manager, Drop down, Conditional Formatting, Copy Paste Special
1
- 6.1
  Advanced Excel – Class 5
Flash Fill, Text to Column, Concatenate, Left, Right, Fill in (Series), Match, Vlookup
1
- 7.1
  Advanced Excel – Class 6
Index Match
1
- 8.1
  Advanced Excel – Class 7
Pivot Tables
2
- 9.1
  Advanced Excel – Class 8
- 9.2
  Advanced Excel – Class 9 (Auto filter, Links, Pivot Table, Financial Modeling functions)
Sum if not, Goal seek, Data Tables, Solver
1
- 10.1
  Advanced Excel – Class 10
Offset
1
- 11.1
  Advanced Excel – Class 11
Excel charts and graphs
1
- 12.1
  Advanced Excel – Class 12
Final assessment
1
- 13.1
  Final Assessment – Batch 10

Instructor