Microsoft Excel 2016 Advanced Class

Microsoft Excel 2016 Advanced Courses in Cape Town

 

No Contact Training

Get trained without coming to a class.

  • No travel Required

  • Study from work or home

  • Enjoy the best IT training, from the security and safety of your own environment

 

To find out more click the button below

 

 

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 Africa offers IT consulting, technical IT services and top-of-the-range IT training on multiple platforms. Our best-of-breed computer courses are presented as instructor led classes or as online internet-based elearning, enabling 2KO students the opportunity to study courses online world-wide, to ensure students have access to the best training possible.