Duration: 2 days
Time: 9am to 5.30pm

What Will Be Taught For This Microsoft Excel 2019 Course?

The course empowers the trainee to understand the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer. He or she will understand and be able to accomplish basic operations associated with developing, formatting and using a spreadsheet. Additionally, trainee will be able to accomplish standard mathematical operations using basic formulas and functions. The trainee will be able to demonstrate competence in using some of the features Excel such as filtering, managing data and creating charts.

Module 1. Exploring Microsoft Excel 2019

  • Starting Excel 2019
  • The User Interface
  • The Backstage View
  • Excel Options
  • Working with Worksheets
  • Using the Ribbon
  • Hiding the Ribbon
  • Customizing the Quick Access Toolbar
  • Customizing Tabs
  • Customizing the Ribbon
  • Customizing the Status Bar
  • Exiting Excel
  • Practice - Exploring Microsoft Excel 2019

Module 2. Getting Help

  • Using Microsoft Excel Tell Me featureces
  • Practice - Getting Help

Module 3. 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
  • Copying and Pasting Data
  • Paste Options
  • Paste List
  • Spell Check
  • Creating a New Folder When Saving
  • Saving the Workbook with Another Name
  • Practice - Basic Workbook Skills

Module 4. 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 5. 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 6. Number Formatting

  • About Number Formats
  • Accounting Number Style
  • Percent Style
  • Comma Style
  • Decimal Places
  • Practice – Number Formatting

Module 7. 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 8. 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
  • Inserting Selected Cells
  • Inserting Cut or Copied Cells
  • Deleting Cells
  • Practice – Cell Formatting

Module 9. Filtering Data with AutoFilter

  • Enabling AutoFilter
  • Filtering a List
  • Clearing Criteria
  • Creating a Custom AutoFilter
  • Disabling AutoFilter
  • Practice – Filtering Data with AutoFilter

Module 10. 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
  • Multi-level Sorting
  • Practice - Working with Tables

Module 11. 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
  • Filling Cells
  • Modifying Formulas using the Range Border
  • Undo and Redo
  • Error Checking
  • Practice – Basic Formulas

Module 12. Data Management

  • Sorting
  • Sorting Multiple Columns
  • Finding Data
  • Replacing Data
  • Finding and Replacing Cell Format
  • Practice – Data Management

Module 13. Creating Charts

  • Inserting a column chart
  • Inserting a line chart
  • Inserting a bar chart
  • Inserting a pie chart
  • Resizing a chart
  • Deleting a chart
  • Adding a Chart Title
  • Changing the Chart Background
  • Changing a column, bar, line or pie slice colors
  • 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 Sparklines
  • Practice - Creating Charts

Module 14. 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
  • Practice - Using Page Setup

Module 15. Printing

  • Print Preview
  • Printing the Current Worksheet
  • Printing a Selected Range
  • Printing a Page Range
  • Printing Multiple Copies
  • Practice - Printing

Who Should Attend This Microsoft Excel Course 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 $450 $481.50

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 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.