Duration: 2 days
Time: 9am to 6pm

Funding available for this course:

Skills Development Fund (SDF) SkillsFuture Credit SkillsFuture Mid-Career ETS (SMEs)  WTS PSEA

 

 

 

Virtual Instructor-Led Training (VILT) Schedule

  • This course is also conducted via VILT on 20-21 Apr.
  • The exam date for this class is scheduled on 22 Apr.
  • Trainee will be informed & guided on the exam process.

What Will Be Taught For This MS Excel Perform Spreadsheet Functions Course?

The Spreadsheets module allows candidates to understand the concept of spreadsheets and to demonstrate an ability to use a spreadsheet to produce accurate work outputs.

On completion of this module the candidate will be able to:

  • Work with spreadsheets and save them in different file formats, locally or in the cloud.
  • Use available help resources, shortcuts and the go to tool to enhance productivity.
  • Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognize error values in formulas.
  • Format numbers and text content in a spreadsheet and use available auto-format/table styles.
  • Choose suitable charts, and create and format charts to communicate information meaningfully.
  • Adjust spreadsheet page settings and check and correct spreadsheet content before printing.
Module 1. Exploring Microsoft Excel 2016
  • Starting Excel 2016
  • 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 2016
Module 2. Getting Help
  • Using Microsoft Excel Help and Resources
  • Working with Excel Help
  • Looking Further for Answers
  • 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
  • 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
  • Modifying Formulas using the Range Border
  • Error Checking
  • Practice – Basic Formulas
Module 12. Cut, Copy and Paste
  • Copying and Pasting Data
  • Cutting Data
  • Copying Formulas
  • Paste Options
  • Paste List
  • Filling Cells
  • Drag-and-Drop Editing
  • Undo and Redo
  • Practice – Cut, Copy and Paste
Module 13. Data Management
  • Sorting
  • Sorting Multiple Columns
  • Finding Data
  • Replacing Data
  • Finding and Replacing Cell Format
  • Practice – Data Management
Module 14. 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 15. 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 16. Printing
  • Print Preview
  • Printing the Current Worksheet
  • Printing a Selected Range
  • Printing a Page Range
  • Printing Multiple Copies
  • Practice - Printing

Who Should Attend This MS Excel Perform Spreadsheet Functions Course Training?

Ideal for beginners in Microsoft Office Excel to develop a solid foundational understanding of spreadsheet concepts and applications.

Pre-requisite

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

  w/o GST w GST
Course Fee $380 $406.60
Singapore Citizen & PR aged ≥ 21 years $91 $117.60
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$38 $64.60
Singapore Citizen aged ≥ 35 years with earning ≤ $2,000/month
(WTS Scheme)
$19 $45.60

 

  w/o GST w GST
Course Fee $380 $406.60
Singapore Citizen & PR aged ≥ 21 years $91 $117.60
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$38 $64.60
Singapore Citizen aged ≥ 35 years with earning ≤ $2,000/month
(WTS Scheme)
$19 $45.60

 

  w/o GST w GST
Course Fee $380 $406.60
Singapore Citizen & PR aged ≥ 21 years $38 $64.60
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$38 $64.60
Singapore Citizen aged ≥ 35 years with earning ≤ $2,000/month
(WTS Scheme)
$19 $45.60

 


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.