Microsoft Certified Application Specialist: Excel 2007
Course Schedule & Online Registration
If you are an individual, please click here.
If you are representing a company, please click here
Target Audience
Individuals who are interested to upgrade themselves with the latest technologies from Microsoft.
Course Duration
21 hours / 3 days exclude examination hours
Assessment
Participants are required to sit for 1 Microsoft Certified Application Specialist (MCAS) examination.
*Any amendments (subject to availability) to a confirmed exam booking, an administrative charge of $21.40 will be imposed.
Course Outline
· Creating and Manipulating Data
o Insert data by using AutoFill
o Ensure data integrity
o Modify cell contents and formats
o Change Worksheet Views
o Manage worksheets
· Formatting Data and Content
o Format worksheets
o Insert and modify rows and columns
o Format cells and cell content
o Format data as a table
· Creating and Modifying Formulas
o Reference data in formulas
o Summarize data using a formula.
o Summarize data using subtotals.
o Conditionally summarize data by using a formula
o Look up data by using a formula.
o Use conditional logic in a formula.
o Format or modify text by using formulas.
o Display and print formulas.
· Presenting Data Visually
o Create and format charts
o Modify charts
o Apply conditional formatting
o Insert and modify illustrations
o Outline data
o Sort and filter data
· Collaborating and Securing Data
o Manage changes to workbooks
o Protect and share workbooks
o Prepare workbooks for distribution
o Save workbooks
o Set print options for printing data, worksheets, and workbooks
o Filter data by using AutoFilter
o Filter and sort data by using conditional formatting
o Filter and sort data by using cell attributes
Pre-requisites
Trainees must be a proficient user of any previous version of Microsoft Excel or Microsoft Office Specialist Certificate – Excel 2003 (Core)
Course Location
NTUC Trade Union House
73 Bras Basah Road
#02-01
Singapore 189556
Methodology
Instructor-led class
Certification
- Certificate of Completion from NTUC LearningHub
- Microsoft Certified Application Specialist: Excel 2007 (upon passing the Microsoft exam)
Price
Without GST
Non Union Members:
Course Fee: $500.00
Exam Fee: $140.00
Union Members:
Course Fee: $493.00 (exam fees inclusive)
With GST
Non Union Members:
Course Fee: $535.00
Exam Fee: $149.80
Union Members:
Course Fee: $527.51 (exam fees inclusive)
Our Partners
