HOME


Updated 1 March, 2013

 

Microsoft™ Excel 2010 (MOS Certification) Microsoft Office Specialist


Course Details

Microsoft Excel 2010 is a financial tool for performing calculations and other tasks automatically. It lets you accomplish a variety of business or personal tasks in a fraction of the time it would take using pen and paper. This course shows you how to work efficiently with Excel, and prepares you for the Microsoft Office Specialist 77-882 exam and Microsoft Office Specialist (MOS) certification.

 

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. Full-page images allow learners to experience an application as if it were open on their computer. 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


Becoming Familiar with Excel
  • Use the Ribbon and toolbars
  • Create new workbooks
  • Open existing workbooks
  • Move around in workbooks
  • Save workbooks
  • Recover workbook backups

Basic Tasks
  • Selecting Cells, Rows, and Columns
  • Entering Labels and Values
  • Editing and Clearing Cell Contents
  • Copying, Moving, and Pasting Content
  • Inserting, Deleting, and Replacing
  • Using AutoCorrect and Actions

Formulas and Functions
  • Working with Formulas
  • Editing Formulas and Using References
  • Naming Cell Ranges
  • Performing Calculations Correcting Errors
  • Audits and Circular References
  • Creating Functions
  • Array Formulas and Nested Functions

Workbook and Worksheets
  • Working with Excel Worksheets
  • Moving, Copying, and Hiding Worksheets
  • Selecting and Hiding Columns and Rows
  • Inserting and Deleting Columns and Rows
  • Adjusting Column Width and Row Height
  • Freezing and Splitting Worksheets
  • Creating Views and Saving Layouts

Viewing and Printing
  • Setting Up Pages for Printing
  • Adjusting Page Margins
  • Adding Headers and Footers
  • Inserting Page Breaks
  • Customizing the Print Area
  • Previewing and Printing

Working with Graphics
  • Using Clip Art and Media Clips
  • Inserting Pictures and Screenshots
  • Applying Styles, Shapes, and Borders
  • Correcting and Recoloring Pictures
  • Adding Transparency
  • Creating WordArt Text
  • Building SmartArt Graphics
  • Drawing and Modifying Shapes



Who should complete this course?

  • People who wish to learn how to use Microsoft Excel 2010 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 2010.


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 2010 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 2010 from College of Management and IT (CMIT). You may optionally complete the Microsoft Office Excel 2010 Specialist 77-882 exam. Contact the college for details.



   Please include your CMIT Student Number

Read Reviews (0)
(
/5
) based on
0
reviews.

Powered by LouderVoice Reviews and LouderYou Ireland

FETAC ILM Adobe CIW MS Office Specialist ISO 9001