• Technical IT

    Solutions delivered throughout the UK
  • Business Applications

    Solutions delivered throughout the UK
  • Professional Best Practice

    Solutions delivered throughout the UK
  • Professional Development

    Solutions delivered throughout the UK

Microsoft Excel Specialist 2007

  • Price £410.00
  • Duration 2 day(s)
All major credit cards accepted

Description

This certification course provides a complete training solution to fully prepare students to achieve Microsoft Office Specialist (MOS) Microsoft Office Excel 2007 accreditation. It concentrates on getting delegates from knowledgeable to ‘exam ready’ in a 2 day course. The course is aimed at delegates who already have the raw skills to take the exam, but wish to hone those skills and practice with assistance from an experienced MOS qualified instructor, prior to taking the exam.

Please note this is the Specialist level: one of two levels of exam available for Microsoft Excel 2007 (Specialist and Expert). MOS exams are also available for Word, PowerPoint, Outlook and Access 2007.

This is a replacement course for the Excel 2007 MCAS in a Box 2 day course (DEXMCAS)

Included are

•2-days Instructor Led Training using MOS Official Courseware
•MOS Practice Exam Voucher
•MOS Exam Voucher
•Free Exam Re-take (where required)

Prerequisites

This course has strict prerequisites – delegates should have already attended the relevant Levels 1, 2 and 3 courses or have equivalent knowledge. This course is NOT a fast track course for learning the exam material but a course for turning knowledge in to exam readiness.

Skills

See Course Content

Course Content

During the 2 day course you will cover the following topics to prepare you for exam 77-602: Using Microsoft Office Excel 2007. During the course, you will have the opportunity to test your knowledge and complete a full practice exam before taking the final exam at the end of day two.

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
•Summarise data using a formula
•Summarise data using subtotals
•Conditionally summarise 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
 

Please note : these certifications used to be called Microsoft Certified Application Specialist (MCAS). From June 2010 they are now known as Microsoft Office Specialist 2007 (MOS 2007).

Make Enquiry

Course Enquiry
  •  
  •  

Book Now

Course Enquiry
  •  
  •  

Find your local training centre