Top navigation bar Bottom navigation bar

Leisure courses

Access courses

Microsoft Excel: Automating Spreadsheets with Forms & Macros

This course is designed to build on your existing skills and knowledge of Microsoft Excel through introducing you to more advanced features.

Entry requirements

You should have a working knowledge and understanding of Microsoft Excel and the basic concepts of spreadsheets.

Course content

This course is designed to give you a solid understanding of more advanced Microsoft Excel tools and features in order to increase your knowledge and productivity by using forms and macros to capture, enter and edit your data quickly and efficiently.

During the course you will study the following topics:

  • Quick forms
  • Forms with form controls
  • Developer tab
  • Basic controls
  • Text box
  • Option button
  • Check box
  • Drop-down lists
  • Combo boxes
  • Global macros
  • Workbook macros.

Assessment methods

There will be no assessments of exams during this course; you will receive a Bedford College course completion certificate.

Further study and career options

On successful completion of this course you could go on to study another of the short computing courses delivered by Bedford College to develop your skills further, such as Microsoft Excel: Intermediate, Microsoft Excel: Managing Data Using Pivot Tables, and Microsoft Excel: What If Analysis.

Additional information

This course will be delivered using Microsoft Office 2010 and will also be suitable if you use Microsoft Office 2007. If you are using Microsoft Office 2003 or any other version, please contact us to discuss this further.

Course information & how to book

Select the 'Enrol' button to book on to this course online. Please note: after registering you will be taken to the payment page where you will need to pay for your course.

Start Date
24/05/2013 Course in progress

Part-time course already started?

Our upcoming 2017-18 Part-time Course Guide will be out in May.
You can request a copy via the form below...

Additional Learning Support
If you have a specific learning difficulty or disability, problems with English and Maths, are deaf or hearing impaired, or missing the essential skills needed to complete your course, our Additional Learning Support team are on hand to give you assistance whenever you need it.  Find out more.

Autism & Asperger’s Syndrome Support
At Bedford College, we are committed to developing the provision for students on the autistic spectrum, including Asperger’s Syndrome.  Find out more.

Accessibility
We have access arrangements in place to help students with disabilities or any other particular needs. Call us on 01234 291000 for more information.

Additional formats
Course information sheets are also available in large print and audio formats. Call us on
01234 291000 to order your copy.
YouTube Instagram LinkedIn Moodle Higher Education Moodle Have Your Say