Microsoft Office Specialist (MOS) certification is an industry standard, and is the only comprehensive, performance-based certification programme approved by Microsoft to validate desktop computer skills using Microsoft Office applications.

This is a level 2 course that teaches competency in basic spreadsheet concepts; workbook and file management; using formulas and functions; editing and formatting tools; working with graphics and charts; online collaboration; and working on the Web.

The lessons are based on tasks that you might encounter in the everyday world of work, and exercises based on realistic business scenarios, allowing you to see the relevance of training beyond just the classroom. In other words, you will learn far more than just the features of this software.

This is a professional course, leading to a globally recognised qualification that demonstrates the successful candidate has knowledge and competence in using Microsoft Excel 2003.

Please note that the cost of this course covers 5 days of tuition only, designed to prepare students for their Microsoft Office Specialist exam. These exams will soon be available at Castle College, and we will update our course details to include the additional cost.

Overview

• Learning Excel Worksheet Fundamentals
  • Create a Workbook
  • Explore the Excel window
  • Select cells & cell ranges
  • Enter text, numbers & dates
  • Edit cell contents
  • Move between worksheets
  • Rename worksheets
  • Name, save, preview and print a workbook
• Editing and Formatting Worksheets
  • Format Numbers
  • Adjust Row & Column sizes
  • Align Cell Contents
  • Find & Replace Cell Contents
  • Insert & Delete Cells, Rows & Columns
  • Cut, Copy, Paste and Clear Cells
  • Use additional paste techniques
• Formatting Cells
  • Format Text
  • Format Numbers as Currency
  • Use Format Painter
  • Add Borders & Shading to Cells
  • Use AutoFormat
  • Merge Cells
  • Create & Apply Styles
• Changing Print Options
  • Add a Header & Footer
  • Change Margins
  • Change Orientation & Scale
  • Add & Delete Page Breaks
  • Set & Clear a Print Area
  • Set other Print Options
• Organising Worksheets and Window Display
  • Magnify & Shrink a Worksheet on Screen
  • Hide Rows & Columns
  • Freeze Rows & Columns
  • Manage Worksheets
  • Sort & Filter Data
• Working with Charts
  • Use the Chart Wizard
  • Move, Resize & Modify Charts
  • Move & Format Chart Elements
  • Change Chart Type & Format Axes
  • Organize & Update Data
  • Add Gridlines & Arrows
  • Preview & Print Charts

Overview cont.

• Performing Basic Calculations
  • Build & Copy Formulas
  • Work with Cell References
  • Edit Formulas
  • Explore Functions
  • Create a Three-Dimensional Formula
• Using Basic Financial and Logical Functions
  • Use the PMT Function to Forecast Loan Payments
  • Calculate Cumulative Interest
  • Compute Investment Value
  • Use the IF Function
• Excel and the Web
  • Insert & Edit Hyperlinks
  • Save Worksheets & Workbooks as Web Pages
  • Send Workbooks via E-mail
  • Manage Comments

Who is it aimed at?

This course is primarily aimed at people employed by businesses employing 1-250 staff, who need to create, manage and present spreadsheet data and graphs to a professional standard. It is also suitable for students, individuals and aspiring professionals who are:

• Looking to develop their skills and enhance their career progression
• Looking to formalise their current knowledge with an industry benchmark

Focused on simple practical techniques this course will help you develop your expertise with Microsoft Excel 2003, focus and refine your skills, and prepare you for MOS certification. It allows you access to AxisCommunity for ongoing help and advice, and prepares you for progression to higher level courses, such as MOS at the Expert level.

Entry requirements

This course is suitable for beginners, and candidates who are familiar with Windows and reasonably competent in using Microsoft Excel to create and format basic spreadsheets, and use simple formulas.

As this course is aimed towards an assessment/examination, it is expected that all students will enter for the qualification.

Delivery method

The course is a 5 day (or 10 evening) fully trainer led course. To help reduce the effect on your business of losing a member of staff for 5 days, this course runs 1 day a week over 5 weeks. Delegates then have the time needed to absorb and implement the information gained during these intensive training days.

Downloadable course overview (pdf)

Microsoft Office Specialist info (823kb)