Excel 2016 Intermediate Course

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 to:
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
 

Prepare and produce a spreadsheet
Planning and designing the Worksheet 

 

Customise the view and preferences
Minimising the Ribbon
Customising the Quick Access Toolbar
Changing the size of the screen display
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

Work with Multiple Worksheets
Multiple Sheets
Renaming Sheets
Insert and Delete Sheets
Copy and Move Sheets
Worksheet Groups
Using the Clipboard Group
Using Paste Special

Apply formulas to worksheets
Entering Formulas
Relative or Absolute Cell Addressing
Link 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

Apply formatting to a spreadsheet
Formatting Rows and Columns
Format Styles
Format as Table
Copy formats
Conditional Formatting
Protection
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

 

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.