Course Information Sheet - MS Excel (Intermediate)

Duration: 10 weeks

Course outline

What is the course about?

Familiarise with features of MS Word 2007 through simple, step-by-step instructions, this course allows you to be more productive at work and at home.

Are there specific requirements for joining?

This course is suitable for learners who have some prior knowledge of MS Office software.

How will I learn?

You will be in a group of a maximum 10 learners and you will be guided through your course by one of our tutors. You will be given handouts to help you remember and you will be given lots of time to practice what you are learning. You will learn as an individual but also as a part of the group.

What topics will we cover and what you are able to do:

  • Getting Started
    • Spreadsheet terminology
    • Exploring the Excel window
    • Getting help
    • Opening and navigating workbooks
    • Closing workbooks
  • Entering and Editing data
    • Creating workbooks
    • Entering and editing labels and values
    • Entering and editing formulas
    • Saving and updating workbooks
  • Modifying a Worksheet
    • Moving and copying data
    • Moving and copying formulas
    • Using absolute references
    • Inserting and deleting ranges
  • Using Functions
    • Entering functions
    • Using AutoSum
    • Using AVERAGE, MIN, and MAX
  • Formatting Worksheets
    • Formatting text
    • Formatting rows and columns
    • Number formatting
    • Using Format Painter and AutoFormat
  • Printing
    • Preparing to print
    • Page Setup options
    • Printing worksheets
  • Creating Charts
    • Chart basics
    • Modifying charts
    • Printing charts

How will I be taught, and will there be any work outside the class?

Each student has their own computer.Presentations will be made using computers, whiteboard, overhead screen and printed notes.Step by step instruction, with demonstrations where appropriate, will help you grasp the concepts.

What feedback will I get?

You will receive regular feedback from your tutor throughout the course, as and when appropriate. At the end of the course you and your tutor are asked to assess the progress you have made.

How will I be able to give my views on the course?

Please complete the evaluation form at the end of your course. These are monitored and help us to continually improve our courses.

How do I find out if I can get some support for my learning?

Watford Women's Centre Plus offers support sessions: Computer Club & Guided Learning during the week, where you get 1-2-1 support from experienced volunteers.These sessions will need to be pre booked with reception

When I've finished, what course can I do next?

Information Advice and Guidance will be given by a qualified tutor or staff member at the end of the course; to give you more information about other learning opportunities and activities available at the centre or at other local providers.

For further information please contact Watford Women's Centre Plus (Dirin) on 01923 816229 or email This email address is being protected from spambots. You need JavaScript enabled to view it.