Microsoft Excel 2016 Advanced Class
Microsoft Excel 2016 Advanced Courses in Cape Town
2KO offers this course in 3 levels
Beginner (click to see) Intermediate (click to see) Advanced (Below)
This course is for students who use Excel daily, and are well versed at the concepts of formulas, sorting, filtering and formatting. Now that you have mastered the intermediate skills of Excel 2016, we will teach students to tap into advanced functions and formulas that Excel spreadsheets offer. Note this is a fast paced course, and students who are not at the appropriate level will be left stranded, as there is no time to relearn the basics. For an exhilarating experience in Microsoft Excel 2016, enroll for this advanced course which includes the use of forms and macros. Learn to master MS Excel 2016 advanced concepts in one day. 2KO Africa offers 1 day Excel 2016 courses for each level, operating out of our state-of-the-art training centre in central Cape Town, up the road from the V&A Waterfront
Subject Covers
Becoming an Excel Expert
User
Unit Standards
258876 - Work with spreadsheets (Level 4) Credits 3
116943 - Using a Graphical User Interface (GUI)-based
spreadsheet application, enhance the functionality and
apply graph /charts to a spreadsheet (Level 4) 3 Credits
Pre-requisites
Prior knowledge and skills:
Mathematical Literacy at NQF Level 3.
Communication at NQF Level 3.
Computer Literacy at application NQF Level 3.
Use generic functions in a Graphical User Interface
(GUI)-environment (ID 117902 - NQF level 1).
"Use a Graphical User Interface (GUI)-based spreadsheet application
to solve a given problem" (ID 116940 - NQF level 3).
Level
Advanced
Duration
1 Day
Modules
Work with Multiple Worksheets
Multi-Sheet Spreadsheets
Grouping Sheets
Managing Sheets
3D Formulas
Linking Sheets
Applying formulas across sheets
Prepare and produce a spreadsheet
Naming ranges
Working with named ranges
Deleting a named range
Creating names from a selection
Name Manager
Functions using Names
Clipboard Group
Paste Special Options
Relative, Absolute and Mixed Formulas
Data Group
Sorting on Multiple Levels
Sorting on Colour
Filters
List and Cell Validation
Subtotals
Grouping and Outlining
Advanced Filters
Extracting Reports with Advanced Data Filter
Data Functions
Working with a Form
Validation with Forms
Advanced Functions
DSum, DAverage, DCount
Countif()
Sum and SumIF
IF and Nested IFs
And() and OR() Operators
VLookup
Index and Match Functions
VLookup Across Multiple Tables
Text Functions
Date Calculations
Customising Microsoft Excel
Setting Excel Options
Excel Add-ins
Customising the Quick Access toolbar
Working with Charts
Charts and PivotCharts
Setting or changing the chart type
Chart Titles
Chart Location
Moving, Resizing and Deleting charts as Objects
Formatting a chart
Printing charts
Using the Drawing Tools and Pictures
Pivot Tables
Understanding a Pivot Table
Data for a Pivot table
Creating a Pivot table
Add, copy, rearrange, and remove fields
Add a calculated field
Using the Pivot Table filters
Refresh Pivot Table data
Modifying the Pivot Table placement
Change Active Field settings
Change Pivot Table options
Change the Pivot Table layout
Predefined Pivot Tables
Pivot Table Tools Design Styles
Creating Pivot Charts
Slicers and Filters
Working with Text
Autofill
Flashfill
Fill Series
Text Functions
Date Functions
Text to Columns
Importing Text
Text Wizards
Concatenation
Wildcard characters for text string manipulation
Search and Replace
Data Security
Lock and Unlock Cells
Datasheet Protection
Password Protection
Using Cloud /Onedrive
2KO delivers cutting-edge IT products in the consulting and business services space, as well as offering top-rated training for various IT vendors. Our internationally recognised courses can be offered either as hands-on full time classes, or as online learning, enabling 2KO students the opportunity to study courses online world-wide, to ensure students have access to the best training possible.