Excel 2016 Intermediate Course
Microsoft Excel 2016 Intermediate Training in Cape Town
2KO offers this course in 3 levels
Beginner (click to see) Intermediate (Below) Advanced (click to see)
Go on a journey of discovery, beyond the basics. Now that you have already mastered the basic skills of Excel 2016, we will teach students how to go further and deeper, to create more powerful spreadsheets. Everything in the Microsoft Excel 2016 beginners class gets covered in more detail. New skills are added and new formulae are learned in this one day Intermediate Excel class. Learn to further manipulate MS Excel 2016 data and combine spreadsheets with formulas spanning multiple sheets. 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
Increasing Efficiency
through Microsoft Excel
Unit Standards
116940 Use a Graphical User Interface (GUI)-based
spreadsheet application to solve a given problem (6
Credits) Level 3
258879 Change the appearance of a spreadsheet
Pre-requisites
Prior knowledge and skills:
Mathematical literacy and communication skills at least
at NQF Level 1.
Operate a personal computer system (ID 116932 - NQF
Level 1).
Use generic functions in a Graphical User Interface
(GUI)-environment (ID 117902 - NQF Level 1).
Level
Intermediate
Duration
1 Day
Modules
Percentages
Increasing & Decreasing Percentages
Hiding and Widening Columns
Copy and Move Formulas
Customise
the view and preferences
Minimising the Ribbon
Customising the Quick Access Toolbar
Using Zoom effectively
Freezing panes
Splitting the screen
Change the default file location
Setting document properties
Create a spreadsheet using a template
Create a template from an existing spreadsheet
The ClipBoard Group
Work with Multiple Worksheets
Multiple Sheets
Renaming Sheets
Insert and Delete Sheets
Copy and Move Sheets
Group Mode
3D Formulas
Using the Clipboard Group
Apply formulas to worksheets
Basic Statistical Formulas
BODMAS
Relative or Absolute Cell Addressing
Linking Formulas between worksheets
Interpret and Correct Formula Error Messages
Auditing Commands
Error Checking
Apply built-in functions
What is a built-in function
Creating Formulas Using Functions
Date and Time Functions
Financial Functions
Statistical Functions
Math and Trig Functions
Named Ranges
Formulas using Named Ranges
Rounding
Roundup and Rounddown
Apply formatting to a spreadsheet
Formatting Rows and Columns
Format Styles
Paste Special
Format Painter
Cell Styles
Format as Table
Copy formats
Conditional Formatting
Protecting Cells & Sheets
Password Protection
Working with Comments
Print a Spreadsheet
Previewing the spreadsheet
Using the Page Break Preview
Page Layout
Printing a worksheet
Working with Data
Sorting data
Filtering data
Subtotals
Outlining
Evaluate a Spreadsheet
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.