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.
Excel 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.
Practical, hands-on exposure to the basis of Excel will give you confidence and allow you to utilise your new skills with efficiency.
If you are looking to learn more about or improve your proficiency in using Microsoft Word, then this is the course for you! This course is suitable for anyone who wants to improve their skills in word processing, from students to professionals.
The main aim of this introductory course is to provide a stepping stone to other training opportunities, most students go on to complete our Basic Office Skills Course (Khayelitsha) or Basic Cashiers Skills Course (Hermanus)
This course is intended to help all novice computer users get up to speed with PowerPoint quickly. We will cover different features of the interface; show users how to create, save, and present a basic presentation and we will discuss the basics of formatting features.
This course will teach you how to create interactive slide shows using this popular presentation program. Microsoft PowerPoint is among the most prevalent forms of persuasion technology.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy