KaaShiv's Training Program will provide you with in-depth knowledge in Microsoft Excel
5 of (8k+ satisfied learners)
Preview this Course
Most popular course on Microsoft Excel trusted by over 50,000 students! Built with years of experience by industry experts and gives you a complete package of video lectures, practice problems, quizzes. Start Today!
Available for 5 Days to 6 Months
SignIn to Buy
Microsoft Excel Internship excellent to learn
Get Job from Top Companies with this Internship
Average Salary
Rs.5,00,000 - 8,00,000 / Year
| Topic | Text Material | Image content | Video content | Quiz |
|---|---|---|---|---|
| 1. Introduction to Excel History |
|
|
||
| 2. What is Excel? |
|
|
||
| 3. Excel Applications |
|
|
||
| 4. Excel features |
|
|
||
| 5. How to Install Excell | - | |
||
| 6. Excel Sheet Interface |
|
|
||
| How To Work with Excel |
|
|
||
| Excel functions |
|
|
||
| Excel formulas |
|
|
| Topic | Text Material | Image content | Video content | Quiz |
|---|---|---|---|---|
| COUNTIF FUNCTION? | - | |
||
| COUNTIFS FUNCTION? | - | |
||
| FLASH FILL | - | |
||
| IF function | - | |
||
| IFS FUNCTION | - | |
||
| 7. Cell Name & Cell Address |
|
|
||
| 8. Insert, Delete & Hide |
|
|
||
| 9. Sum function |
|
|
||
| Scenario question for Cell Name & Cell Address | - | |
||
| Scenario question for Insert, Delete & Hide | - | |
||
| Scenario question for SUM Function | - | |
| Topic | Text Material | Image content | Video content | Quiz |
|---|---|---|---|---|
| PIVOT CHART | - | |
||
| PIVOT TABLE | - | |
||
| SUMIF FUNCTION | - | |
||
| SUMIFS | - | |
||
| VLOOKUP | - | |
||
| XLOOKUP FUNCTION | - | |
||
| 10. SUMIF Function in Excel |
|
|
||
| 11. SUMIFS Function |
|
|
||
| 12. COUNT Function |
|
|
||
| 13. COUNTIF Function |
|
|
||
| 13. COUNTIFS Function in Excel |
|
|
||
| Scenario question for SUMIF Function | - | |
||
| Scenario question for SUMIFS Function | - | |
||
| Scenario question for COUNT Function | - | |
||
| Scenario question for COUNTIF Function | - | |
||
| Scenario question for COUNTIFS Function | - | |
| Topic | Text Material | Image content | Video content | Quiz |
|---|---|---|---|---|
| 14. IF Function in Excel |
|
|
||
| 15. IFS Function in Excel |
|
|
||
| 16. VLOOKUP Function |
|
|
||
| 17. HLOOKUP Function |
|
|
||
| Scenario question for IF Function | - | |
||
| Scenario question for IFS Function | - | |
||
| Scenario question for VLOOKUP Function | - | |
||
| Scenario question for HLOOKUP Function | - | |
| Topic | Text Material | Image content | Video content | Quiz |
|---|---|---|---|---|
| 18. XLOOKUP Function |
|
|
||
| 19. INDEX + MATCH Function |
|
|
||
| 20. Pivot Table in Excel |
|
|
||
| 21. Slicer |
|
|
||
| Scenario question for XLOOKUP Function | - | |
||
| Scenario question for INDEX + MATCH Function | - | |
||
| Scenario question for Pivot Table in Excel | - | |
||
| Scenario question for Slicer | - | |
| Topic | Text Material | Image content | Video content | Quiz |
|---|---|---|---|---|
| 22. Pivot Chart in Excel |
|
|
||
| 23. AVERAGE, MIN, MAX Functions |
|
|
||
| 24. Flash Fills |
|
|
||
| Scenario question for Pivot Chart | - | |
||
| Scenario question for AVERAGE, MIN, MAX | - | |
||
| Scenario question for Flash Fill | - | |
| Topic | Text Material | Image content | Video content | Quiz |
|---|---|---|---|---|
| 25. ROUND Function |
|
|
||
| 26. ROUNDUP / ROUNDDOWN |
|
|
||
| Scenario question for ROUND Function | - | |
||
| Scenario question for ROUNDUP / ROUNDDOWN | - | |
| Topic | Text Material | Image content | Video content | Quiz |
|---|---|---|---|---|
| 29. DASHBOARD IN EXCEL |
|
|
||
| 27. %DIFF (Percentage Difference) |
|
|
||
| 28. Charts |
|
|
||
| 30. Project - 2 Top Indian Companies Dashboard |
|
|
||
| 31. Project - 3 Synthetic health life analysis Dashboard |
|
|
||
| Scenario question for %DIFF (Percentage Difference) | - | |
||
| Scenario question for Charts | - | |
||
| Scenario question for Dashboard in Excel | - | |
Microsoft Excel is a powerful spreadsheet software used for data organization, analysis, and visualization. It provides tools for calculating, creating charts, and performing data manipulation with formulas, pivot tables, and macros. Excel is widely used for financial, statistical, and administrative tasks, making it essential in business, research, and personal data management. It’s part of the Microsoft Office Suite.
Earn official recognition for your work, and share your success with friends, colleagues, and employers.
Ananthi shares her KaaShiv learning experience helped her gain an edge in job interviews and land a job.
Preethi shares her KaaShiv learning experience helped her gain an edge in job interviews and land a job.
Madhusan shares her KaaShiv learning experience helped her gain an edge in job interviews and land a job.
24 x 7 Expert SupportWe have a lifetime 24x7 online support team to resolve all your technical queries, through a ticket based tracking system.
CertificationSuccessfully complete your final course project and Kaashiv will certify you as a Microsoft Excel Expert.
ForumWe have a community forum for all our learners that further facilitates learning through peer interaction and knowledge