Duration: 1 day
Time: 9am to 5.30pm

What Will Be Taught For This Microsoft Excel 2016 Course?

In this course, the participant will be introduced to the more intermediate features of Microsoft Excel 2016. The participant will learn how to generate reports from Excel data. The course also shows the participant how to highlight important data using conditional formats, prevent date entry errors using Data Validation. At the end of the course, the participant will be able to demonstrate the ability to manage data efficiently with Microsoft Excel 2016.

Module 1. Data Management
  • Sorting
  • Sorting Multiple Columns
  • Finding Data
  • Replacing Data
  • Finding and Replacing Cell Format
  • Practice – Data Management
Module 2. Working with Databases
  • Creating Subtotals in a List
  • Removing Subtotals from a List
  • Sorting Data by Multiple Levels
  • Using Custom Sort
  • Using Data Validation
  • Validating Data using a List
  • Creating a Custom Error Message
  • Removing Data Validation
  • Labs
Module 3. Using Templates
  • Copying Worksheets
  • Hiding Columns and Rows
  • Unhiding Columns and Rows
  • Saving a Workbook as a Template
  • Using a Template
  • Editing a Template
  • Inserting a New Worksheet
  • Hiding/Unhiding a Worksheet
  • Deleting a Template
  • Finding Online Templates
  • Labs
Module 4. 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 5. Revising Charting Features
  • Formatting an Axis
  • Changing the Axis Scaling
  • Formatting the Data Series
  • Adding Data from Different Worksheets
  • Using a Secondary Axis
  • Changing Data Series Chart Types
  • Changing Source Data Range
  • Labs
Module 6. Working with Advanced Filters
  • Creating a Criteria Range
  • Using a Criteria Range
  • Showing All Records
  • Using an Advanced And Condition
  • Using an Advanced Or Condition
  • Copying Filtered Records
  • Using Database Functions
  • Finding Unique Records
  • Labs
Module 7. Using Conditional and Custom Formats
  • Applying Conditional Formats
  • Changing a Conditional Format
  • Adding a Conditional Format
  • Creating a Custom Conditional Format
  • Using Data Bars
  • Deleting a Conditional Format
  • Creating a Custom Number Format
  • Labs
Module 8. Using Worksheet Protection
  • Unlocking Cells in a Worksheet
  • Protecting a Worksheet
  • Unprotecting a Worksheet
  • Creating Allow-Editing Ranges
  • Deleting Allow-Editing Ranges
  • Protecting Workbook Windows
  • Unprotecting Workbook Windows
  • Assigning a Password
  • Opening a Password-protected File
  • Removing a Password
  • Labs

Who Should Attend This Microsoft Excel 2016 Training?

Highly recommended for individuals with the basic understanding of Microsoft Excel and wishes to be equipped with intermediate skill sets in the programme, such as generating reports and data management.

Pre-requisite

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

  w/o GST w GST
Course Fee $180 $192.60

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.