016 362 6640
info@cmmeyerton.co.za
54 Loch Street, Meyerton, 1961
Home
Training Courses
Introduction to Computers
Beginner
Intermediate
Advanced
Excel Dashboards
Sage Pastel
Corporate Training
Finance Options
016 423 6212
info@jstrydom.co.za
50 Boet Kruger Street, Meyerton, 1961
Contact Us
Advanced
Microsoft Excel 2019 - Level 3 Plus
Courses
»
Excel 2019 Level 3 Plus
Course Purpose
Course Outline
Prerequisites
Who Should Attend?
Course Purpose
Course Outline
Importing Text Files
Dragging and dropping Text
Importing and Linking a Text File
Refreshing Linked Data
Exporting Data
Named Ranges
Working with Large Documents
Conditional Formatting
Filtering Data
Data Forms
Sorting Data
Subtotals
Charts
Elements of a Chart
Formatting a Chart
Objects
Linking and Consolidating Worksheets
Linking Workbooks
Consolidate Data from Multiple Worksheets
Consolidate by Categories
Consolidate by Position
Hide/ Unhide
Columns
Rows
Worksheets
Advanced Display Features
Changing Cell Gridlines
Displaying and Printing Formulas
Adding Color to Worksheet Tabs
Adding a Background to a Worksheet
Macros
Creating a Macro
Running a Macro
Creating a Macro to Identify Data
Creating a Macro to Format Data
Assigning a Macro to a Tool button
Functions
Date and Time Worksheet Functions
Text Functions
Mathematical Functions
Statistical Functions
Logical Functions
Financial Functions
Look Up and Reference Functions
Using Goal Seek
Scenarios
PivotTables
Adding Fields to a PivotTable
Grouping Items on a PivotTable
Hiding Items on a PivotTable
Using Value Settings
Creating a PivotChart
Preparing a Pivot Report
Protection
Assessing your Knowledge
Prerequisites
Who Should Attend?
Course Features
SAQA Unit Standard:
n/a
Accreditation:
MICT SETA
Duration:
15 hours
Are you interested in this course?
Fill out the form to request more information, and we will get back to you with all the details you need.
Name
*
Email
*
Phone Number
*
Subject
*
Message
*
Similar Courses
Course Duration: 30 hours
Sage Pastel – Advanced
View Course
Course Duration: 15 hours
Excel Dashboards
View Course
Course Duration: n/a
Word 2019 Level 3
View Course