skip to navigation skip to content
Self-taught course

Provided by: University Information Services - Digital Literacy Skills


This course is self taught (Materials may be loaned out).

Bookings cannot be made on this course (Course is not taking bookings).

More information about UIS self-taught courses.

Booking / availability

Microsoft Excel 2016 Level 1 (with Challenge Exercises)

Self-taught course


Microsoft Excel 2016 - Level 1 is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel 2016. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

Target audience

Microsoft Excel 2016 - Level 1 assumes little or no knowledge of spreadsheets or Microsoft Excel 2016.


It would also be beneficial to have a general understanding of personal computers and the operating system environment, especially in regard to working with files and folders.

Topics covered

Getting To Know Excel 2016

  • Starting Excel From The Desktop
  • Understanding The Excel Start Screen
  • The Excel Workbook Screen
  • How Excel 2016 Works
  • Using The Ribbon
  • Showing And Collapsing The Ribbon
  • Understanding The Backstage View
  • Accessing The Backstage View
  • Using Shortcut Menus
  • Understanding Dialog Boxes
  • Launching Dialog Boxes
  • Understanding The Quick Access Toolbar
  • Adding Commands To The QAT
  • Understanding The Status Bar
  • Exiting Safely From Excel 2016
  • Practice Exercise
  • Practice Exercise Workspace

Creating A New Workbook

  • Understanding Workbooks
  • Using The Blank Workbook Template
  • Typing Text
  • Typing Numbers
  • Typing Dates
  • Typing Formulas
  • Easy Formulas
  • Saving A New Workbook On Your Computer
  • Checking The Spelling
  • Making Basic Changes
  • Safely Closing A Workbook
  • Practice Exercise
  • Practice Exercise Sample

Working With Workbooks

  • Opening An Existing Workbook
  • Navigating A Workbook
  • Navigating Using The Keyboard
  • Using Go To
  • Recent Files And Folders
  • Practice Exercise
  • Practice Exercise Sample

Editing In A Workbook

  • Understanding Data Editing
  • Overwriting Cell Contents
  • Editing Longer Cells
  • Editing Formulas
  • Clearing Cells
  • Deleting Data
  • Using Undo And Redo
  • Practice Exercise
  • Practice Exercise Sample

Selecting Ranges

  • Understanding Cells And Ranges
  • Selecting Contiguous Ranges
  • Selecting Non-Contiguous Ranges
  • Selecting Larger Ranges
  • Selecting Rows
  • Selecting Columns
  • Practice Exercise
  • Practice Exercise Sample

Copying Data

  • Understanding Copying In Excel
  • Using Fill For Quick Copying
  • Copying From One Cell To Another
  • Copying From One Cell To A Range
  • Copying From One Range To Another
  • Practice Exercise
  • Practice Exercise Sample

Filling Data

  • Understanding Filling
  • Filling A Series
  • Filling A Growth Series
  • Extracting With Flash Fill
  • Practice Exercise
  • Practice Exercise Data

Moving Data

  • Understanding Moving In Excel
  • Moving Cells And Ranges
  • Moving By Dragging
  • Practice Exercise
  • Practice Exercise Sample

Formulas And Functions

  • Understanding Formulas
  • Creating Formulas That Add
  • Creating Formulas That Subtract
  • Formulas That Multiply And Divide
  • Understanding Functions
  • Using The SUM Function
  • Summing Non-Contiguous Ranges
  • Calculating An Average
  • Finding A Maximum Value
  • Finding A Minimum Value
  • Creating More Complex Formulas
  • What If Formulas
  • Common Error Messages
  • Practice Exercise
  • Practice Exercise Sample

Formula Referencing

  • Absolute Versus Relative Referencing
  • Relative Formulas
  • Problems With Relative Formulas
  • Creating Absolute References
  • Creating Mixed References
  • Practice Exercise
  • Practice Exercise Sample

Font Formatting

  • Understanding Font Formatting
  • Working With Live Preview
  • Changing Fonts
  • Changing Font Size
  • Growing And Shrinking Fonts
  • Making Cells Bold
  • Italicising Text
  • Underlining Text
  • Changing Font Colours
  • Changing Background Colours
  • Using The Format Painter
  • Practice Exercise
  • Practice Exercise Sample

Cell Alignment

  • Understanding Cell Alignment
  • Horizontal Cell Alignment
  • Vertical Cell Alignment
  • Indenting Cells
  • Practice Exercise
  • Practice Exercise Sample

Number Formatting

  • Understanding Number Formatting
  • Applying General Formatting
  • Formatting For Money
  • Formatting Percentages
  • Formatting As Fractions
  • Formatting As Dates
  • Using The Thousands Separator
  • Increasing And Decreasing Decimals
  • Practice Exercise
  • Practice Exercise Sample

Row And Column Formatting

  • Approximating Column Widths
  • Setting Precise Columns Widths
  • Setting The Default Column Width
  • Approximating Row Height
  • Setting Precise Row Heights
  • Practice Exercise
  • Practice Exercise Sample

Working With A Worksheet

  • Understanding Worksheets
  • Changing The Worksheet View
  • Worksheet Zooming
  • Viewing The Formula Bar
  • Viewing Worksheet Gridlines
  • Inserting Cells Into A Worksheet
  • Deleting Cells From A Worksheet
  • Inserting Columns Into A Worksheet
  • Inserting Rows Into A Worksheet
  • Deleting Rows And Columns
  • Working With Multiple Worksheets
  • Worksheet Wisdom
  • Practice Exercise
  • Practice Exercise Sample

Sorting Data

  • Understanding Lists
  • Performing An Alphabetical Sort
  • Performing A Numerical Sort
  • Sorting On More Than One Column
  • Practice Exercise
  • Practice Exercise Sample

Filtering Data

  • Understanding Filtering
  • Applying And Using A Filter
  • Clearing A Filter
  • Creating Compound Filters
  • Multiple Value Filters
  • Creating Custom Filters
  • Using Wildcards
  • Practice Exercise
  • Practice Exercise Sample


  • Understanding Printing
  • Previewing Before You Print
  • Selecting A Printer
  • Printing A Range
  • Printing An Entire Workbook
  • Specifying The Number Of Copies
  • The Print Options
  • Practice Exercise
  • Practice Exercise Sample

Creating Charts

  • Understanding The Charting Process
  • Choosing The Right Chart
  • Using A Recommended Chart
  • Creating A New Chart From Scratch
  • Working With An Embedded Chart
  • Resizing A Chart
  • Repositioning A Chart
  • Printing An Embedded Chart
  • Creating A Chart Sheet
  • Changing The Chart Type
  • Changing The Chart Layout
  • Changing The Chart Style
  • Printing A Chart Sheet
  • Embedding A Chart Into A Worksheet
  • Deleting A Chart
  • Practice Exercise
  • Practice Exercise Sample

Getting Help

  • Understanding How Help Works
  • Using Tell Me
  • Accessing The Help Window
  • Navigating The Help Window
  • Using Google To Get Help
  • Printing A Help Topic
  • Other Sources Of Assistance
  • Practice Exercise
  • Practice Exercise Workspace

A Guide To Brilliant Spreadsheets

  • Good Planning Is Essential
  • Organisation And Design
  • Writing Effective Formulas
  • Documented And Easy To Use
  • The Appropriateness Of Spreadsheets
  • Practice Exercise
  • Practice Exercise Workspace

At the completion of this course you should be able to:

  • Navigate your way around Microsoft Excel 2016
  • Create and work with a new workbook
  • Open and navigate within workbooks and worksheets
  • Make changes to data in a workbook
  • Understand and work with ranges in a worksheet
  • Copy and paste data in Excel
  • Use the fill operations available to fill a data series
  • Move the contents of cells and ranges within and between workbooks
  • Understand, create and work with formulas and functions
  • Understand and use formula cell referencing
  • Use font formatting techniques
  • Align the contents of cells in a number of ways
  • Understand and use the number formatting features in Excel
  • Format rows and columns in a worksheet
  • Work with elements that make up the structure of a worksheet
  • Sort data in a list in a worksheet
  • Filter data in a table
  • Print your workbook data
  • Create effective charts in Microsoft Excel
  • Obtain help for Excel whenever you need it
  • Understand points to consider to avoid problems in your worksheets

Watsonia workbook with 228 topics. Files for the exercises are provided on a CD or can be downloaded here


Approximately 20 hours

Related courses

Booking / availability