Price:
R448.50 (VAT Incl.)
Level:
Individual Professionals
Sub-level:
Microsoft
Lecturer:
Tristan David-Crewe White
Duration:
120 Minutes
Additionals:
R448.50 (VAT Incl.)
Level:
Individual Professionals
Sub-level:
Microsoft
Lecturer:
Tristan David-Crewe White
Duration:
120 Minutes
Additionals:
CPD Assessment
Certificate
Certificate
Lesson Outline
Overview
If you or your firm use Excel for multiple hours each day, imagine what the wasteful labour cost must be from using it inefficiently?
Akhanani has designed a course for those individuals and offices that are heavily reliant on Microsoft Excel as part of their day-to-day work duties, be it in audit, accounting or office administration.
The goal of this course is to
- Freshen up your Basic Excel knowledge,
- Improve your efficiency and
- Show you alternative ways to get the same things done.
This session focuses on the value-add elements like VLookUps, Pivot Tables, Concatenating text, and Financial formulae, amongst others -- for those with an already established basic-level of Excel knowledge.
Course Content:
• Data Editing: Sorting / filtering / conditional formatting / data validation / Subtotal formula.
• Data Searching: VLookUps / CountIf formula / If statements / Search and Replace text.
• Data Extraction (basic): Flash fill / Text-to-Columns / Concatenate.
• Building Formulae: Cell referencing within formulae i.e. relative and absolute references.
• Financial Functions: PMT, RATE, IPMT, NPV, FV and PV
• Tables / Graphs: Pivot tables.
If you or your firm use Excel for multiple hours each day, imagine what the wasteful labour cost must be from using it inefficiently?
Akhanani has designed a course for those individuals and offices that are heavily reliant on Microsoft Excel as part of their day-to-day work duties, be it in audit, accounting or office administration.
The goal of this course is to
- Freshen up your Basic Excel knowledge,
- Improve your efficiency and
- Show you alternative ways to get the same things done.
This session focuses on the value-add elements like VLookUps, Pivot Tables, Concatenating text, and Financial formulae, amongst others -- for those with an already established basic-level of Excel knowledge.
Course Content:
• Data Editing: Sorting / filtering / conditional formatting / data validation / Subtotal formula.
• Data Searching: VLookUps / CountIf formula / If statements / Search and Replace text.
• Data Extraction (basic): Flash fill / Text-to-Columns / Concatenate.
• Building Formulae: Cell referencing within formulae i.e. relative and absolute references.
• Financial Functions: PMT, RATE, IPMT, NPV, FV and PV
• Tables / Graphs: Pivot tables.