Top navigation bar Bottom navigation bar

Leisure courses

Access courses

Microsoft Excel: Managing & Analysing Lists & Tables (including Pivot Tables)

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 concept of spreadsheets.

Course content

This course is designed to provide you with a solid understanding of more advanced Microsoft Excel tools and features in order to increase your knowledge and productivity through using tables and pivot tables to organise, summarise and analyse your data effectively.

During the course you will study the following topics:

  • Creating and modifying tables and PivotTables
  • Adding and formatting styles
  • Sorting, filtering and grouping data
  • Formatting values
  • PivotTable calculations
  • Creating PivotCharts and PivotTable reports.

Assessment methods

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

Further study and career options

On completion of this course you could study another of the short computing courses at Bedford College to further develop your skills, such as Microsoft Excel: Intermediate, Microsoft Excel: Automating Your Spreadsheets with Forms & Macros, 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 Apply

Please call our Customer Contact team on 01234 291000 to book onto this course. Alternatively you can visit our Customer Contact team at our Cauldwell Street campus. View our opening hours.

LengthStart DateDay(s)Time(s)FeesLocationCourse Code
1 day 23/06/2016 Thu 9.30 am - 4.30 pm £170 Cauldwell Street F2150 Course in progress

Part-time course already started?

Our upcoming 2019-20 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 form...

» I'm interested in courses at Bedford College

» I'm interested in courses at Shuttleworth College


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.

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