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.
While formulas and functions are great tools, macros takes things to a whole new level particularly for repetitive tasks and regular reports. Learn how you can transform your excel spreadsheets by attending our course called Macros and VBA for Excel: Unleash the Power in your PC.
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.
This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.
This Microsoft Excel Essentials Course is designed to equip you with basic literacy in the use of spreadsheets (particularly Microsoft Excel) to produce and manage business documents.
Microsoft Office Word 2016 is a wordprocessor and part of the Microsoft Office packages, that allows you to create a variety of documents, including letters, resumes, and more.
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.
© 2024 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