Excel: An Intermediate Level Course

This course will provide you with the right information to give you the knowledge you will need to become proficient in the Intermediate Principles of Excel.

465 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.

This course will provide you with the right information to give you the knowledge you will need to become proficient in the Intermediate Principles of Excel.

Session 1: Cell References

1
1. Absolute Reference
1:22
2
2. Relative Reference
0:47

Session 2: Count

1
3. Count
0:31
2
4. CountA
0:31
3
5. CountBlank
0:42
4
6. CountIF
0:47
5
7. Scenario
0:29
6
8. Count
0:31
7
9. CountA
0:31
8
10. CountBlank
0:41
9
11. CountIF
0:41

Session 3: Logical Functions

1
12. IF Example 1
0:54
2
13. IF Example 2
0:53
3
14. SumIF
0:49

Session 4: Financial

1
15. Setting the Scenario
0:19
2
16. Payment
1:16

Session 5: What-if Analysis (Goal Seek)

1
17. Goal Seek Example 1
1:01
2
18. Goal Seek Example 2
1:06

Session 6: What-if Analysis (Data Tables)

1
19. One Data Table
0:55
2
20. Two Data Table
0:39

Session 7: Validation

1
21. Validation of Numbers
1:10
2
22. Validation on Time
0:48
3
23. Validation List
1:00
4
24. Input Message
0:46
5
25. Stop Alert
0:53
6
26. Warning Error Alert
0:40
7
27. Removing a Validation
0:19

Session 8: Filter

1
28. Applying the Filter
1:11
2
29. Customise Filter
0:44
3
30. Removing Blank Rows
0:31
4
31. Removing the Filter
0:10

Session 9: Conditional Format

1
32. Conditional Format Example 1
1:25
2
33. Conditional Format Example 2
1:08
3
34. Conditional Format Example 3
1:33

Session 10: Charts

1
35. Chart Scenario
0:17
2
36. Creating a Chart
1:29
3
37. Chart Styles
0:26
4
38. Adding a Data Series
0:33
5
39. Adding Labels to a Chart
0:48
6
40. Apply a Filter to a Chart
0:24
7
41. Scale the Axis
0:35
8
42. Axis Reverse Order
0:28

Session 11: Headers and Footers

1
43. Headers and Footers
0:58

Session 12: Subtotals

1
44. Applying Subtotals to a List
1:00
2
45. Adding a Subtotal
3
46. Removing Subtotals
0:11

Session 13: Links

1
47. Linking Cells
0:41
2
48. Linking Sheets
0:54
3
49. Linking Workbooks
1:16
4
50. Array Links
0:45
5
51. Paste Link
0:32

Session 14: Printing

1
52. Gridlines and Column Headers
0:41
2
53. Page Breaks
0:42
3
54. Page Setup: Headers and Footers
1:27
4
55. Page Setup: Margins
0:46
5
56. Page Setup: Page
0:58
6
57. Page Setup: Print Area
0:37
7
58. Page Setup: Rows to Repeat
0:40
8
59. Print only the Active Sheets
0:26
9
60. Printing Overview
0:32

Session 15: Protection

1
61. Protection Scenario
0:24
2
62. Method
0:57
3
63. Setting up the Protection
0:58
4
64. Apply the Protection
1:23
5
65. Testing the Protection
6
66. Protect Workbook
0:44
7
67. Saving File with Password
0:50
8
68. Open File with Password
0:32
9
69. Very Hidden
0:55

ASSESSMENT

1
Excel: An Intermediate Level Course: Assessment
6 questions
The programme is aimed at all individuals that are upskilling themselves and improving computer proficiency.
The primary objective of this course is to obtain the Intermediate Principles of Excel

Be the first to add a review.

Please, login to leave a review
30-Day Money-Back Guarantee

Includes

2 hours
Full lifetime access
Access on mobile and TV

Contact your Instructor