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.

41 students enrolled

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
0:37
2
2. Freeze Panes Example 2
0:30

Session 2: Removing Duplicates

1
3. Remove Duplicate Values
0:50

Session 3: Match

1
4. Match Scenario
0:22
2
5. Match
1:14

Session 4: Logical Functions

1
6. And
0:47
2
7. IF_And
0:45
3
8. Nested IF Scenario
0:29
4
9. Nested IF
1:05

Session 5: Count

1
10. CountIFS Example 1
0:52
2
11. CountIFS Scenario 1
0:19
3
12. CountIFS Scenario 2
1:03

Session 6: Lookups

1
13. VLookup Scenario 1
0:20
2
14. VLookup Scenario 2
1:15
3
15. VLookup Scenario 3
0:41
4
16. HLookup Scenario 1
0:21
5
17. HLookup Scenario 2

Session 7: Tables

1
18. Applying the Table
0:48
2
19. Totals Row
0:25
3
20. Quick Analysis: Formatting
0:41
4
21. Quick Analysis: Pivot Chart
0:40

Session 8: Slicers

1
22. What is a Slicer?
2
23. Applying the Slicer
0:44

Session 9: Sparklines

1
24. Sparklines
0:58

Session 10: Sheet Very Hidden

1
25. Very Hidden
0:58

Session 11: Pivot Tables

1
26. Definition of a Pivot Table
0:34
2
27. Four Ways to Create a Pivot Table
0:23
3
28. Creating a Pivot Table
1:23
4
29. Calculation Features
1:02
5
30. Adding a Chart to a Pivot Table
1:02
6
31. Display the Field List
0:12
7
32. Defer Layout Update
0:26

Session 12: Macro's

1
33. What is a Macro
2
34. Macro Setup
0:29
3
35. Record a Macro
1:09
4
36. Macro Shortcut Key
0:24
5
37. Running the Macro
0:30
6
38. Saving a Macro File
0:35
7
39. Edit the Macro with Visual Basic
0:54
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
Get course
30-Day Money-Back Guarantee

Includes

90 mins
Full lifetime access
Access on mobile and TV

Contact your Instructor