You will learn how to create and utilise formulas that will enable you to work more efficiently, which will save you time while improving the quality and usability of your spreadsheets.
DurationExcel Level 4 – Advanced Features and Formulas
What Can You Expect?
You will learn how to create and utilise formulas that will enable you to work more efficiently, which will save you time while improving the quality and usability of your spreadsheets.
What Is Required From You?
Excel Intermediate or equivalent experience.
Assessment Strategy
The assessment methodologies used in this course are to determine and recognise learner competence against the criteria in the related unit standard. Learners are required to successfully complete both Formative and Summative assessments.
Unit Standard Alignment
2 Day Course Content
Modifying Workbooks and Worksheets
Compare Side by Side
Create and Save a Template
Paste Special
Transpose Rows and Columns
Paste Link
Creating Advanced Formulas
Relative, Absolute and Mixed References
3D Formulas
Math & Trig Functions
Statistical Functions
Date and Time Functions
Financial Functions
Engineering Functions
Nesting Functions
Information Functions
Array Formulas
Text Functions
Logical Functions
Lookup Functions
Formula Auditing
Trace Precedent Cells
Trace Dependent Cells
What Will I Take Back To Work With Me?
Named Ranges
Use the Name Manager
Create Name Ranges
Protect Worksheets and Workbooks
Password Protect a Workbook
Protect Worksheet Elements
Allow Users to Edit Ranges
Remove Protection
Control Elements of the Excel Interface
Adjust Excel Options
Customise the Quick Access Toolbar
Customise the Ribbon
Advanced Formatting Techniques
Conditional Formatting
Data Tool Features
Sort Data
Subtotals
What-If-Analysis
Scenarios
Annotate with Cell Comments
Insert a Comment
Show/Hide Comments
Print Comments
This hands-on course will give you the skills and confidence to refine and improve your spreadsheets while increasing efficiency and accuracy.
Keybase Pretoria is an accredited training centre based in Moreleta Park, Pretoria East. We specialize in all Microsoft courses from Basic to Advanced as well as soft skill courses.
Microsoft Office Visio course is offered by Lamus Training Academy. We can conduct training onsite and off-site, providing all equipment needed. We provide you with the flexibility to better control the training process.
Microsoft Excel course is offered by UKZN Extended Learning. Learn how to work your way around Excel, its Backstage, Quick Access Toolbar and the Ribbon bar and many more.
Office Computing course is offered by Rich Skills Training Centre. We offer full or refresher courses. we are fully registered and accredited by Teta, Merseta and Ceta. We train both local and international students.
This practical course will give the skills and knowledge to return to work to improve your efficiency, maintain accuracy and produce professional output.
In this course, you will be taught how to not only develop spreadsheets using formulas and formatting but will be shown how to create charts ensuring you leave with a comprehensive knowledge of how to make Microsoft Excel work for you.
About Coursetakers.com
Coursetakers.com is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in South Africa, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy
Online
USA
UK
India
UAE
South Africa
Canada
New Zealand
Australia
Malaysia
Singapore
Saudi Arabia
Egypt
Jordan