HOME


Updated 29 February, 2012

Microsoft™ Office 2007 Excel Certification Microsoft Office Specialist


Course Details

This course is designed to equip learner with skills to use Microsoft Excel to an advanced level. The course is completed online, at your own time, at a location that suits you. You progress through the course materials and complete the online lessons and tests.

Students are provided with Flash-based instructional demonstrations, Instructional audio with graphics highlighting key points. Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.

 

Activities allow learners to apply course concepts in an interactive questioning environment. Exercises allow learners to practice in the actual application being studied. The course challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank, and a skill assessment generates a customised learning path based on the results of a pre-test. Bookmarking tracks the learner's progress in a course.




Topics Covered in this Course


Getting Started
  • What can Excel do for you?
  • Finding your place
  • Using the Ribbon
  • The formula and status bars
  • Navigating around your worksheet
  • Adding and renaming worksheets

Creating a Worksheet
  • Entering text data
  • Entering values
  • Entering formulas
  • Correcting errors
  • Using AutoComplete, AutoFill, and Formula AutoComplete
  • Using the SUM function and AutoSum
  • Editing cells

Formatting Data
  • Selecting cells
  • Formatting cell layout
  • Formatting cell size
  • Formatting cell data

Editing and Printing Worksheets
  • Worksheet Views
  • Formula and Editing Tools
  • Inserting, Deleting and Hiding
  • Page Layout and Printing

Managing Worksheets
  • Setting Panes
  • Naming Cells and Ranges
  • Finding Data in a Worksheet
  • Working with Multiple Workbooks
  • Adding Web Links
  • Sharing and Protecting Workbooks
  • Commenting

Formatting Data
  • Creating charts
  • Modifying and formatting charts
  • Adding shapes and text boxes
  • Smartart
  • Pictures and clip art



Who should complete this course?

  • People who wish to learn how to use Microsoft Excel 2007 and learn at their own pace.
  • Students, or those new to the workforce, who wish to learn how to use this software program.
  • Existing users who wish to get more out of Microsoft Excel 2007.


Entry Requirements / Prerequisites

  • You must have a basic working knowledge of Microsoft Windows and access to the internet to complete the course.


Assessment

  • Once you successfully pass the programme, you will receive a Certificate in Microsoft Excel from CMIT.


Technical Requirements

  • The following technical requirements apply: 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.


Accreditation

  • Following completion of the online assessment you will receive a Certificate in Microsoft Excel 2007 from College of Management and IT (CMIT).



 Student Feedback   (Please include your Email address)
FETAC ILM Adobe CIW MS Office Specialist ISO 9001