Top navigation bar Bottom navigation bar

Computing & IT

Computing

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 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
Additional information

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

Course Information & How to Apply

Unfortunately this course has been postponed until further notice. Please register your interest here for our part-time courses starting from September 2021.

LengthStart DateDay(s)Time(s)FeesLocationCourse Code
1 day 20/04/2021 Tue 9.30 am - 4.30 pm £180 Cauldwell Street BBF2219S2

Is this course right for me? View our qualifications guide.
Find out about our fees & financial support.

Part-time course already started?

Our upcoming 2021-22 part-time courses will be out in May. Get alerted when they're released by selecting your campus of choice below and filling out the relevant form:

Bedford College Enquiry Form

Shuttleworth College Enquiry Form

 

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.
Bedford College