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.
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
2
2. Relative Reference
Session 2: Count
1
3. Count
2
4. CountA
3
5. CountBlank
4
6. CountIF
5
7. Scenario
6
8. Count
7
9. CountA
8
10. CountBlank
9
11. CountIF
Session 3: Logical Functions
1
12. IF Example 1
2
13. IF Example 2
3
14. SumIF
Session 4: Financial
1
15. Setting the Scenario
2
16. Payment
Session 5: What-if Analysis (Goal Seek)
1
17. Goal Seek Example 1
2
18. Goal Seek Example 2
Session 6: What-if Analysis (Data Tables)
1
19. One Data Table
2
20. Two Data Table
Session 7: Validation
1
21. Validation of Numbers
2
22. Validation on Time
3
23. Validation List
4
24. Input Message
5
25. Stop Alert
6
26. Warning Error Alert
7
27. Removing a Validation
Session 8: Filter
1
28. Applying the Filter
2
29. Customise Filter
3
30. Removing Blank Rows
4
31. Removing the Filter
Session 9: Conditional Format
1
32. Conditional Format Example 1
2
33. Conditional Format Example 2
3
34. Conditional Format Example 3
Session 10: Charts
1
35. Chart Scenario
2
36. Creating a Chart
3
37. Chart Styles
4
38. Adding a Data Series
5
39. Adding Labels to a Chart
6
40. Apply a Filter to a Chart
7
41. Scale the Axis
8
42. Axis Reverse Order
Session 11: Headers and Footers
1
43. Headers and Footers
Session 12: Subtotals
1
44. Applying Subtotals to a List
2
45. Adding a Subtotal
3
46. Removing Subtotals
Session 13: Links
1
47. Linking Cells
2
48. Linking Sheets
3
49. Linking Workbooks
4
50. Array Links
5
51. Paste Link
Session 14: Printing
1
52. Gridlines and Column Headers
2
53. Page Breaks
3
54. Page Setup: Headers and Footers
4
55. Page Setup: Margins
5
56. Page Setup: Page
6
57. Page Setup: Print Area
7
58. Page Setup: Rows to Repeat
8
59. Print only the Active Sheets
9
60. Printing Overview
Session 15: Protection
1
61. Protection Scenario
2
62. Method
3
63. Setting up the Protection
4
64. Apply the Protection
5
65. Testing the Protection
6
66. Protect Workbook
7
67. Saving File with Password
8
68. Open File with Password
9
69. Very Hidden
ASSESSMENT
1
Excel: An Intermediate Level Course: Assessment
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
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 Advanced Principles of ...
R900
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
2 hours
Full lifetime access
Access on mobile and TV