Courses
Curriculum
- Sl. No.
- Chapter
- Chapter - 1
- Introduction of Excel
- Chapter - 2
- Working with Workbook and Worksheets
- Chapter - 3
- Introducing Excel Tables Formulas and References
- Chapter - 4
- Formatting Data
- Chapter - 5
- Inserting Objects in Worksheets
- Chapter - 6
- Managing Data in Excel
- Chapter - 7
- Excel Formulas and Functions
- Chapter - 8
- References and LOOKUPs
- Chapter - 9
- Excel Tables
- Chapter - 10
- Working with Charts
- Chapter - 11
- Working with Pivot Table
- Chapter - 12
- What If Analysis - Goal Seek and Scenario Manager
- Chapter - 13
- Data Analysis and Validation
- Chapter - 14
- Macros
- Chapter - 15
- Printing Excel Workbooks
- Chapter - 16
- Managing Excel Files
- Chapter - 17
- Visual Basic for Application
- Chapter - 18
- Case Study 1 - Editing an Excel Macro in VBA
- Chapter - 19
- Case Study 2 – Creating User Forms in VBA
- Chapter - 20
- Case Study 3 – Custom Excel Functions
- Chapter - 21
- Case Study 4 – Conditional Logic in VBA
- Chapter - 22
- Case Study 5 – Create Dynamic Dashboard
Contact Us
- Public Batches Phone No.: +1-844-889-4054 Email: support@careerera.com
- Private Batches Phone No.: +1-844-889-4054 Email: Sandeep@careerera.com
- Corporate Batches Phone No.: +1-844-889-4054 Email: aditya@careerera.com
Advanced Excel Certification, this Course and batch also available in other locations View
- Arki
- Baddi
- Bakloh
- Banjar
- Bhota
- Bhuntar
- Bilaspur
- Chamba
- Chaupal
- Chuari Khas
- Dagshai
- Dalhousie
- Dalhousie Cantonment
- Damtal
- Daulatpur
- Dera Gopipur
- Dhalli
- Dharamshala
- Gagret
- Ghamarwin
- Hamirpur
- Jawala Mukhi
- Jogindarnagar
- Jubbal
- Jutogh
- Kala Amb
- Kalpa
- Kangra
- Kasauli
- Kot Khai
- Kullu
- Kulu
- Manali
- Mandi
- Mant Khas
- Mehatpur Basdehra
- Nadaun
- Nagrota
- Nahan
- Naina Devi
- Nalagarh
- Narkanda
- Nurpur
- Palampur
- Pandoh
- Paonta Sahib
- Parwanoo
- Parwanu
- Rajgarh
- Rampur
- Rawalsar
- Rohru
- Sabathu
- Santokhgarh
- Sarahan
- Sarka Ghat
- Seoni
- Shimla
- Sirmaur
- Solan
- Solon
- Sundarnagar
- Sundernagar
- Talai
- Theog
- Tira Sujanpur
- Una
- Yol