Small logo
Hamburger sub menu
More
Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           
Excel Training Courses: All Versions & Skill Levels

EXCEL TRAINING COURSES

Microsoft Excel Training

Training courses for Excel 2007 to 2016 delivered via e-learning, in 11 UK locations or at your offices UK-wide
See Our Latest Reviews on TrustPilot:
How Would You Like to Learn Microsoft Excel?
Classroom training Classroom training

Classroom training is proven to give the best learning experience and knowledge retention. You have the benefit of a relaxed but professional learning environment, an experienced trainer and the opportunity to ask questions, so you are 100% sure you understand all the course content.

Click for details of:
    Course outlines and links
    More about classroom training

E-learning NEW! E-learning

If your budget, and/or time available, are limited, you can now choose the e-learning route: at lower cost, and with the flexibility to study in your own time, at your own pace. The course content is exactly the same as we cover in the classroom, so you are still getting tried and tested Activia courses.

Click for details of:
    Course outlines and links
    More about e-learning

Move to next Microsoft Excel section
Quick Links to Information

PRICES for training

BOOK a public class

MICROSOFT SOFTWARE page

REQUEST MORE INFORMATION

More on This Page
COURSE OUTLINES & LINKS FOR
MICROSOFT EXCEL TRAINING
Browse the outlines and click for more details on each course

Excel Introduction

Excel Introduction

COURSE OUTLINE
[Duration: one day]

  • Getting Started with Microsoft Excel
  • The Excel Interface
  • Microsoft Excel Basics
  • Editing your Workbook
  • Printing and Viewing your Workbook
  • Working with Charts in Excel

Click for FULL COURSE DETAILS

Excel Intermediate

Excel Intermediate

COURSE OUTLINE
[Duration: one day]

  • Advanced File Tasks
  • Working with Functions and Formulas
  • Managing Tables in Microsoft Excel
  • Data Tools in Excel
  • Doing More with Charts in Excel
  • Sparklines

Click for FULL COURSE DETAILS

Excel Advanced

Excel Advanced

COURSE OUTLINE
[Duration: one day]

  • Grouping & Outlining and Subtotals
  • What-If Analysis
  • PivotTables
  • Charting Pivoted Data
  • Advanced Excel Tasks
  • Creating HLOOKUP and VLOOKUP Functions
  • Introduction to Macros in Excel

Click for FULL COURSE DETAILS

Excel Professional

Excel Professional

COURSE OUTLINE
[Duration: one day]

  • Advanced Conditional Formatting
  • Using Form Controls and Templates
  • Advanced Lookup Functions
  • Advanced Functions in Excel
  • Advanced Pivot Table Tools
  • Introduction to User Defined Functions Using VBA

Click for FULL COURSE DETAILS

Excel VBA Introduction

Excel VBA Introduction

COURSE OUTLINE
[Duration: one day]

  • Recording and Running Macros in Excel
  • Introduction to the Excel VBA Editor
  • Creating Procedures and Functions
  • Working with the Excel Object Model
  • Controlling Program Flow

Click for FULL COURSE DETAILS

Excel VBA Advanced

Excel VBA Advanced

COURSE OUTLINE
[Duration: one day]

  • Advanced Procedures
  • Advanced Variables
  • Interacting with Office Applications
  • Debugging and Error Traps
  • Creating Custom User Forms
  • Workbook and Worksheet Events

Click for FULL COURSE DETAILS

Excel Dashboards

Excel Dashboards

COURSE OUTLINE
[Duration: one day]

  • Introduction to Dashboards
  • Inserting Graphics for a Dashboard
  • Specialist Functions and Formulas
  • Dashboard Navigation
  • Preparing your Workbook's Layout and Structure
  • Using Excel Objects for Specialist Dashboard Views
  • Using Macros and VBA with Dashboards

Click for FULL COURSE DETAILS

Excel Business Intelligence (BI)

Excel Business Intelligence (BI)

COURSE OUTLINE
[Duration: one day]

  • Importing and Linking Data
  • Data Manipulation with Pivot Tables
  • Advanced Reporting Functions
  • Automating Reports with Controls
  • Advanced Charting Features

Click for FULL COURSE DETAILS
Move to next Microsoft Excel section
CLASSROOM TRAINING FOR
MICROSOFT EXCEL
Do you want the best? Here's how to get it!
Classroom training for MICROSOFT EXCEL
Classroom training provides the best learning experience and knowledge retention, and is the preferred choice if you want to really get to grips with the subject.
Our class sizes are always small, allowing lots of time for questions and discussion, so you come away with a full grasp of the content, ready to use it right away.
Options for Classroom Training
Scheduled Public Classes

Best for: 1 - 4 delegates

With 11 centres across the UK, we always have a full schedule of great courses at super prices.
And we don't cancel classes – even if you are the only delegate booked on the course!

Price Guide
  • Prices for public classes start at £199
  • Early Bird discounts can reduce the price to £159
  • For multiple delegates, prices can be as low as £129

If you don't see a course at the location, or on the date, you want, it is often possible to take advantage of our unique "Schedule Your Own" feature which is available from £199.

Free E-Learning Revision
Every attendee on a public class also gets access to 12 months free e-learning where you can review and revise the course content.

Book Online
It couldn't be easier with our full listings of classes and dates: just click here and reserve your place in two minutes.

Training at Your Offices

Best for: 3 or more delegates

A great option that's cost effective and easy to organise: just set up the training room and we come to you to deliver the content you want on the day you choose.

Price Guide
Prices for training at your offices starts at £449

Private Training at Our Centres

Best for: 3 or more delegates

If you want training away from your offices (and possible distractions), we can arrange a day at one of our centres with only your staff in attendance.

Price Guide
Prices for private Microsoft Excel training at our centres varies, but generally starts at £499

Call us on 0333 6000 111 or request a callback so we can discuss your needs.

Move to next Microsoft Excel section
E-LEARNING MADE EASY FOR
MICROSOFT EXCEL
Great options for fast, flexible, cost-effective learning
E-learning options for MICROSOFT EXCEL
Standard e-learning pack
PACK A1 - Standard e-learning pack
Videos with transcripts and tests to earn your diploma
Enhanced e-learning with downloads
PACK A2 - Enhanced e-learning with downloads
Standard pack PLUS downloadable workbook & exercises
E-Learning Packs

Buy now and be learning in a few minutes!

Excel Introduction   [Click for course outline]
Excel Introduction
Course Outline


MODULE 1: Getting Started with Microsoft Excel
Starting Excel and some of its basic navigation and help controls.

This module contains:

  • Starting Out
  • About Workbooks
  • Exploring your Workbook
  • Getting Help with Excel

MODULE 2: The Excel Interface
A look at the Ribbon interface and the different tabs and options the Ribbon offers.

This module contains:

  • The Quick Access Toolbar and File Menu
  • The Home Tab
  • The Insert Tab
  • The Page Layout Tab
  • The Formulas Tab
  • The Data Tab
  • The Review Tab

MODULE 3: Microsoft Excel Basics
Working with a Workbook, its cells, columns and rows.

This module contains:

  • Working with Excel
  • Moving your Data
  • Basic Excel Features
  • Smart Tags and Options Buttons
  • Editing Tools

MODULE 4: Editing your Workbook
Understanding formatting features and enhancing a workbook's overall appearance and using Conditional Formatting.

This module contains:

  • Cell Formatting
  • Conditional Formatting
  • Enhancing a Worksheet’s Appearance

MODULE 5: Printing and Viewing your Workbook
Exploring Excel's printing and viewing options enhancing your ability to print and work with your data effectively.

This module contains:

  • Using the View Tab
  • Managing a Single Window
  • Managing Multiple Windows
  • Printing your Workbook
  • Print Page Layout options

MODULE 6: Working with Charts in Excel
Introducing charts within Excel and explain how to create basic charts to help convey your data with.

This module contains:

  • Using Recommended and Standard Charts
  • Chart Elements
  • Chart Tools - Design & Format

E-learning revision
PACK A1 - £19
Click to BUY
E-learning revision
PACK A2 - £29
Click to BUY
Excel Intermediate   [Click for course outline]
Excel Intermediate
Course Outline


MODULE 1: Advanced File Tasks
A look at some important administrative features which are useful for managing and controlling Excel files.

This module contains:

  • Saving and File Management
  • Converting and Encrypting Files
  • File Properties and Digital Signatures
  • File Accessibility and Compatibility

MODULE 2: Working with Functions and Formulas
Some key formulas and functions essential to Excel users along with features to help manage formulas, functions and ranges.

This module contains:

  • Formulas with Absolute References
  • Autosum Functions (SUM & AVERAGE)
  • IF and Nested Functions
  • Working with Named Ranges
  • Array Functions (SUMIF & AVERAGEIF)
  • Formula Auditing
  • Text Functions

MODULE 3: Managing Tables in Microsoft Excel
Managing spreadsheet data in table format, an excellent feature to administrate large sets of data.

This module contains:

  • Creating Excel Tables
  • Working with Records and Filters
  • Advanced Filters

MODULE 4: Data Tools in Excel
Features to help with managing spreadsheet data making it a less daunting and repetitive task to manage the data.

This module contains:

  • Text to Columns
  • Flash Fill
  • Remove Duplicates
  • Data Validation
  • Consolidate

MODULE 5: Doing More with Charts in Excel
Developing your ability to effectively create charts and format them specific to the reader

This module contains:

  • Trendlines
  • Error Bars
  • Working with Axis Options
  • Advanced Chart Formatting

MODULE 6: Sparklines
Use Sparklines to help analyse data by creating small customisable charts within cells. Edit and format the Sparklines and data points to help your data stand out

This module contains:

  • Creating Sparklines
  • Editing Sparklines

E-learning revision
PACK A1 - £19
Click to BUY
E-learning revision
PACK A2 - £29
Click to BUY
Excel Advanced   [Click for course outline]
Excel Advanced
Course Outline


MODULE 1: Grouping & Outlining and Subtotals
Useful Excel functions to summarise a spreadsheet making the data easier to identify and explain.

This module contains:

  • Outlining and Grouping Data
  • Using the Subtotals Tool

MODULE 2: What-If Analysis
Tools designed to help with forecasting and finding solutions to complicated problems involving your spreadsheet's data and formulas.

This module contains:

  • Exploring Scenarios
  • Goal Seek and Data Tables
  • Using Solver

MODULE 3: PivotTables
Creating Pivot Tables in order to display and summarise large quantities of data effectively.

This module contains:

  • Getting Started with PivotTables
  • Displaying Data in a PivotTable
  • Formatting a PivotTable
  • Using the Classic PivotTable Layout
  • Slicers

MODULE 4: Charting Pivoted Data
Introducing Pivot Charts, adding specialist pivot charts to the already excellent Pivot Table feature.

This module contains:

  • Getting Started with PivotCharts
  • Using the PivotChart Tools Tabs
  • Formatting a PivotChart

MODULE 5: Advanced Excel Tasks
Here we will look at sharing Excel files along with adding hyperlinks and Custom AutoFill Lists.

This module contains:

  • Excel and Hyperlinks
  • Using Custom AutoFill Lists
  • Sharing Workbooks

MODULE 6: Creating HLOOKUP and VLOOKUP Functions
Exploring the different Lookup functions, ideal add further functionality to a spreadsheet to reference particular data quickly and effectively.

This module contains:

  • Using the VLOOKUP Function
  • Using the LOOKUP Function

MODULE 7: Introduction to Macros in Excel
Explore how to create your own Macros and introducing Visual Basic for Applications, the application Macros are created in.

This module contains:

  • Recording and Playing Macros
  • Copying and Deleting Macros
  • Visual Basic and Macros

E-learning revision
PACK A1 - £19
Click to BUY
E-learning revision
PACK A2 - £29
Click to BUY
Excel Professional   [Click for course outline]
Excel Professional
Course Outline


MODULE 1: Advanced Conditional Formatting
Looking at the more advanced Conditional Formatting features and how to manage them effectively.

This module contains:

  • Editing Standard Formatting Rules
  • Using Formulas in Conditional Formatting

MODULE 2: Using Form Controls and Templates
Introducing Form controls and using them to manage user interaction to help ensure they enter/search for information both accurately and effectively.

This module contains:

  • Using Form Controls
  • Creating Templates

MODULE 3: Advanced Lookup Functions
An in-depth look into Excel's specialist lookup functions and the concept of arrays.

This module contains:

  • Using the Index Function
  • Using the Match Function
  • Using Index and Match Together
  • Using Index and Match with Array Formula
  • Using the Indirect Function

MODULE 4: Advanced Functions in Excel
Effectively using Error, Logical and Rounding functions along with array formulas.

This module contains:

  • Using Error Functions
  • Using Logical Functions
  • Using Array Formulas
  • Using Rounding Functions

MODULE 5: Advanced Pivot Table Tools
How to import Pivot Table data from external source along with adding custom fields and formulas.

This module contains:

  • Importing Pivot Table Data
  • Calculated Fields in Pivot Tables
  • Showing Pivot Data as a Percentage
  • Creating Custom Pivot Tables Styles

MODULE 6: Introduction to User Defined Functions Using VBA
Using VBA to create specialist procedure and to define your own Excel functions.

This module contains:

  • Creating a User Defined Function
  • Creating an Interactive Procedure
  • Create and Share a Function Add-in

E-learning revision
PACK A1 - £19
Click to BUY
E-learning revision
PACK A2 - £29
Click to BUY

Call us on 0333 6000 111 or request a callback so we can discuss your needs.

NOTES:
Licenses for e-learning allow up to 40 sessions on one PC in any 12-month period.
But once purchased and accessed, no refund can be given.
Move to next Microsoft Excel section
DELEGATE FEEDBACK
FOR OUR MICROSOFT EXCEL COURSES
AVERAGE REVIEW: 4.5 out of 5  BASED ON 1,184 REVIEWS
Malcolm Duncan, Course: Excel Intermediate Nov 17 2016
Course rating of 4 stars "It was well presented and had a good atmosphere the tutor was approachable and happy to answer questions and go through things "

 
Sinclair McCutcheon, Course: Excel Advanced Nov 16 2016
Course rating of 5 stars "Great to the point course with excellent training staff and facilities"

 
Sophie Whitaker , Course: Excel Business Intelligence (BI) Nov 15 2016
Course rating of 4 stars "Great trainer and small class size were excellent"

 
sue Johnson, Course: Excel Introduction Nov 14 2016
Course rating of 4 stars "Trainer was very good and very patient with us older people."

 
Gareth Kennedy , Course: Excel Business Intelligence (BI) Nov 11 2016
Course rating of 4 stars "Very good facilities "

 
Sandra Cullen, Course: Excel Introduction Nov 10 2016
Course rating of 5 stars "very good trainer."

 
Kate Rimmer, Course: Excel Introduction Nov 10 2016
Course rating of 4 stars "Gareth was a great teacher and very patient"

 
Lisa Rankin, Course: Excel Introduction Nov 10 2016
Course rating of 5 stars "Excellent course"

 
Louise White, Course: Excel Introduction Nov 10 2016
Course rating of 5 stars "Gareth the trainer was excellent, and we will be using you again in the future."

 
Maciej Michalak, Course: Excel Advanced Nov 9 2016
Course rating of 4 stars "Great training and very useful, really liked it."

 
Janice Harris, Course: Excel Introduction Nov 9 2016
Course rating of 4 stars "very helpful"

 
Jackie Phillips, Course: Excel Introduction Nov 9 2016
Course rating of 4 stars "I would recommend this course"

 
Nicki Baker, Course: Excel Introduction Nov 9 2016
Course rating of 5 stars "Tracy was an awesome tutor - would love to have her again on the next course"

 
Tiffany Souresrafil, Course: Excel Advanced Nov 9 2016
Course rating of 5 stars "Clare was great!!"

 
Peter Gombala, Course: Excel Intermediate Nov 8 2016
Course rating of 4 stars "The course was fantastic gave me more details on some topics I wasn't completely aware of. The tutor was very nice and very knowledgeable, interacted with all attendees in a very professional manner. Topics were covered in very nice way. It was very productive and I learnt a lot which is gonna help me in my future. Thank you"

 
Move to next Microsoft Excel section
FREE TOOLS & RESOURCES
FOR MICROSOFT EXCEL
Resources to make your training easier to organise
FREE Microsoft Excel resources
General resources: click to view

FREE Skills Check
See where your training needs lie: click to view

FREE Bespoke Course Creator
Build your own bespoke course: click to view

Move to next Microsoft Excel section
YOU MAY ALSO LIKE ...
SUPPLEMENTARY INFORMATION
More content that may be of interest to you
Version history of Excel
Changes introduced in the different versions of Microsoft Excel: read more

Excel 2003 new features
What was new with Excel 2003: read more

Excel 2007 new features
A look at the major upgrade brought about with Excel 2007: read more

Excel 2010 new features
Excel 2010: building on the new interface from 2007: read more

Excel 2013 new features
Excel 2013: improvements in usability and collaboration: read more

Move to next Microsoft Excel section
GENERAL INFORMATION
ABOUT MICROSOFT EXCEL TRAINING
What we do, and how we work, to make sure you get the most from the courses you attend
Blended learning FREE E-learning Revision

With our latest Microsoft Excel courses, you get free e-learning revision for 12 months after your class so you can reinforce the knowledge you have gained.
Use the right hand menu on this page to click on the course you want for more information.
Access is simple: go to www.activia.co.uk/login/ and log in using your email address. This will give you free access to our e-learning revision modules.
Note: These have been developed and written exclusively by Activia to maximise effectiveness, by matching the e-learning exactly to what you cover in class. We hope you have fun, on the day of the course and with honing your knowledge afterwards!

Larger Class Sizes for Microsoft Excel

On our Public courses, you will always benefit from our small maximum class sizes of 8 delegates. In fact, the actual class size is often less.

However, if you want training for larger groups at your offices, we can deliver exactly the same content (though with a little less interactivity) for classes of up to 18 delegates, provided they have their own PCs or laptops. You will still have the exercises to download, and the same access to free e-learning revision, after the course.

These "large class" courses are a great choice if you need to get a lot of people trained in a short space of time, and the cost per delegate allows you to get more people upskilled within a limited budget.

[Note: Bespoke options are not available for these courses.]

If you would like to find out more, please get in touch to discuss.

For many people, Microsoft Excel is the technology upon which they rely on a daily basis in order to access, process, analyse, share, and display the information with which they work. It's the most popular spreadsheet application out there, and it's used in most organisations around the world.

Due to its popularity and frequent use in practically every industry, properly organised Excel training courses can play an enormous part in improving performance in both productivity and quality of work.

At Activia, whether you want to learn at a basic level or you need advanced Excel training, we can cover what you need. What's more, our professional and VBA level courses take you as far as you would ever expect to go.

Are you taking advantage of what Excel can offer?

About Microsoft Excel

Excel is a spreadsheet application that can also be described as a two-dimensional database (in other words it’s not relational like Access). On a basic level it can be used to store and present data; but more advanced users will be able to take advantage of its formulae function, allowing them to manipulate data according to their requirements. Information entered in Excel can also be demonstrated graphically in a variety of graph formats.

Our Approach

Interaction is vital if delegates are to achieve their training aims – which is why we make it our main focus. Attendees can also take home a copy of their course materials for future reference.

More about training with Activia

With Activia, you can check your skill level (click here to view our Tools and Resources) which ensures you book on the correct course.   This facility is also invaluable when putting together training programmes or bespoke courses for numbers of delegates.

You can also build your own Microsoft Excel course (click here to view our Tools and Resources) to suit your own or your company project requirements, incorporating the modules which cover the subjects you want to learn.



GET IN TOUCH

Call us on:
0333 6000 111

   You can Email us direct (You'll usually get a response within 2-3 working hours)
   Or fill out the details below and we'll be in touch very soon:
SEND MESSAGE

MICROSOFT EXCEL TRAINING

We can enhance your skills with Microsoft Excel spreadsheet training at any of our twelve training centres UK wide, or we can come to your offices: if you have groups of three or more staff who need training, this is a very convenient, flexible and cost effective option. Moreover, most of our excel courses are 1 day, which keeps "out of office" periods for attendees to a minimum.

We have been delivering Microsoft Excel training all over the UK since 1995 and have continually developed our philosophy of high quality, flexible and results-driven provision of courses for training in Excel to ensure constantly improving standards of quality.   So you can be confident that we have the expertise, and the experience, to give you a great return on your investment in Courses for Training in Excel from Activia.

Why not contact us today to see how we can help with providing your courses for Microsoft Excel ?


Stay in touch

Stay In Touch!

Google+
LinkedIn
Twitter
FaceBook
YouTube

Contact Details

Activia Training

Locations Address: Head Office, Regus House,
268 Bath Road
Slough, Berkshire SL1 4DX

Phone Sales:           0333 6000 111

Service:       0333 6000 555

Accounts:   0333 6000 777



Back to top
Quick Links to Information
More on This Page
HOME
Resources
About Us
Free Tools
Courses
Locations
Contact Us
Assertiveness
Time Management
Communication Skills
Likeability
Microsoft Access
Microsoft Excel
Microsoft Office (incl. 365)
Microsoft Outlook
Microsoft Powerpoint
Microsoft Project
Microsoft Publisher
Microsoft Visio
Microsoft Word
Crystal Reports
Windows Desktop Infrastructure
Office 365
Windows Server
SQL Server
Exchange Server
Sharepoint
Management Skills
Performance Management
Supervision & Teams
HR and Coaching
Accounts and Finance
Project Management Essentials
PRINCE2® Project Management
HR and Recruitment
Training & Coaching
Sales
Presentation Skills
Sales Management
Negotiation Skills
Business Writing Skills
Minute Taking Made Easy
Professional Report Writing
Professional Telephone Skills
Touch Typing
Assertiveness
Time Management
Communication Skills
Customer Service
Receptionist Skills
Kings Cross (WC1)
London Victoria (SW1)
Tower Bridge (E1)
Bristol (BS1)
Milton Keynes (MK9)
Reading (RG1)
Reading (RG2)
Slough (SL1)
Birmingham (B1)
Nottingham (NG1)
Manchester (M1)
Leeds (LS1)