Course Code: MEXCIE

Type: Part Time

Entry Requirements

Excel Beginners would be useful, although if you have a knowledge of Excel (how to carry out fundamental tasks e.g.: adapt formulae, present data) this should be sufficient.

Who is the course for

The course covers editing, formatting & print options, organising worksheets, performing calculations, financial & logical functions, using Excel with the internet.

Course Content

This course will cover:

Creating and manipulating data:

• Insert data by using AutoFill
• Ensure data integrity
• Modify cell contents and formats
• Change and manage worksheet views.

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 formulae:

• Reference data in formulas
• Summarize data by using a formula
• Summarize data by using subtotals
• Conditionally summarize data using 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 on and securing documents

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

Study Methods

In-class delivery of theory and practical knowledge. Self study is required with course materials and data supplied.

How is the course assessed

The Microsoft Office Specialist (MOS) exam is an optional extra at extra cost; however you will need to practice prior to taking the exam.

You will receive a certificate for each individual course you complete.

To gain full MOS certification you must successfully complete all five courses (Access, Excel, Powerpoint, Project and Word).

Where next - Further Studies

Further Microsoft Office 2007 courses e.g. Word, Access, PowerPoint, Outlook and Project.

Where next - Job Opportunities

These IT skills can be used in any job

More Information

• Course Fee: £124. This is a Full cost commercial course all students pay fees, no concessions available.
• For more information, please contact our Information, Advice & Guidance team on 01895 853333 or email This e-mail address is being protected from spambots. You need JavaScript enabled to view it

How to Apply

You can enrol straight away by one of the methods below. You do not need to complete an application form.

• By telephone - call 01895 853333 to enrol using your Visa, MasterCard, Visa Debit, Maestro or Delta card.
• In person come along to the Uxbridge Campus. We are open Monday to Friday between 9am and 4pm. Please remember to bring your payment with you as you will need to pay your fees when you enrol.

Hayes Campus: Course Starting Thu 21 June 2012