Microsoft Excel 2019 Intermediate (1 Day) (7.5 hrs)

Course Code: CRS-N-0048598

This course introduces the participants to intermediate features of Microsoft Excel 2019. They will learn how to generate reports from Excel data. The participants will learn how to highlight important data using conditional formats, prevent date entry errors using Data Validation, and demonstrate the ability to manage data efficiently.

  • Learn about the intermediate features of Microsoft Excel 2019
  • Generate reports from Excel data
  • Demonstrate ability to manage data

Working with databases

  • Creating subtotals in a list
  • Removing subtotals from a list
  • Insert slicer
  • Sorting data by multiple levels
  • Using custom sort
  • Using data validation
  • Validating data using a list
  • Creating a custom error message
  • Removing data validation
  • Using flash fill

Using templates

  • Saving a workbook as a template
  • Using a template
  • Editing a template
  • Inserting a new worksheet
  • Hiding / unhiding a worksheet
  • Deleting a template
  • Finding online templates

Creating charts

  • Use recommended charts
  • Inserting a column chart
  • Resizing a chart
  • Deleting 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
  • New chart types (map, funnel)

Revising charting features

  • Formatting an axis
  • Changing the axis scaling
  • Formatting the data series
  • Adding data from different worksheets
  • Using a secondary axis
  • Changing data series chart types
  • Changing source data range

Working with advanced filters

  • Creating a criteria range
  • Using a criteria range
  • Showing all records
  • Using an advanced and / or condition
  • Copying filtered records
  • Using database functions
  • Finding unique records

Using conditional and custom formats

  • Applying conditional formats
  • Changing a conditional format
  • Adding a conditional format
  • Creating a custom conditional format
  • Using data bars
  • Deleting a conditional format
  • Creating a custom number format

Using worksheet protection

  • Unlocking cells in a worksheet
  • Protecting a worksheet
  • Unprotecting a worksheet
  • Creating allow-editing ranges
  • Deleting allow-editing ranges
  • Assigning a password
  • Opening a password-protected file
  • Removing a password

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

This course is suitable for individuals with the basic understanding of Microsoft Excel and wishes to be equipped with intermediate skill sets such as generating reports and data management.

Prerequisite

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

Duration : 1 day (7.5 hrs)
Time : 9:00am – 5:30pm

Course Fee : $200.00
Nett Fee Incl. 7% GST : $214.00
SDF Support* : $15.00

* Please click HERE for detailed information on course fee funding schemes, SkillsFuture credit, and complete listing of funded courses. This course is eligible for use of SkillsFuture credit.

(A course in partnership with COMAT)

Key Benefits
  • Learn about the intermediate features of Microsoft Excel 2019
  • Generate reports from Excel data
  • Demonstrate ability to manage data
Course Contents

Working with databases

  • Creating subtotals in a list
  • Removing subtotals from a list
  • Insert slicer
  • Sorting data by multiple levels
  • Using custom sort
  • Using data validation
  • Validating data using a list
  • Creating a custom error message
  • Removing data validation
  • Using flash fill

Using templates

  • Saving a workbook as a template
  • Using a template
  • Editing a template
  • Inserting a new worksheet
  • Hiding / unhiding a worksheet
  • Deleting a template
  • Finding online templates

Creating charts

  • Use recommended charts
  • Inserting a column chart
  • Resizing a chart
  • Deleting 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
  • New chart types (map, funnel)

Revising charting features

  • Formatting an axis
  • Changing the axis scaling
  • Formatting the data series
  • Adding data from different worksheets
  • Using a secondary axis
  • Changing data series chart types
  • Changing source data range

Working with advanced filters

  • Creating a criteria range
  • Using a criteria range
  • Showing all records
  • Using an advanced and / or condition
  • Copying filtered records
  • Using database functions
  • Finding unique records

Using conditional and custom formats

  • Applying conditional formats
  • Changing a conditional format
  • Adding a conditional format
  • Creating a custom conditional format
  • Using data bars
  • Deleting a conditional format
  • Creating a custom number format

Using worksheet protection

  • Unlocking cells in a worksheet
  • Protecting a worksheet
  • Unprotecting a worksheet
  • Creating allow-editing ranges
  • Deleting allow-editing ranges
  • Assigning a password
  • Opening a password-protected file
  • Removing a password
Learning Methodology

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

Who Should Attend

This course is suitable for individuals with the basic understanding of Microsoft Excel and wishes to be equipped with intermediate skill sets such as generating reports and data management.

Prerequisite

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

Course Details

Duration : 1 day (7.5 hrs)
Time : 9:00am – 5:30pm

Course Fee : $200.00
Nett Fee Incl. 7% GST : $214.00
SDF Support* : $15.00

* Please click HERE for detailed information on course fee funding schemes, SkillsFuture credit, and complete listing of funded courses. This course is eligible for use of SkillsFuture credit.

(A course in partnership with COMAT)

Course Application

Details Registration
January 28, 2020 - January 28, 2020 (9:00 am - 5:30 pm) Closed
February 24, 2020 - February 24, 2020 (9:00 am - 5:30 pm) Closed
March 20, 2020 - March 20, 2020 (9:00 am - 5:30 pm) Closed
August 4, 2020 - August 4, 2020 (9:00 am - 5:30 pm) Closed
September 10, 2020 - September 10, 2020 (9:00 am - 5:30 pm) Closed
October 15, 2020 - October 15, 2020 (9:00 am - 5:30 pm) Register Now
November 16, 2020 - November 16, 2020 (9:00 am - 5:30 pm) Register Now
December 3, 2020 - December 3, 2020 (9:00 am - 5:30 pm) Register Now