Duration: 1 day
Time: 9am to 5.30pm

What Will Be Taught For This Microsoft Excel 2019 Course?

In this course, the participant will understand the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer. He or she shall understand and be able to accomplish basic operations associated with developing, formatting and using a spreadsheet.

Module 1. 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
  • Copying and Pasting Data
  • Use Undo and Redo
  • Spell Check
  • Insert Comment
  • Insert Link
  • Practice - Basic Workbook Skills
Module 2. 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
  • Practice – Selection
Module 3. 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
  • Practice - Working with Columns and Rows
Module 4. Number Formatting
  • About Number Formats
  • Accounting Number Style
  • Percent Style
  • Comma Style
  • Decimal Places
  • Practice – Number Formatting
Module 5. Text Formatting
  • Formatting Text
  • Changing the Font
  • Changing Font Size
  • Bold and Italic
  • Underlining Text
  • Font Color
  • Rotating Text
  • Text Wrapping
  • Shrinking Text
  • Cell Alignment
  • Indenting Text
  • Practice – Text Formatting
Module 6. Cell Formatting
  • Merging Cells
  • Vertical Alignment
  • Splitting Cells
  • Adding Borders
  • Drawing Borders
  • Adding Fill Color to Cells
  • Pasting Formats
  • Format Painter
  • Copying Formats using Auto Fill
  • Clearing Formats
  • Practice – Cell Formatting
Module 7. Basic Formulas
  • Using Basic Formulas
  • Entering Formulas
  • Basic Functions
  • Using the AutoSum Button
  • Using the AutoSum List
  • Editing Functions
  • Using Auto Calculate
  • Filling Cells
  • Practice – Basic Formulas
Module 8. Using Page Setup & 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
  • Practice – Page Setup & Printing

Who Should Attend This Microsoft Excel 2019 Training?

Designed for anyone with minimal or no prior knowledge of Microsoft Excel 2019 and looking to acquire solid foundational skills to perform basic spreadsheet functions.

Pre-requisite

An understanding of Windows / Microsoft Excel 2010/2013/2019 will be an added advantage.

  w/o GST w GST
Course Fee $200 $214

This course is applicable for Skills Development Fund (SDF).


Remarks:

COMAT is a business centre of e-Services, Electronics, ST Engineering.

Individual Sponsored

  • Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding.
  • This course is supported under UTAP funding.
  • This course is eligible for using PSEA funds.

Terms & Conditions

  • All prices stated above are in Singapore Dollars (SGD). This funding support is only applicable for Singapore Citizen and Permanent Residents.
  • Trainee must attain minimum 75% attendance in order to qualify for Funding.
  • Trainee undertakes to reimburse e-Services, Electronics, ST Engineering FULL course fees should he/she be ineligible for course fee grant. e-Services, Electronics, ST Engineering is not liable for any other funding not approved by WSG.
  • e-Services, Electronics, ST Engineering reserves the right to change the date or venue without prior notice.
  • e-Services, Electronics, ST Engineering reserves the right to cancel or reschedule the course due to class size or unforeseen circumstances.


Please click on the course date to enrol.