Microsoft Excel enables users to identify trends and organize and sort data into meaningful categories. Excel is a powerful tool which help better understanding of the business to take correct decisions.
The Microsoft Excel training is through real cases to understand the real issues to be resolved.
Any graduates who want to apply the knowledge of excel in day to day works. From beginners, to advanced users, this course is perfect for all ability levels
After completion of this course, learners will able to
Before the course begins, the participants will evaluate himself/herself against the skills sets required to become experts in excel. There will be continuous assessment through live case study and evaluation will be done to verify the development of skills.
The average duration of Microsoft Excel training is 15 hours (Basic 8 Hours + Advance 7 Hours). Participants needs to practice on Microsoft Excel to become experts.
Sr. No | Main Course | Duration (Hrs) | Level |
---|---|---|---|
1 | Absolute and Relative References | 2 | Basic |
2 | Conditional Functions | ||
3 | Database Functions, Financial Function (PV,NPV,FV,PMT,IPMT,PPMT) | ||
4 | Consolidation | 2 | |
5 | Named Ranges, Indirect | ||
6 | Text Functions, Date functions | ||
7 | Sorting | ||
8 | Remove Duplicate | 2 | |
9 | Filter | ||
10 | Flash Fill | ||
11 | Forms | ||
12 | Charts/Graphs/Dashboards, sparklines | 2 | |
13 | Subtotal, Group, Ungroup | ||
14 | V lookup and H Lookup, X Lookup | ||
15 | Index, Math Functions | 2 | Advanced |
16 | Advance Fill | ||
17 | Condition Formatting | ||
18 | Create a forecast in Excel | 2 | |
19 | Dependent Dropdown List | ||
20 | Data Validation | 2 | |
21 | Excel formula error codes and fixes | ||
22 | Pivot Table, Power Pivot, Power Query, Power BI and Dynamic Dashboards | ||
23 | Protection | 1 | |
24 | What-If Analysis | ||
25 | Macros |