Home
All courses
Popular Courses
Advanced Excel – Self Learning Course

Advanced Excel – Self Learning Course

Teacher

CA Deepika Agrawal

Categories

Popular Courses

₹5,950.00

Advanced-Excel-course

Curriculum
Instructor

Session 1 2
- Lecture1.1
  
  Introduction and Conditional Formatting
  01 hour 39 min
- Lecture1.2
  
  Session 1 : Study Material
Session 2 2
- Lecture2.1
  
  Shortcuts to Excel
  02 hour 27 min
- Lecture2.2
  
  Session 2 : Study Material
Session 3 2
- Lecture3.1
  
  Date Functions, Max, Large, Min, Small, Ifs, Nested Ifs, Sum If/Ifs,
  02 hour 41 min
- Lecture3.2
  
  Session 3 : Study Material
Session 4 2
- Lecture4.1
  
  Text to columns, V Lookup, H Lookup & X Lookup
  02 hour 25 min
- Lecture4.2
  
  Session 4 : Study Material
Session 5 2
- Lecture5.1
  
  Formulas, Advance Sorting, Filters, Advance Filters, Advance Filter with Macros
  02 hour 20 min
- Lecture5.2
  
  Session 5: Study Material
Session 6 2
- Lecture6.1
  
  Pivots/ Charts/ Mail merge
  02 hour 27 min
- Lecture6.2
  
  Session 6 : Study Material
Session 7 3
- Lecture7.1
  
  Dashboard, Data validation, Name ranges consolidation
  02 hour 26 min
- Lecture7.2
  
  Session 7 : Study Material
- Lecture7.3
  
  Automization and consolidation of financials
Session 8 2
- Lecture8.1
  
  Automisation and Consolidation of Financials
  02 hour 23 min
- Lecture8.2
  
  Session 8 : Study Material
Session 9 2
- Lecture9.1
  
  Miscellaneous Practice Questions
  02 hour 22 min
- Lecture9.2
  
  Session 9 : Study Material
Online Advanced Excel Test 1
- Quiz10.1
  
  Advanced Excel Quiz
  30 questions

CA Deepika Agrawal

Demo Self Learning-Certification on Income Tax

SelflearningHost

Demo Self Learning-Certification on Income Tax

Students

2

₹1,000.00

Demo – Self Learning GST

CA Raman Singla

Demo - Self Learning GST

Students

5

₹8,000.00

Self Learning-Certification Course on Customs Incl Export and Import

SelflearningHost

Self Learning-Certification Course on Customs Incl Export and Import

Students

56

₹8,000.00

Professional Development Course on Customs & FTP

SelflearningHost

Professional Development Course on Customs & FTP

Students

8

₹10,000.00

Self Learning-Certification on Income Tax

CA. Pankaj Saraogi

Self Learning-Certification on Income Tax

Students

130

₹8,000.00