Excel: An Advanced Level Course
This course will provide you with the right information to give you the knowledge you will need to become proficient in the Advanced Principles of Excel.
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
Related Courses
Hot
IT and Computer Studies
This course will provide you with the right information to give you the knowledge you will need to become proficient in the Intermediate Principles...
R800
Hot
IT and Computer Studies
Having sound Excel knowledge is typically required for accounting, business analytics, data analysis and statistics jobs. This course is perfect...
R750
Hot
IT and Computer Studies
The purpose of this FREE Excel Pre-Assessment is for you to understand the level of training you require, before enrolling in one of our comprehens...
Free
30-Day Money-Back Guarantee
Includes
90 mins
Full lifetime access
Access on mobile and TV