Microsoft Courses

Short Courses

Microsoft Excel 2016 Intermediate Topics


Lesson 1: Creating Advanced Formulas
TOPIC A: Apply Range Names
Range Names
Adding Range Names Using the Name Box
Adding Range Names Using the New Name Dialog Box
Editing a Range Name and Deleting a Range Name
Using Range Names in Formulas
TOPIC B: Use Specialised Functions
Function Categories
The Excel Function Reference
Function Syntax
Function Entry Dialog Boxes
Using Nested Functions
Automatic Workbook Calculations
Showing and Hiding Formulas
Enabling Iterative Calculations
Lesson 2: Analysing Data with Logical and Lookup Functions
TOPIC A: Use Text Functions
Text Functions
The LEFT and RIGHT Functions
The MID Function
The LEN Function
The TRIM Function
The UPPER, LOWER, and PROPER Functions
The TRANSPOSE Function
TOPIC B: Use Logical Functions
Logical Functions
Logical Operators
The AND Function
The OR Function
The IF Function
TOPIC C: Use Lookup Functions
Lookup Functions
The LOOKUP Function
The LOOKUP Function
The LOOKUP Function
TOPIC D: Use Date Functions
The TODAY Function
The NOW Function
Serialising Dates and Times with Functions
TOPIC E: Use Financial Functions
The IPMT Function
The PPMT Function
The NPV Function
The FV Function
Lesson 3: Organising Worksheet Data with Tables
TOPIC A: Create and Modify Tables
Table Components
The Create Table Dialog Box
The Table Tools – Design Contextual Tab
Styles and Quick Style Sets
Customising Row Display
Table Modification Options
TOPIC B: Sort and Filter Data
The Difference Between Sorting and Filtering
Sorting Data
Advanced Filtering
Filter Operators
Removing Duplicate Values
TOPIC C: Use Subtotal and Database Functions to Calculate Data
SUBTOTAL Functions
The Subtotal Dialog Box
Summary Functions in Tables
Database Functions
Lesson 4: Visualising Data with Charts
TOPIC A: Create Charts
Chart Types
Chart Insertion Methods
Resizing and Moving the Chart
Adding Additional Data
Switching Between Rows and Columns
TOPIC B: Modify and Format Charts
The Difference Between Modifying and Formatting
Chart Elements
Minimise Extraneous Chart Elements
The Chart Tools Contextual Tabs
Formatting the Chart with a Style
Adding a Legend to the Chart
TOPIC C: Create a Trend-line
Types of Trend-lines
Adding a Trend-line
The Format Trend-line Task Pane
TOPIC D: Create Advanced Charts
Dual Axis Charts
Creating Custom Chart Templates
Viewing Chart Animations
Lesson 5: Analysing Data with PivotTables, Slicers, and PivotCharts
TOPIC A: Create a PivotTable
Start with Questions, End with Structure
The Create PivotTable Dialog Box
The PivotTable Fields Pane
Summarise Data in a PivotTable
The “Show Values As” Functionality of a PivotTable
External Data
PowerPivot Functions
TOPIC B: Filter Data by Using Slicers
The Insert Slicers Dialog Box
TOPIC C: Analyse Data with PivotCharts
Creating PivotCharts
Applying a Style to a PivotChart
Lesson 6: Inserting Graphics
TOPIC A: Insert and Modify Graphic Objects
Graphical Objects
Inserting Shapes
Inserting WordArt
Inserting Text Boxes
Inserting Images
The Picture Tools – Format Contextual Tab
The Drawing Tools – Format Contextual Tab
The SmartArt Tools Contextual Tabs
TOPIC B: Layer and Group Graphic Objects
Layering Objects
Grouping Objects
Positioning Objects
TOPIC C: Incorporate SmartArt
About SmartArt
The Choose a SmartArt Graphic Dialog Box
About the Text Pane
Lesson 7: Enhancing Workbooks
TOPIC A: Customise Workbooks
Background Pictures
TOPIC B: Manage Themes
About Themes
Customising Themes
TOPIC C: Create and Use Templates
Template Types
Creating a Template
Modifying a Template
TOPIC D: Protect Files
Recovering Lost Data
The Changes Group
Worksheet and Workbook Protection
The Protect Worksheet Option
The Protect Workbook Option
TOPIC E: Preparing a Workbook for Multiple Audiences
Displaying Data in Multiple International Formats
Utilise International Symbols
Modifying Worksheets Using the Accessibility Checker
Managing Fonts


Microsoft Short Course Enrolment Form

TBST offers powerful short course training opportunities in both Microsoft Office 2013 & 2016.

Whether your creating professional-looking presentations, working on spreadsheets, or word processing, Microsoft Office allows you to open, save, modify, or collaborate on documents in the cloud, so you can maximise efficiencies & do great work anywhere, anytime.

Short course online training is a powerful way to learn.

TBST's Available Courses

Browse our range of government funded, fee paying and MYOB courses.