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

 

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.

 

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

 

To find out more click the button below

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

 


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

Duration: 1 Day

 

Modules

Review of Basic Skills
 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