Duration: 1 day
Time: 9am to 5.30pm

Funding available for this course :

SkillsFuture Credit PSEA UTAP Broad based Funding

 

 

 

 

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
  • 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
  • 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 2007/2010/2013 will be an added advantage.

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

 


CANCELLATION/POSTPONEMENT / CHANGE of VENUE

  1. 2 to 4 weeks’ written notice from start date of training - 50% of course fee for cancellation

  2. Less than 2 weeks’ written notice from start date of training - 100% of course fees for postponement or cancellation

  3. ST Electronics (e-Services) Pte Ltd reserves the right to cancel or postpone any course or change the venue due to unforeseen circumstances.

Trainee shall be bound by the Terms and Conditions of any applicable funding scheme.

Please ensure that you have read our Terms and Conditions before submitting the enrolment form.






Please click on the course date to enrol.