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

Course Code: CRS-N-0048599

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.

  • Understand the basic concepts of spreadsheets
  • Demonstrate the ability to use a spreadsheet application

Basic workbook skills

  • Using Tell Me feature
  • Using GoTo
  • Entering text
  • Entering numbers
  • Saving the workbook
  • Closing the workbook
  • Creating a workbook
  • Opening a workbook
  • Shortcuts for data entry
  • Editing data
  • Using the keyboard to select cells
  • Using KeyTips
  • Using the mouse to scroll
  • Using the scroll bar shortcut menu
  • Spell check
  • Copying and pasting data
  • Use undo and redo
  • Spell check
  • Insert comment
  • Insert link

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

Basic formulas

  • Using basic formulas
  • Entering formulas
  • Basic functions
  • Using the AutoSum button
  • Using the AutoSum list
  • Editing functions
  • Using auto calculate
  • Filling cells

Using page setup and printing

  • 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
  • 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 2019 and looking to acquire solid foundational skills to perform basic spreadsheet functions.

Prerequisite

Participants must have a basic knowledge of Windows / 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
  • Understand the basic concepts of spreadsheets
  • Demonstrate the ability to use a spreadsheet application
Course Contents

Basic workbook skills

  • Using Tell Me feature
  • Using GoTo
  • Entering text
  • Entering numbers
  • Saving the workbook
  • Closing the workbook
  • Creating a workbook
  • Opening a workbook
  • Shortcuts for data entry
  • Editing data
  • Using the keyboard to select cells
  • Using KeyTips
  • Using the mouse to scroll
  • Using the scroll bar shortcut menu
  • Spell check
  • Copying and pasting data
  • Use undo and redo
  • Spell check
  • Insert comment
  • Insert link

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

Basic formulas

  • Using basic formulas
  • Entering formulas
  • Basic functions
  • Using the AutoSum button
  • Using the AutoSum list
  • Editing functions
  • Using auto calculate
  • Filling cells

Using page setup and printing

  • 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
  • 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 2019 and looking to acquire solid foundational skills to perform basic spreadsheet functions.

Prerequisite

Participants must have a basic knowledge of Windows / 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 8, 2020 - January 8, 2020 (9:00 am - 5:30 pm) Closed
February 19, 2020 - February 19, 2020 (9:00 am - 5:30 pm) Closed
March 19, 2020 - March 19, 2020 (9:00 am - 5:30 pm) Closed
August 3, 2020 - August 3, 2020 (9:00 am - 5:30 pm) Register Now
September 9, 2020 - September 9, 2020 (9:00 am - 5:30 pm) Register Now
October 7, 2020 - October 7, 2020 (9:00 am - 5:30 pm) Register Now
November 11, 2020 - November 11, 2020 (9:00 am - 5:30 pm) Register Now
December 2, 2020 - December 2, 2020 (9:00 am - 5:30 pm) Register Now