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
Functions
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
Fonts
The Font Group
The Format Cells Dialog Box
The Format Painter
Galleries
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.