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.
This course is designed to give you skills to use the more advanced features of Word. Learners must have a working knowledge of Word, Word Intermediate training or equivalent experience.
This course is ideal for reward practitioners who are involved in detailed data analysis. The purpose would be to discover the power of excel in assisting in the time-consuming ‘number-crunching’.
Microsoft PowerPoint Training Course is offered by Susca Watts Middelburg.
If you have basic Access concepts such as creating tables, forms, and queries and are looking to become an Access Expert, this is the ideal course for you!
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 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.
© 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
Saudi Arabia
Egypt
Jordan