Microsoft Excel is the industry-leading spreadsheet program used for data calculations, analysis, visualisation and much more; it also has many external programming features. Excel is one of the best programs available for data modelling, statistics and financial calculations. Having sound Excel knowledge is typically required for accounting, business analytics, data analysis and statistics jobs.
Session 1: Freeze Panes
1
1. Freeze panes Example 1
2
2. Freeze Panes Example 2
Session 2: Removing Duplicates
1
3. Remove Duplicate Values
Session 3: Match
1
4. Match Scenario
2
5. Match
Session 4: Logical Functions
1
6. And
2
7. IF_And
3
8. Nested IF Scenario
4
9. Nested IF
Session 5: Count
1
10. CountIFS Example 1
2
11. CountIFS Scenario 1
3
12. CountIFS Scenario 2
Session 6: Lookups
1
13. VLookup Scenario 1
2
14. VLookup Scenario 2
3
15. VLookup Scenario 3
4
16. HLookup Scenario 1
5
17. HLookup Scenario 2
Session 7: Tables
1
18. Applying the Table
2
19. Totals Row
3
20. Quick Analysis: Formatting
4
21. Quick Analysis: Pivot Chart
Session 8: Slicers
1
22. What is a Slicer?
2
23. Applying the Slicer
Session 9: Sparklines
1
24. Sparklines
Session 10: Sheet Very Hidden
1
25. Very Hidden
Session 11: Pivot Tables
1
26. Definition of a Pivot Table
2
27. Four Ways to Create a Pivot Table
3
28. Creating a Pivot Table
4
29. Calculation Features
5
30. Adding a Chart to a Pivot Table
6
31. Display the Field List
7
32. Defer Layout Update
Session 12: Macro's
1
33. What is a Macro
2
34. Macro Setup
3
35. Record a Macro
4
36. Macro Shortcut Key
5
37. Running the Macro
6
38. Saving a Macro File
7
39. Edit the Macro with Visual Basic
8
Excel Advanced Assessment
The programme is aimed at all individuals that have Intermediate levels of skills in Excel and are upskilling themselves and improving computer proficiency.
The primary objective of this course is to obtain the Advanced Principles of Excel
Be the first to add a review.
Please, login to leave a review