Microsoft Excel 2016 Basic and Intermediate (2 Days) (15 hrs)

Course Code: MO-EBI6-01

This course provides the participants with an understanding of the basic concepts of spreadsheets and demonstrates the ability to use a spreadsheet application on a personal computer. The participants will be able to accomplish basic operations associated with developing, formatting and using a spreadsheet. They will also learn to perform standard mathematical operations using basic formulas and functions, as well as demonstrate competence in using features such as filtering, managing data, and creating charts.

  • Understand the basic concepts of spreadsheets
  • Demonstrate the ability to use a spreadsheet application
  • Perform standard mathematical operations

Exploring Microsoft Excel 2016

  • Starting Excel 2016
  • The User Interface
  • The Backstage View
  • Excel options
  • Working with worksheets
  • Using the ribbon
  • Hiding the ribbon
  • Customising the Quick Access Toolbar
  • Customising tabs
  • Customising the ribbon
  • Customising the status bar
  • Exiting Excel

Getting help

  • Using Microsoft Excel Help and Resources
  • Working with Excel Help
  • Looking further for answers

Basic workbook skills

  • Using the keyboard to select cells
  • Using KeyTips
  • Using the mouse to scroll
  • Using the scroll bar shortcut menu
  • Using GoTo
  • Entering text
  • Entering numbers
  • Saving the workbook
  • Closing the workbook
  • Creating a workbook
  • Opening a workbook
  • Shortcuts for data entry
  • Editing data
  • Spell check
  • Creating a new folder when saving
  • Saving the workbook with another name

Selection

  • Selecting a cell
  • Selecting a range of contiguous cells
  • Selecting a range of non-contiguous cells
  • Selecting the entire worksheet
  • Selecting a row
  • Selecting a range of contiguous rows
  • Selecting a range of non-contiguous rows
  • Selecting an entire column
  • Selecting a range of columns
  • Selecting a range of non-contiguous columns

Working with columns and rows

  • Adjusting the column width
  • Adjusting the row height
  • Automatically adjusting columns
  • Hiding and un-hiding rows and columns
  • Inserting columns and rows
  • Deleting columns and rows
  • Freezing and unfreezing columns and rows

Number formatting

  • About number formats
  • Accounting number style
  • Percent style
  • Comma style
  • Decimal places

Text formatting

  • Formatting text
  • Changing the font
  • Changing font size
  • Bold and italic
  • Underlining text
  • Font colour
  • Rotating text
  • Text wrapping
  • Shrinking text
  • Cell alignment
  • Indenting text

Cell formatting

  • Merging cells
  • Vertical alignment
  • Splitting cells
  • Adding borders
  • Drawing borders
  • Adding fill colour to cells
  • Pasting formats
  • Format painter
  • Copying formats using auto fill
  • Clearing formats
  • Inserting selected cells
  • Inserting cut or copied cells
  • Deleting cells

Filtering data with AutoFilter

  • Enabling AutoFilter
  • Filtering a list
  • Clearing criteria
  • Creating a custom AutoFilter
  • Disabling AutoFilter

Working with tables

  • Formatting data as a table
  • Applying table styles
  • Changing the table style
  • Table style options
  • Working with the total row
  • Adding table rows and columns
  • Adding a calculated column

Basic formulas

  • Using basic formulas
  • Entering formulas
  • Basic functions
  • Using the AutoSum button
  • Using the AutoSum list
  • Using formula AutoComplete
  • Editing functions
  • Using auto calculate
  • Modifying formulas using the Range Border
  • Error checking
  • Creating an absolute addressing
  • Using the IF function

Cut, copy and paste

  • Copying and pasting data
  • Cutting data
  • Copying formulas
  • Paste options
  • Paste list
  • Filling cells
  • Drag-and-drop editing
  • Undo and redo

Data management

  • Sorting
  • Sorting multiple columns
  • Finding data
  • Replacing data
  • Finding and replacing cell format

Creating charts

  • Inserting a column chart
  • Inserting a line chart
  • Inserting a bar chart
  • Inserting a pie chart
  • Resizing a chart
  • Adding a chart title
  • Changing the chart background
  • Changing a column, bar, line or pie slice colours
  • Changing the chart type
  • Adding a data table
  • Changing the chart layout
  • Copying and moving charts
  • Creating a 3-D chart
  • Adjusting 3-D view
  • Inserting Sparkline

Using page setup

  • Worksheet margins
  • Worksheet orientation
  • Worksheet page size
  • Headers and footers
  • Header and footer fields
  • Scaling your worksheet to fit a page(s)
  • Repeating row and column labels
  • Changing page breaks
  • Setting / removing a print area
  • Changing sheet options

Printing

  • Print preview
  • Printing the current worksheet
  • Printing a selected range
  • Printing a page range
  • Printing multiple copies

Participants will benefit from the hands-on practical sessions during the course.

This course is suitable for anyone with minimal or no prior knowledge of Microsoft Excel 2016 and looking to acquire solid foundational skills to perform basic spreadsheet functions.

Prerequisite

Participants must have a basic knowledge of Windows / Microsoft Excel 2013.

Duration : 2 days (15 hrs)
Time : 9:00am – 5:30pm

Course Fee : $450.00
Nett Fee Incl. 7% GST : $481.50

(A course in partnership with COMAT)

Key Benefits
  • Understand the basic concepts of spreadsheets
  • Demonstrate the ability to use a spreadsheet application
  • Perform standard mathematical operations
Course Contents

Exploring Microsoft Excel 2016

  • Starting Excel 2016
  • The User Interface
  • The Backstage View
  • Excel options
  • Working with worksheets
  • Using the ribbon
  • Hiding the ribbon
  • Customising the Quick Access Toolbar
  • Customising tabs
  • Customising the ribbon
  • Customising the status bar
  • Exiting Excel

Getting help

  • Using Microsoft Excel Help and Resources
  • Working with Excel Help
  • Looking further for answers

Basic workbook skills

  • Using the keyboard to select cells
  • Using KeyTips
  • Using the mouse to scroll
  • Using the scroll bar shortcut menu
  • Using GoTo
  • Entering text
  • Entering numbers
  • Saving the workbook
  • Closing the workbook
  • Creating a workbook
  • Opening a workbook
  • Shortcuts for data entry
  • Editing data
  • Spell check
  • Creating a new folder when saving
  • Saving the workbook with another name

Selection

  • Selecting a cell
  • Selecting a range of contiguous cells
  • Selecting a range of non-contiguous cells
  • Selecting the entire worksheet
  • Selecting a row
  • Selecting a range of contiguous rows
  • Selecting a range of non-contiguous rows
  • Selecting an entire column
  • Selecting a range of columns
  • Selecting a range of non-contiguous columns

Working with columns and rows

  • Adjusting the column width
  • Adjusting the row height
  • Automatically adjusting columns
  • Hiding and un-hiding rows and columns
  • Inserting columns and rows
  • Deleting columns and rows
  • Freezing and unfreezing columns and rows

Number formatting

  • About number formats
  • Accounting number style
  • Percent style
  • Comma style
  • Decimal places

Text formatting

  • Formatting text
  • Changing the font
  • Changing font size
  • Bold and italic
  • Underlining text
  • Font colour
  • Rotating text
  • Text wrapping
  • Shrinking text
  • Cell alignment
  • Indenting text

Cell formatting

  • Merging cells
  • Vertical alignment
  • Splitting cells
  • Adding borders
  • Drawing borders
  • Adding fill colour to cells
  • Pasting formats
  • Format painter
  • Copying formats using auto fill
  • Clearing formats
  • Inserting selected cells
  • Inserting cut or copied cells
  • Deleting cells

Filtering data with AutoFilter

  • Enabling AutoFilter
  • Filtering a list
  • Clearing criteria
  • Creating a custom AutoFilter
  • Disabling AutoFilter

Working with tables

  • Formatting data as a table
  • Applying table styles
  • Changing the table style
  • Table style options
  • Working with the total row
  • Adding table rows and columns
  • Adding a calculated column

Basic formulas

  • Using basic formulas
  • Entering formulas
  • Basic functions
  • Using the AutoSum button
  • Using the AutoSum list
  • Using formula AutoComplete
  • Editing functions
  • Using auto calculate
  • Modifying formulas using the Range Border
  • Error checking
  • Creating an absolute addressing
  • Using the IF function

Cut, copy and paste

  • Copying and pasting data
  • Cutting data
  • Copying formulas
  • Paste options
  • Paste list
  • Filling cells
  • Drag-and-drop editing
  • Undo and redo

Data management

  • Sorting
  • Sorting multiple columns
  • Finding data
  • Replacing data
  • Finding and replacing cell format

Creating charts

  • Inserting a column chart
  • Inserting a line chart
  • Inserting a bar chart
  • Inserting a pie chart
  • Resizing a chart
  • Adding a chart title
  • Changing the chart background
  • Changing a column, bar, line or pie slice colours
  • Changing the chart type
  • Adding a data table
  • Changing the chart layout
  • Copying and moving charts
  • Creating a 3-D chart
  • Adjusting 3-D view
  • Inserting Sparkline

Using page setup

  • Worksheet margins
  • Worksheet orientation
  • Worksheet page size
  • Headers and footers
  • Header and footer fields
  • Scaling your worksheet to fit a page(s)
  • Repeating row and column labels
  • Changing page breaks
  • Setting / removing a print area
  • Changing sheet options

Printing

  • Print preview
  • Printing the current worksheet
  • Printing a selected range
  • Printing a page range
  • Printing multiple copies
Learning Methodology

Participants will benefit from the hands-on practical sessions during the course.

Who Should Attend

This course is suitable for anyone with minimal or no prior knowledge of Microsoft Excel 2016 and looking to acquire solid foundational skills to perform basic spreadsheet functions.

Prerequisite

Participants must have a basic knowledge of Windows / Microsoft Excel 2013.

Course Details

Duration : 2 days (15 hrs)
Time : 9:00am – 5:30pm

Course Fee : $450.00
Nett Fee Incl. 7% GST : $481.50

(A course in partnership with COMAT)

Course Application

Details Registration
January 2, 2020 - January 3, 2020 (9:00 am - 5:30 pm) Closed
January 13, 2020 - January 14, 2020 (9:00 am - 5:30 pm) Closed
January 28, 2020 - January 29, 2020 (9:00 am - 5:30 pm) Closed
February 6, 2020 - February 7, 2020 (9:00 am - 5:30 pm) Closed
February 20, 2020 - February 21, 2020 (9:00 am - 5:30 pm) Closed
February 27, 2020 - February 28, 2020 (9:00 am - 5:30 pm) Closed
March 5, 2020 - March 6, 2020 (9:00 am - 5:30 pm) Closed
March 16, 2020 - March 17, 2020 (9:00 am - 5:30 pm) Closed
March 30, 2020 - March 31, 2020 (9:00 am - 5:30 pm) Closed
August 6, 2020 - August 7, 2020 (9:00 am - 5:30 pm) Closed
August 13, 2020 - August 14, 2020 (9:00 am - 5:30 pm) Closed
August 27, 2020 - August 28, 2020 (9:00 am - 5:30 pm) Closed
September 3, 2020 - September 4, 2020 (9:00 am - 5:30 pm) Closed
September 17, 2020 - September 18, 2020 (9:00 am - 5:30 pm) Closed
September 28, 2020 - September 29, 2020 (9:00 am - 5:30 pm) Closed
October 8, 2020 - October 9, 2020 (9:00 am - 5:30 pm) Register Now
October 19, 2020 - October 20, 2020 (9:00 am - 5:30 pm) Register Now
October 29, 2020 - October 30, 2020 (9:00 am - 5:30 pm) Register Now
November 5, 2020 - November 6, 2020 (9:00 am - 5:30 pm) Register Now
November 16, 2020 - November 17, 2020 (9:00 am - 5:30 pm) Register Now
November 23, 2020 - November 24, 2020 (9:00 am - 5:30 pm) Register Now
December 3, 2020 - December 4, 2020 (9:00 am - 5:30 pm) Register Now
December 17, 2020 - December 18, 2020 (9:00 am - 5:30 pm) Register Now
December 28, 2020 - December 29, 2020 (9:00 am - 5:30 pm) Register Now