Top navigation bar Bottom navigation bar

Leisure courses

Access courses

Microsoft Excel: Advanced

  • A

This course is ideal if you have existing knowledge of Microsoft Excel and want to build upon your skills.

Entry requirements

To begin this course you should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Course content

This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced Excel 2010 tools and concepts in order to increase their knowledge and productivity.

Topics covered will include:

  • Data Validation
  • Conditional Formula
  • Lookup Formulas
  • Advanced Tables
  • Advanced Charts
  • Using Graphics in Excel
  • Protecting Data
  • Subtotalling Data
  • What-If Analysis
  • PivotTables & PivotCharts
  • Macros

Assessment methods

There will be no assessments or exams for this course; at the end you will receive a Bedford College course completion certificate.

Further study and career options

On completion of this course you could study another of our Microsoft Excel courses to discover more advanced techniques, such as Microsoft Excel: Managing Data Using Pivot Tables, Microsoft Excel: Automating Your Spreadsheets with Forms & Macros, and Microsoft Excel: What If Analysis.

Additional information

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

Course information & how to book

This course runs on multiple occasions. Choose the date most appropriate for you.

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.

LengthStart DateDay(s)Time(s)FeesLocationCourse Code
1 day 12/02/2018 Mon £170 Cauldwell Street F2219S1 Pay & Enrol
1 day 11/05/2017 Thu 9.30 am - 4.30 pm £170 Cauldwell Street F2219S2 Course in progress
1 day 10/05/2018 Thu 9.30 am - 4.30 pm £170 Cauldwell Street F2219S2 Pay & Enrol

Additional Learning Support
If you have a specific learning difficulty or disability, are deaf or hearing impaired, 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