• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Excel 2007 – Microsoft Certified Application Specialist in a Box

View course dates

Course Duration: 3 Days

Course Code: RT0232

Course Description:

This certification course provides a complete training solution to fully prepare students to achieve MCAS Accreditation

Included are:

• 2-days Instructor Led Training using  MCAS Official Courseware
• MCAS Practice Exam Voucher
• MCAS Exam Voucher + FREE Retake
• MCAS A4 Pad
• MCAS Pen
• MCAS Mouse Mat
• Branded MCAS Carry Case

Prerequisites:

Delegates should have a good working knowledge of Microsoft Office Excel 2007 before taking this certification course.

This course includes the following modules:

Creating and Manipulating Data

• Insert data by using AutoFill
• Ensure data integrity
• Modify cell contents and formats
• Change Worksheet Views
• Manage worksheets

Formatting Data and Content

• Format worksheets
• Insert and modify rows and columns
• Format cells and cell content
• Format data as a table

Creating and Modifying Formulas

• Reference data in formulas
• Summarize data using a formula.
• Summarize data using subtotals.
• Conditionally summarize data by using a formula
• Look up data by using a formula.
• Use conditional logic in a formula.
• Format or modify text by using formulas.
• Display and print formulas

Presenting Data Visually

• Create and format charts
• Modify charts
• Apply conditional formatting
• Insert and modify illustrations
• Outline data
• Sort and filter data

Collaborating and Securing Data

• Manage changes to workbooks
• Protect and share workbooks
• Prepare workbooks for distribution
• Save workbooks
• Set print options for printing data, worksheets, and workbooks

To make an enquiry for this course to be run ONSITE at your location, click here or call Sales on +44 (0) 20 7620 0033.

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course