Microsoft Courses

Short Courses

Microsoft Excel 2016 Foundation Topics

Lesson 1: Getting Started with Microsoft Excel 2016
TOPIC A: Identify the Elements of the Excel Interface
Microsoft Excel 2016
What are Spreadsheets, Worksheets, and Workbooks?
What are Columns, Rows, Cells, and Ranges?
The Excel Interface
Navigation Options
Creating a New Blank Workbook
Creating a New Workbook from a Template
TOPIC B: Create a Basic Worksheet
The Ribbon
The Backstage View
Data Types
Excel 2016 File Formats
The Save and Save As Commands
Saving to Microsoft OneDrive
Compatibility Mode
The Convert Option
The Compatibility Checker
Checking for Accessibility Issues
TOPIC C: Use the Help System
Using Tell Me
Accessing Advanced Help Options
Lesson 2: Performing Calculations
TOPIC A: Create Formulas in a Worksheet
Excel Formulas
The Formula Bar
Elements of an Excel Formula
Common Mathematical Operators
The Order of Operations
TOPIC B: Insert Functions in a Worksheet
The Function Library
Common Functions in Excel
The Formula AutoComplete Feature
TOPIC C: Reuse Formulas
The Cut, Copy, and Paste Commands
Paste Special Options
Relative References
Absolute References
Mixed References
Lesson 3: Modifying a Worksheet
TOPIC A: Manipulate Data
The Undo and Redo Commands
The AutoFill Feature
AutoFill Options
The Transpose Option
Live Preview
The Clear Button
TOPIC B: Insert, Manipulate, and Delete Cells, Columns, and Rows
The Insert and Delete Options
Column Width and Row Height Alternation Methods
The Hide and Unhide Options
TOPIC C: Search For and Replace Data
Cell Names and Range Names
The Find Command
The Replace Command
The Go To Command
TOPIC D: Spell Check a Worksheet
The Spelling Dialog Box
Lesson 4: Formatting a Worksheet
TOPIC A: Modify Fonts
The Font Group
The Format Cells Dialog Box
The Format Painter
Live Preview and Formatting
The Mini Toolbar
TOPIC B: Add Borders and Colours to Cells
Border Options
Fill Options
Sheet Backgrounds
Paste Options
TOPIC C: Apply Number Formats
Number Formats
Number Formats in Excel
Custom Number Formats
TOPIC D: Align Cell Contents
Alignment Options
The Indent Commands
The Wrap Text Command
Orientation Options
The Merge & Centre Options
TOPIC E: Apply Cell Styles
Cell Styles
The Style Dialog Box
Lesson 5: Printing Workbook Contents
TOPIC A: Define the Basic Page Layout for a Workbook
The Print Options in Backstage View
The Page Setup Dialog Box
The Print Preview Option
Workbook Views
Headers and Footers
Header and Footer Settings
Page Margins
Margins Tab Options
Page Orientation
TOPIC B: Refine the Page Layout and Apply Print Options
Zoom Options
Page Breaks
Page Break Options
The Print Area
Print Titles
Scaling Options
Lesson 6: Managing Large Workbooks
TOPIC A: Format Worksheet Tabs
Renaming Worksheet Tabs
Changing Tab Colour
TOPIC B: Manage Worksheets
Grouped Worksheets
Repositioning Worksheets
Inserting or Deleting Worksheets
Hiding and Unhiding Worksheets
Worksheet References in Formulas
TOPIC C: Manage the View of Worksheets and Workbooks
The Split Command
The Freeze Panes Options
The Arrange All Command
The Arrange Windows Dialog Box
The View Side by Side Command
The Switch Windows Command
The New Window Command
Lesson 7: Customising the Excel Environment
TOPIC A: Customise General and Language Options
The Excel Options Dialog Box
The General Category
The Language Category
TOPIC B: Customise Formula Options
The Formulas Category
TOPIC C: Customise Proofing and Save Options
The Proofing Category
The Save Category
Version Control
TOPIC D: Customise the Ribbon and Quick Access Toolbar
The Customise Ribbon Category
The Quick Access Toolbar Category
TOPIC E: Customise the Functionality of Excel by Enabling Add-Ins
What Are Add-ins?
The Add-Ins Category
The Developer Tab
TOPIC F: Customise Advanced and Trust Centre Options
The Advanced Category
The Trust Centre Category


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.