This Excel course is designed to give you overall knowledge of Microsoft Excel Application with practical based projects.
This course is designed to fulfil the demand of the corporate platform and also divided into two parts. In Learning part you will learn how to use Microsoft Excel tools function that will enable you to handle Microsoft Excel application efficiently and effectively and in Project part you will learn real applications of Excel.
After completion of this course, you will
1. Achieve a Course Completion Certificate
2. Get a competitive advantage on job market
3. Be able to handle Microsoft Excel efficiently and effectively
4. Introduce Excel training to your organization
5. Train up your employees to grow excel skills to bring efficiency in their day-to-day work
Learning Part
01. Getting Started with Excel
02. Use of Cut Copy and Paste and Format Painter
03. Use of Font Tools under Home Menu
04. Use of Alignment Tools under Home Menu
05. Use of Number Tools under Home Menu
06. How to use of Style Tools under Home Menu
07. Use of Cells tool under home menu
08. Use of Editing Tools under Home Menu
09. How to Work with Multiple worksheet
10. How to use tables tool under insert menu
11. How to use illustrator tool under the insert menu
12. How to use Charts & Sparkline’s tool under insert menu
13. How to use Pivot Table and Slicer in Excel
14. How to use text tool under insert menu
15. How to use text & symbol tool under insert menu
16. How to use different tools under Draw menu
17. Use of Page Layout Tools in Excel
18. Use of different functions in Excel
19. How to Check and fix Function Errors
20. Use of Formula Auditing tools under Formula Menu
21. Use of IF function in Excel
22. How to import data, sorting, filtering and remove data duplication
23. How to use Data Validation tool in Excel
24. Text to Columns tool
25. What IF Analysis – Goal Seek for decision-making
26. What IF Analysis – Data Table for decision-making
27. What IF Analysis – Scenario Manager for Scenario Analysis
28. Data Forecasting Manually and Automatically
29. How to activate solver in Excel for Data Analysis
30. Use of Spelling checker tool under Review Menu
31. How to use Thesaurus and Translate Tool
32. How to use comments and Protection in Excel
33. Workbook Different Views
34. How to use Show and Zoom Tools in Excel
35. How to use Window Tools under view menu
36. How to activate Macro Tool in Excel
37. Tell me what to do Tool in Excel
Project Part
01. Salary Sheet Preparation Part – 1
02. Salary Sheet Preparation Part – 2
03. Net Salary Sheet Preparation Part – 1
04. Net Salary Sheet Preparation Part – 2
05. Government Tax Calculation on Salary
06. Employees Position Determination from Salary
07. Simple Profit or Loss Calculation of a Company
08. Electricity Bill Calculation
09. Student Mark Sheet Preparation Part – 1
10. Student Mark Sheet Preparation Part – 2
11. Employees Performance and Bonus Evaluation
12. Collect Employee Information from Data Table by VLOOKUP
13. Create Macro to work Efficiently in Excel (Data Formatting)
14. Production Unit Decision-Making by Solver
15. Data Modeling to Measure KPI with Power Pivot Part – 1
16. Data Modeling to Measure KPI with Power Pivot Part – 2
I wish you all the best!
