Activia for Microsoft Excel Training
speedy course quote from Activia Training
Bookings and Enquiries:                0845 230 6150
Customer Service:                           0845 230 6159
We're here to help!      Click for a  FREE CALLBACK
Access your Dashboard:  Click to  log in

CLICK to view our courses
CLICK to view our locations
CLICK to view prices and dates
CLICK for information, tools, etc
CLICK for contact details
    Groups of delegates?   Save hundreds of pounds when we deliver training  at your offices

Excel Training Courses

Training courses for Excel 2003 to 2013

Excel training at our centres or your offices UK-wide
Excel Training Courses from Activia

About Microsoft Excel training

FREE eLearning revision

With our latest Microsoft Excel courses, you get free eLearning revision for 14 days 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 eLearning revision modules.
Note: These have been developed and written exclusively by Activia to maximise effectiveness, by matching the eLearning exactly to what you cover in class.   We hope you have fun, on the day of the course and with honing your knowledge afterwards!

For many people, Microsoft Excel is the technology upon which they rely on a daily basis, covering a multitude of workplace applications.
Are you taking advantage of what Excel can offer?
You can use Excel to access, process, analyse, share, and display the information with which you work. Applications for Microsoft Excel have expanded far beyond the accounting and finance departments, to include users in virtually every aspect of business operations.

With Activia, you can check your skill level (see the button on the right) 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.

We can also tailor your Microsoft Excel training to your needs (click the button on the right) or to your company project requirements, taking you from first principles to whatever level you want to achieve.

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.

History Of Microsoft Excel

Previous versions of Excel had all used macros (pre-written code that makes it easier to perform repetitive tasks).  Up until the fourth release, Microsoft utilised XML language to perform tasks. Thereafter, from version 5.0 onwards, Excel used VBA for macros (although users could still revert back to XML if they wanted to).

Excel 2000

This updated release of Excel boasted many new features. For example, users could drag and drop information from a web source directly into their spreadsheet. This was due to the introduction of Enhanced Web Queries, a feature that made it easier to import data in to Excel for analysis and tracking. It also offered a range of different date functions and allowed users to save – and read from – HTML files.

Excel 2003

With the main changes benefiting business users, Excel 2003 was different in two ways:

It permitted information to be saved and updated in XML format. This made Excel instantly compatible with other programs, allowing data to be imported from other sources.Highly specialised, and created for specialist corporate users, IRM tools provided security features to help protect data. This could be achieved by downloading a free software patch.

Excel 2007

Excel’s workbooks were significantly improved in the 2007 update. This meant the programme could store more data (up to 16,000 columns and up to a million rows). The ribbon interface made radical changes to navigation, and was not well received by a large number of users.  Constructing tables around data became easier too, due to a wider array of headings and row types.

Excel 2010

At first glance it seemed like nothing had changed in the 2010 version of Excel, and in fact, the differences were very subtle. Improvements were made to the ribbon, which could be fully customised. Security protocols were also overhauled, thanks to the introduction of Protected View, which prevented harmful content from being downloaded.

Excel 2013

Anyone relying on templates to use Excel will find the 2013 update ideal for their needs. This release comes armed with a veritable range of them, each designed for a specific purpose: forecasting, budgeting, calendars and much more. The new Quick Analysis feature converts data in to tables in two simple steps – plus, workbooks open in different windows, which is ideal for anyone using more than one monitor.

Related Courses

You will find related training courses in our Microsoft Software section.

Feedback from delegates on our Microsoft Excel courses

Average Review 4.4/5 based on 685 reviews.

"It's truly refreshing to be taught by someone who has a geuine passion for Excel. He was very enthusiastic about the topic, and I found his passion infectious - I went straight home and trid everything out! He was also very approachable too, I felt like i could ask him questions whenever I wanted, without being a hindranceLee was a great trainer; he made me feel like I was doing well, and didn't lose his patience at all."     Kimberley Hylton     Mar 25 2015    

"Very good course"     Claire Puffett     Mar 16 2015    

"Liz is a great trainer - enthusiastic and engaging, she provided lots of opportunities to practice the skills she was teaching us. A very enjoyable day - I left feeling very positive and confident about applying the new skills I had learnt."     SYLVIA JAMES     Mar 12 2015    

"The trainer was very good."     Jane Goozee     Mar 11 2015    

"Very well delivered"     Preeti Padia     Mar 11 2015    

"Course and trainer were both really very good. "     Jacqueline Lallis     Mar 10 2015    

"Thank you I really enjoyed my day."     Nina Hammarberg     Mar 4 2015    

"I thought this was an excellent course, and the instructor was excellent at delivering the course, everyone interacted and got involved."     Sarah Young     Mar 4 2015    

"Thank you for a fun educational day!"     Aimee Deavin-Baker     Mar 4 2015    

"I really enjoyed being tutored by Jane and find her approach and style very easy to understand. "     Vicky Chen     Mar 4 2015    

"thank you so much."     Neelam Rohewal     Mar 3 2015    

"Noel is an excellent trainer and made everyone comfortable with the subject matter. "     alex urka     Mar 2 2015    

"I found the course very useful and it would be great if you could find courses like this to do outside of work as I've found it almost impossible to find the right excel course for me using google! This course was a great help. Many Thanks"     David Crisp     Feb 27 2015    

"Good training day"     Jodie Hanson     Feb 27 2015    

"The course trainer was very good. He was clearly very knowledgeable, and kept things very interesting and personable. The 'best method' tips were very advantageous, as it will shorten things considerably, for our requirements."     Stuart Carter     Feb 27 2015    

"Good training by a skilled trainer."     Margaret Mackintosh     Feb 26 2015    

"The course was very good. It covered a vast range of topics in an easily understandable way. The tutor was excellent. He explained things simply but thoroughly and was very helpful when we did not quite grasp the concepts or needed further explanation. "     Marianne Brown     Feb 25 2015    

"Enjoyed the course, and learnt a large amount of additional info that will aid in the advancement and the streamlineing at work"     paula pennell     Feb 25 2015    

"Trainer was v good"     Amanda Mitchell     Feb 24 2015    

"Mandy was an excellent teacher, very friendly and welcoming. She put me at ease immediately and was happy to answer all my questions. "     Kerrie Staley     Feb 24 2015    

Microsoft Excel Introduction (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course

training-courses-for-excel-2003-to-2013

FREE eLearning revision

Note: FREE eLearning revision is available with this course.   Click the "About Microsoft Excel" button at the top of the right hand menu for more details.

Versions covered

This course covers Microsoft Excel 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.

Content covered

Getting Started with Microsoft Excel
• Starting Out  • About Workbooks  • Exploring your Workbook  • Getting Help with Excel 
The Excel Interface
• 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 
Microsoft Excel Basics
• Working with Excel  • Basic Excel Features  • Moving your Data  • Smart Tags and Options Buttons  • Editing Tools 
Editing your Workbook
• Modifying Cells and Data  • Cell Formatting  • Enhancing a Worksheet’s Appearance 
Printing and Viewing your Workbook
• Using the View Tab  • Managing a Single Window  • Managing Multiple Windows  • Printing your Workbook 
Working with Charts in Excel
• Creating Charts  • Selecting Chart Data  • Working with Chart Options 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Excel Intermediate (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course

training-courses-for-excel-2003-to-2013

FREE eLearning revision

Note: FREE eLearning revision is available with this course.   Click the "About Microsoft Excel" button at the top of the right hand menu for more details.

Versions covered

This course covers Microsoft Excel 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.

Content covered

Advanced File Tasks
• Saving and File Management  • Converting and Encrypting Files  • File Properties and Digital Signatures  • File Accessibility and Compatibility 
Working with Functions and Formulas
• Autosum Functions (SUM & AVERAGE)  • IF and Nested Functions  • Working with Named Ranges  • Array Functions (SUMIF & AVERAGEIF)  • Formula Auditing 
Managing Tables in Microsoft Excel
• Creating Excel Tables  • Working with Records and Filters  • Advanced Filters 
Data Tools in Excel
• Text to Columns  • Flash Fill  • Remove Duplicates  • Data Validation  • Consolidate 
Doing More with Charts in Excel
• Trendlines  • Error Bars  • Working with Axis Options  • Advanced Chart Formatting 
Sparklines
• Creating Sparklines  • Editing Sparklines 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Excel Advanced (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course

training-courses-for-excel-2003-to-2013

FREE eLearning revision

Note: FREE eLearning revision is available with this course.   Click the "About Microsoft Excel" button at the top of the right hand menu for more details.

Versions covered

This course covers Microsoft Excel 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.

Content covered

Grouping & Outlining and Subtotals
• Outlining and Grouping Data  • Using the Subtotals Tool 
What-If Analysis
• Exploring Scenarios  • Goal Seek and Data Tables  • Using Solver 
PivotTables
• Getting Started with PivotTables  • Displaying Data in a PivotTable  • Formatting a PivotTable  • Using the Classic PivotTable Layout  • Slicers 
Charting Pivoted Data
• Getting Started with PivotCharts  • Using the PivotChart Tools Tabs  • Formatting a PivotChart 
Advanced Excel Tasks
• Excel and Hyperlinks  • Using Custom AutoFill Lists  • Sharing Workbooks 
Creating HLOOKUP and VLOOKUP Functions
• Using the VLOOKUP Function  • Using the LOOKUP Function 
Introduction to Macros in Excel
• Recording and Playing Macros  • Copying and Deleting Macros  • Visual Basic and Macros 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Excel Professional (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course

training-courses-for-excel-2003-to-2013

FREE eLearning revision

Note: FREE eLearning revision is available with this course.   Click the "About Microsoft Excel" button at the top of the right hand menu for more details.

Versions covered

This course covers Microsoft Excel 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.

Content covered

Advanced Conditional Formatting
• Editing Standard Formatting Rules  • Using Formulas in Conditional Formatting 
Using Form Controls and Templates
• Using Form Controls  • Creating Templates 
Advanced Lookup Functions
• Using the Index Function  • Using the Match Function  • Using Index and Match Together  • Using Index and Match with Array Formula  • Using the Indirect Function 
Advanced Functions in Excel
• Using Error Functions  • Using Logical Functions  • Using Array Formulas  • Using Rounding Functions 
Advanced Pivot Table Tools
• Importing Pivot Table Data  • Calculated Fields in Pivot Tables  • Showing Pivot Data as a Percentage  • Creating Custom Pivot Tables Styles 
Introduction to User Defined Functions Using VBA
• Creating a User Defined Function  • Creating an Interactive Procedure  • Create and Share a Function Add-in 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Excel VBA Introduction (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course

training-courses-for-excel-2003-to-2013

Versions covered

This course covers Microsoft Excel 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.

Content covered

Recording and Running Macros in Excel
• Setting Excel Macro Options  • Record and Run Simple Macros  • Assign Macros to the Quick Access Toolbar 
Introduction to the Excel VBA Editor
• Starting the Visual Basic Editor  • Using the Project Explorer  • Using the Properties Window  • Creating, Importing and Exporting Modules  • Explore Recorded Macros 
Creating Procedures and Functions
• Creating Sub and Function Procedures  • Declare and Use Variables  • Displaying Message to the User  • Getting Input from the User 
Working with the Excel Object Model
• Understanding Objects, Properties and Methods  • Referencing Cells and Ranges  • Gathering Cell and Range Information  • Using the Offset Method  • Using the Resize Method  • Using With Blocks  • Referencing Workbooks and Worksheets 
Controlling Program Flow
• Using the IF Statement  • Using the Select Case Statement  • Using For Next Loops  • Using Do Loops  • Using For Next Loops 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Excel VBA Advanced (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course

training-courses-for-excel-2003-to-2013

Versions covered

This course covers Microsoft Excel 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.

Content covered

Advanced Procedures
• Calling Procedures  • Passing Values to Procedures 
Advanced Variables
• Understanding Variable Scope  • Understanding Object Variables  • Creating Array Variables  • Creating Dynamic Array Variables 
Interacting with Office Applications
• Setting References to other Applications  • Setting References using Late Binding  • Create a PowerPoint Presentation  • Create a Letter in Word 
Debugging and Error Traps
• Review of Error Types  • Debugging tools  • Setting Error Traps 
Creating Custom User Forms
• Creating a Custom Form  • Adding Form Controls  • Creating Event Procedures 
Workbook and Worksheet Events
• Create Workbook Events  • Create WorkSheet Events 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Excel Introduction (2003 & XP)

Course Outline

Duration: this is a one-day training course

training-courses-for-excel-2003-to-2013

Versions covered

This course covers Microsoft Excel 2003 and 2002 (XP).
TIP: If your screen has drop-down menus, rather than the top ribbon interface which replaced them in later versions of the software, this is the course you need.

Content covered

Getting Started with Excel 2003
Introduction: • Opening Excel  • Exiting Excel 
Help with Excel: • Finding Help  • The Office Assistant  • The Help Task Pane 
Beginning Excel: • The Standard Toolbar  • The Formatting Toolbar  • Working with Excel Menus  • Exploring Task Panes  • Excel Short-cut Keys 
Basic Workbook Tasks
The Basics of File Management: • New Workbooks  • How to Open Existing Workbooks  • How to Save Workbooks  • How to Close Workbooks  • Excel File Types 
Explore your Workbook: • Switching Worksheets  • The Active Cell  • Selecting Cells  • Exploring a Worksheet  • The Zoom Feature 
Working with Excel: • Columns, Rows, Cells, and Ranges  • Creating Worksheet Labels  • Entering and Deleting Data  • Printing your Worksheet 
Modifying Excel Toolbars: • Hiding Toolbars  • Showing Toolbars  • Moving Toolbars  • Customizing Toolbars 
Entering and Editing Data
Basic Excel Features: • What is AutoFill?  • What is AutoSum?  • What is AutoComplete?  • Working with Basic Formulas 
Editing Tools: • AutoCorrect  • Spell Check  • Find and Replace  • Documenting a Worksheet with Comments 
Manipulating Data
Moving your Data: • Dragging and Dropping Cells  • How to Cut, Copy, and Paste Cells  • How to Cut, Copy, and Paste Multiple Cells and Items  • How to Use Paste Special  • How to Insert and Delete Cells, Rows, and Columns  • Undo, Redo, and Repeat 
Smart Tags and Option Buttons: • What are Smart Tags?  • The Error Option Button  • The AutoFill Option Button  • The Paste Option Button 
Formatting Worksheets
Modifying Cells and Data: • Changing the Size of Rows or Columns  • Working with the Formatting Toolbar  • Adjusting Cell Alignment  • Rotating Text  • Creating Custom Number and Date Formats 
Cell Formatting: • Conditional Formatting  • What is the Format Painter?  • What is AutoFormat?  • Cell Merging and AutoFit  • Find and Replace Formatting 
Enhancing a Worksheet’s Appearance: • Adding Patterns and Colours  • Adding Borders  • Adding Fill Effects  • Working with Styles 
Introduction to Charts
Working with Charts: • Creating a Chart  • Formatting a Chart  • Manipulating a Chart  • Enhancing a Chart with Drawing Tools  • Enhancing your Chart with Titles and Tables 
Working with Charts and Data: • Changing the Type of Chart  • Changing the Source Data  • Creating 3-D Charts  • Working with the Chart Axes and Data Series  • Making Custom Charts 
Organising and Formatting Workbooks
Organizing your Workbook: • Inserting and Removing Worksheets  • Renaming, Moving, and Colour-Coding Worksheets  • How to Split and Freeze a Window  • Using Multiple Workbooks and Windows  • Using a Watch Window  • Creating a Custom View 
Formatting your Workbook: • Headers and Footers  • Inserting Page Numbers  • Changing Margins and Orientation  • Hiding Rows, Columns and Worksheets 
Printing and Managing Workbooks
Printing a Workbook: • Choosing a Print Area  • Setting up Page Breaks  • Choosing Paper Size and Changing Print Scale  • Adding Print Titles and Gridlines 
More Workbook Features: • Linking Workbooks  • Consolidating Workbooks  • Combining Worksheets  • Protecting Worksheets  • Templates 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Excel Intermediate (2003 & XP)

Course Outline

Duration: this is a one-day training course

training-courses-for-excel-2003-to-2013

Versions covered

This course covers Microsoft Excel 2003 and 2002 (XP).
TIP: If your screen has drop-down menus, rather than the top ribbon interface which replaced them in later versions of the software, this is the course you need.

Content covered

Working with Formulas
Creating Simple Formulas: • Basic Mathematical Operators 
Absolute and Relative Formulas: • Relative Cell References  • Absolute Cell References 
Using Formulas across Worksheets: • Using Formulas across Worksheets 
Formula Auditing: • Fixing Formula Errors  • Displaying And Printing Formulas 
Working with Functions
Sum and Average Functions: • Using the Insert Function Window  • Function Syntax 
Using IF and Nested Functions: • Using the IF Function  • Working with Nested Functions 
Naming Cell Ranges: • What Are Range Names?  • Defining And Using Range Names  • Selecting Nonadjacent Ranges  • Auto Calculate 
Functions and Array Formulas: • What Are Array Formulas  • Using Basic Array Formulas  • Using Functions with Array Formulas  • Using the IF Function in Array Formulas 
Text Functions: • CONCATENATE  • LEFT and RIGHT Functions  • UPPER, LOWER and PROPER Functions 
Managing Lists
Working with Lists: • What Is A List?  • Creating Lists  • Modifying Lists  • What Is The Total Row? 
Working with Records and Fields: • What Are Records And Fields?  • Adding Fields By Inserting Columns  • Adding Records By Inserting Rows  • Adding Records With A Data Form  • Finding And Deleting Records 
Working with Lists and Filters: • Sorting A List  • What Is An Autofilter  • Custom Autofilters  • Using An Advanced Filter  • Filtering With Wild Card Characters  • Copying Filtered Records 
Using Excel as a Database
Using Database Functions: • Using Database Functions 
Data Validation: • Data Validation 
The VLOOKUP and HLOOKUP Functions: • VLOOKUP  • HLOOKUP 
Using Excel with Other Programmes
Using Excel in Word: • Inserting Excel Data In Word  • Modifying Excel Data After Insertion  • Linking Excel Data In Word  • Linking An Excel Chart In Word 
Using Excel with Other Programs and Files: • Using Outlook To Send Excel Data  • Opening An Excel File In A Different Format  • Importing Data From A Text File  • Importing Data From A Database 
Working with Charts
Using the Chart Wizard: • Using the Chart Wizard 
Modifying a Chart’s Appearance: • Modifying a Chart’s Appearance 
Other Chart Types: • Other Chart Types 
Reusing a Custom Chart: • Reusing a Custom Chart 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Excel Advanced (2003 & XP)

Course Outline

Duration: this is a one-day training course

training-courses-for-excel-2003-to-2013

Versions covered

This course covers Microsoft Excel 2003 and 2002 (XP).
TIP: If your screen has drop-down menus, rather than the top ribbon interface which replaced them in later versions of the software, this is the course you need.

Content covered

Outlining and Grouping your Data
Outlining and Grouping your Data: • Using Automatic Outlining  • Displaying And Collapsing Levels  • Grouping Data Manually  • Creating Subtotals 
Using Pivot Tables
Creating PivotTables: • What Is A PivotTable?  • Creating A PivotTable Frame  • Specifying Data in a PivotTable  • Rearranging PivotTable Data 
Pivot Tables and Charts: • Modifying PivotTable Calculations  • Formatting A PivotTable  • Refreshing A PivotTable  • Charting A PivotTable  • Creating A PivotTable Based On Data From An External Database 
What If Analysis
Exploring Scenarios: • What Is A Scenario?  • Creating A Scenario  • Creating A Scenario Summary Report  • Saving Multiple Scenarios 
Goal Seek, Data Tables and Solver: • Using A One And Two Input Data Table  • Using Goal Seek  • Using Solver 
Excel and the Internet
Excel and Hyperlinks: • Hyperlinks and the Internet  • Inserting Hyperlinks  • Modifying Hyperlinks  • The Web Toolbar  • Browsing Hyperlinks In Excel 
Excel Workbooks as Web Pages: • Interactive and Non-Interactive Web Pages  • Saving A Workbook As A Web Page  • Saving A Worksheet As A Web Page  • Saving A Chart As A Web Page  • Saving A Range As A Web Page 
Creating and Using Shared Workbooks
Creating and Using Shared Workbooks: • Sharing A Workbook  • Requesting Reviews  • Reviewing A Workbook  • Tracking Changes  • Merging And Revising A Shared Workbook 
Advanced Excel Tasks
Advanced File Management: • Identifying File Properties  • Searching For Files  • Protecting Personal Information  • Creating Back Up Files  • Changing Auto-Recovery Settings 
Custom and Advanced Features in Excel: • Customizing Excel By Changing Options  • Using Custom AutoFill Lists  • Text To Speech  • Using Detect And Repair 
Macros and Form Controls
Creating Macros in Excel: • What Is A Macro?  • Creating A Macro  • Playing A Macro  • Assigning A Shortcut Key To Macro  • Macros, Buttons, And Toolbars 
Excel Form Controls: • What Is A Form Control?  • The Form Toolbar  • Adding A Control To A Worksheet  • Assigning A Macro To A Control  • Form Controls 
Visual Basic (VBA) and Macros
Visual Basic (VBA) and Macros: • Adding Code To Your Macro  • Adding Comments To VBA Code  • Declaring Variables  • Prompting For User Input  • Iteration Over A Range  • If Then Else Statements 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Prices for Microsoft Excel training

Please note : all prices exclude VAT.

Scheduled public classes

[The simplest and most cost-effective option for 1, 2 or 3 delegates]
If you book in advance, Early Bird prices start at just £149
•  Excel Introduction (2007, 2010 & 2013)
 
First delegate: £179
2nd delegate: £169
3rd delegate +: £159 each
•  Excel Intermediate (2007, 2010 & 2013)
 
First delegate: £189
2nd delegate: £179
3rd delegate +: £169 each
•  Excel Advanced (2007, 2010 & 2013)
 
First delegate: £199
2nd delegate: £189
3rd delegate +: £179 each
•  Excel Professional (2007, 2010 & 2013)
 
First delegate: £229
2nd delegate: £219
3rd delegate +: £209 each
•  Excel VBA Introduction (2007, 2010 & 2013)
 
First delegate: £249
2nd delegate: £239
3rd delegate +: £229 each
•  Excel VBA Advanced (2007, 2010 & 2013)
 
First delegate: £299
2nd delegate: £285
3rd delegate +: £269 each
•  Excel Introduction (2003 & XP)
 
First delegate: £249
2nd delegate: £239
3rd delegate +: £229 each
•  Excel Intermediate (2003 & XP)
 
First delegate: £249
2nd delegate: £239
3rd delegate +: £229 each
•  Excel Advanced (2003 & XP)
 
First delegate: £249
2nd delegate: £239
3rd delegate +: £229 each
NOTE   [click to show/hide]
To view scheduled dates, click the "Dates" button on the right

Training at your offices

[A convenient and very cost-effective option for groups of delegates]
•  Excel Introduction (2007, 2010 & 2013)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Excel Intermediate (2007, 2010 & 2013)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Excel Advanced (2007, 2010 & 2013)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Excel Professional (2007, 2010 & 2013)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Excel VBA Introduction (2007, 2010 & 2013)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Excel VBA Advanced (2007, 2010 & 2013)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Excel Introduction (2003 & XP)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Excel Intermediate (2003 & XP)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Excel Advanced (2003 & XP)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
NOTES   [click to show/hide]

Scheduled dates for our public classes

Prices vary, and in general, the earlier you book, the lower the price.
Our small class sizes mean that classes are often full, so it's usually best to book as soon as you can.   So don't be disappointed by leaving it too late!

If you see classes at higher prices set to run over the next few days, these are empty classes and if you book, you may be the only delegate attending.

NOTE : prices are per delegate and exclude VAT.

Click on the links in the right panel for outlines and more information on any course.
View scheduled dates for the course you want by clicking on "Show/Hide Dates" in the relevant blue panel below.
Click on 'Book now' against the class you wish to book.

Excel 2007, 2010 and 2013

 Application/Subject
Level
Date
Centre
Price
 
Excel Introduction (2007, 2010 & 2013)
[ Click to Show/Hide Dates +/– ]
May 26, 2015
Bristol
 
**Full**
May 26, 2015
London Victoria
£174
Book Now
May 26, 2015
Manchester Princess Street
£168
Book Now
Jun 1, 2015
London Baker Street W1
£166
Book Now
Jun 2, 2015
Leeds
£179
Book Now
Jun 2, 2015
Slough
£169
Book Now
Jun 2, 2015
Reading Green Park
£179
Book Now
Jun 2, 2015
Milton Keynes
 
**Full**
Jun 9, 2015
Birmingham City Centre
£175
Book Now
Jun 9, 2015
Nottingham
£179
Book Now
Jun 9, 2015
Tower Bridge
£175
Book Now
Jun 16, 2015
Manchester Princess Street
£166
Book Now
Jun 16, 2015
Bristol
£179
Book Now
Jun 23, 2015
Milton Keynes
£179
Book Now
Jun 23, 2015
Reading Green Park
£166
Book Now
Jun 23, 2015
Leeds
£179
Book Now
Jun 23, 2015
London Baker Street W1
£179
Book Now
Jun 23, 2015
Slough
£166
Book Now
Jun 25, 2015
Manchester Princess Street
 
**Full**
Jun 29, 2015
Tower Bridge
£179
Book Now
Jun 30, 2015
Birmingham City Centre
£172
Book Now
Jun 30, 2015
Nottingham
£168
Book Now
Jul 7, 2015
Bristol
£169
Book Now
Jul 7, 2015
Manchester Princess Street
£159
Book Now
Jul 14, 2015
Leeds
£169
Book Now
Jul 14, 2015
Slough
£169
Book Now
Jul 14, 2015
London Baker Street W1
£169
Book Now
Jul 14, 2015
Reading Green Park
£169
Book Now
Jul 14, 2015
Milton Keynes
£169
Book Now
Jul 21, 2015
Birmingham City Centre
£169
Book Now
Jul 21, 2015
Nottingham
£169
Book Now
Jul 21, 2015
Tower Bridge
£169
Book Now
Jul 27, 2015
Milton Keynes
£159
Book Now
Jul 28, 2015
Bristol
£159
Book Now
Jul 28, 2015
Manchester Princess Street
£148
Book Now
Aug 4, 2015
Leeds
£159
Book Now
Aug 4, 2015
London Baker Street W1
£159
Book Now
Aug 4, 2015
Reading Green Park
£159
Book Now
Aug 4, 2015
Slough
£159
Book Now
Aug 11, 2015
Birmingham City Centre
£149
Book Now
Aug 11, 2015
Tower Bridge
£149
Book Now
Aug 11, 2015
Nottingham
£149
Book Now
Aug 17, 2015
Bristol
£149
Book Now
Aug 18, 2015
Manchester Princess Street
£149
Book Now
Aug 24, 2015
London Baker Street W1
£149
Book Now
Aug 24, 2015
Slough
£149
Book Now
Aug 25, 2015
Reading Green Park
£149
Book Now
Aug 25, 2015
Milton Keynes
£149
Book Now
Aug 25, 2015
Leeds
£149
Book Now
Excel Intermediate (2007, 2010 & 2013)
[ Click to Show/Hide Dates +/– ]
May 27, 2015
Bristol
 
**Full**
May 27, 2015
London Victoria
£171
Book Now
May 27, 2015
Manchester Princess Street
£173
Book Now
May 27, 2015
Manchester Princess Street
 
**Full**
May 29, 2015
London Baker Street W1
 
**Full**
Jun 3, 2015
Milton Keynes
£178
Book Now
Jun 3, 2015
London Baker Street W1
£178
Book Now
Jun 3, 2015
Slough
£179
Book Now
Jun 3, 2015
Leeds
 
**Full**
Jun 3, 2015
Reading Green Park
£176
Book Now
Jun 5, 2015
Tower Bridge
 
**Full**
Jun 8, 2015
Tower Bridge
 
**Full**
Jun 10, 2015
Birmingham City Centre
£181
Book Now
Jun 10, 2015
Nottingham
£189
Book Now
Jun 10, 2015
Tower Bridge
£178
Book Now
Jun 16, 2015
Milton Keynes
 
**Full**
Jun 17, 2015
Manchester Princess Street
£176
Book Now
Jun 17, 2015
London Victoria
 
**Full**
Jun 17, 2015
Bristol
£189
Book Now
Jun 24, 2015
London Baker Street W1
£176
Book Now
Jun 24, 2015
Reading Green Park
£176
Book Now
Jun 24, 2015
Milton Keynes
£178
Book Now
Jun 24, 2015
Leeds
£179
Book Now
Jun 24, 2015
Slough
£178
Book Now
Jun 30, 2015
Tower Bridge
£178
Book Now
Jul 1, 2015
Nottingham
£189
Book Now
Jul 1, 2015
Birmingham City Centre
£179
Book Now
Jul 8, 2015
Manchester Princess Street
£166
Book Now
Jul 8, 2015
Bristol
£172
Book Now
Jul 15, 2015
London Baker Street W1
£166
Book Now
Jul 15, 2015
Reading Green Park
£179
Book Now
Jul 15, 2015
Milton Keynes
£179
Book Now
Jul 15, 2015
Slough
£179
Book Now
Jul 15, 2015
Leeds
£169
Book Now
Jul 22, 2015
Nottingham
£169
Book Now
Jul 22, 2015
Birmingham City Centre
£169
Book Now
Jul 22, 2015
Tower Bridge
£157
Book Now
Jul 28, 2015
Milton Keynes
£169
Book Now
Jul 29, 2015
Manchester Princess Street
£157
Book Now
Jul 29, 2015
Bristol
£161
Book Now
Aug 5, 2015
Leeds
£169
Book Now
Aug 5, 2015
Reading Green Park
£169
Book Now
Aug 5, 2015
London Baker Street W1
£169
Book Now
Aug 5, 2015
Slough
£169
Book Now
Aug 12, 2015
Nottingham
£159
Book Now
Aug 12, 2015
Birmingham City Centre
£159
Book Now
Aug 12, 2015
Tower Bridge
£159
Book Now
Aug 18, 2015
Bristol
£159
Book Now
Aug 19, 2015
Manchester Princess Street
£159
Book Now
Aug 25, 2015
London Baker Street W1
£159
Book Now
Aug 25, 2015
Slough
£159
Book Now
Aug 26, 2015
Leeds
£159
Book Now
Aug 26, 2015
Milton Keynes
£159
Book Now
Aug 26, 2015
Reading Green Park
£159
Book Now
Excel Advanced (2007, 2010 & 2013)
[ Click to Show/Hide Dates +/– ]
May 28, 2015
Manchester Princess Street
£183
Book Now
May 28, 2015
Bristol
£179
Book Now
May 29, 2015
Tower Bridge
 
**Full**
Jun 4, 2015
London Baker Street W1
£187
Book Now
Jun 8, 2015
Slough
£199
Book Now
Jun 11, 2015
Nottingham
£185
Book Now
Jun 18, 2015
London Victoria
 
**Full**
Jun 25, 2015
Reading Green Park
£199
Book Now
Jun 25, 2015
Milton Keynes
£189
Book Now
Jun 25, 2015
Leeds
£191
Book Now
Jul 2, 2015
Tower Bridge
£187
Book Now
Jul 2, 2015
Birmingham City Centre
£199
Book Now
Jul 9, 2015
Bristol
£181
Book Now
Jul 9, 2015
Manchester Princess Street
£178
Book Now
Jul 16, 2015
Slough
£178
Book Now
Jul 16, 2015
London Baker Street W1
£189
Book Now
Jul 23, 2015
Nottingham
£168
Book Now
Jul 29, 2015
Milton Keynes
£168
Book Now
Aug 6, 2015
Reading Green Park
£179
Book Now
Aug 6, 2015
Leeds
£179
Book Now
Aug 13, 2015
Birmingham City Centre
£169
Book Now
Aug 13, 2015
Tower Bridge
£169
Book Now
Aug 19, 2015
Bristol
£169
Book Now
Aug 20, 2015
Manchester Princess Street
£169
Book Now
Aug 26, 2015
Slough
£169
Book Now
Aug 26, 2015
London Baker Street W1
£169
Book Now
Excel Professional (2007, 2010 & 2013)
[ Click to Show/Hide Dates +/– ]
May 29, 2015
Bristol
 
**Full**
May 29, 2015
Manchester Princess Street
 
**Full**
Jun 5, 2015
London Baker Street W1
£229
Book Now
Jun 9, 2015
Slough
£215
Book Now
Jun 12, 2015
Nottingham
£229
Book Now
Jun 26, 2015
Reading Green Park
£229
Book Now
Jun 26, 2015
Milton Keynes
£229
Book Now
Jun 26, 2015
Leeds
£229
Book Now
Jul 3, 2015
Birmingham City Centre
£215
Book Now
Jul 3, 2015
Tower Bridge
£213
Book Now
Jul 10, 2015
Bristol
£219
Book Now
Jul 10, 2015
Manchester Princess Street
£219
Book Now
Jul 17, 2015
London Baker Street W1
£204
Book Now
Jul 17, 2015
Slough
£219
Book Now
Jul 24, 2015
Nottingham
£209
Book Now
Jul 30, 2015
Milton Keynes
£209
Book Now
Aug 7, 2015
Reading Green Park
£209
Book Now
Aug 7, 2015
Leeds
£209
Book Now
Aug 14, 2015
Birmingham City Centre
£199
Book Now
Aug 14, 2015
Tower Bridge
£199
Book Now
Aug 20, 2015
Bristol
£199
Book Now
Aug 21, 2015
Manchester Princess Street
£199
Book Now
Aug 27, 2015
Slough
£199
Book Now
Aug 27, 2015
London Baker Street W1
£199
Book Now
Excel VBA Introduction (2007, 2010 & 2013)
[ Click to Show/Hide Dates +/– ]
Jun 17, 2015
Slough
£249
Book Now
Jul 2, 2015
London Baker Street W1
£249
Book Now
Jul 9, 2015
Nottingham
£239
Book Now
Jul 23, 2015
Reading Green Park
£229
Book Now
Jul 23, 2015
Leeds
£229
Book Now
Jul 23, 2015
Milton Keynes
£229
Book Now
Jul 27, 2015
Tower Bridge
£229
Book Now
Jul 27, 2015
Manchester Princess Street
£229
Book Now
Jul 30, 2015
Birmingham City Centre
£229
Book Now
Aug 6, 2015
Bristol
£229
Book Now
Aug 13, 2015
Slough
£219
Book Now
Aug 20, 2015
Nottingham
£219
Book Now
Aug 28, 2015
Milton Keynes
£219
Book Now
Aug 28, 2015
Reading Green Park
£219
Book Now
Excel VBA Advanced (2007, 2010 & 2013)
[ Click to Show/Hide Dates +/– ]
Jun 25, 2015
Slough
£278
Book Now
Jul 3, 2015
London Baker Street W1
£299
Book Now
Jul 10, 2015
Nottingham
£286
Book Now
Jul 24, 2015
Reading Green Park
£272
Book Now
Jul 24, 2015
Milton Keynes
£272
Book Now
Jul 24, 2015
Leeds
£272
Book Now
Jul 28, 2015
Tower Bridge
£272
Book Now
Jul 31, 2015
Birmingham City Centre
£272
Book Now
Aug 6, 2015
Manchester Princess Street
£272
Book Now
Aug 7, 2015
Bristol
£272
Book Now
Aug 14, 2015
Slough
£259
Book Now
Aug 21, 2015
Nottingham
£259
Book Now
Need another date or location ?   Click to schedule your own class from £299.

Excel 2003 & XP

 Application/Subject
Level
Date
Centre
Price
 
Excel Introduction (2003 & XP)
[ Click to Show/Hide Dates +/– ]
Jun 1, 2015
Nottingham
£249
Book Now
Jun 15, 2015
Reading Green Park
£249
Book Now
Jun 15, 2015
Leeds
£249
Book Now
Jun 15, 2015
Milton Keynes
£249
Book Now
Jun 22, 2015
Birmingham City Centre
£249
Book Now
Jun 22, 2015
Tower Bridge
£249
Book Now
Jun 29, 2015
Bristol
£249
Book Now
Jun 29, 2015
Manchester Princess Street
£249
Book Now
Jul 6, 2015
Slough
£249
Book Now
Jul 6, 2015
London Baker Street W1
£249
Book Now
Jul 13, 2015
Nottingham
£239
Book Now
Jul 27, 2015
Reading Green Park
£229
Book Now
Jul 27, 2015
Leeds
£229
Book Now
Aug 3, 2015
Birmingham City Centre
£229
Book Now
Aug 3, 2015
Tower Bridge
£229
Book Now
Aug 4, 2015
Milton Keynes
£229
Book Now
Aug 10, 2015
Bristol
£229
Book Now
Aug 10, 2015
Manchester Princess Street
£229
Book Now
Aug 17, 2015
London Baker Street W1
£219
Book Now
Aug 17, 2015
Slough
£219
Book Now
Aug 24, 2015
Nottingham
£219
Book Now
Excel Intermediate (2003 & XP)
[ Click to Show/Hide Dates +/– ]
May 26, 2015
London Baker Street W1
 
**Full**
May 26, 2015
Slough
 
**Full**
Jun 2, 2015
Nottingham
£249
Book Now
Jun 16, 2015
Reading Green Park
£249
Book Now
Jun 16, 2015
Leeds
£249
Book Now
Jun 17, 2015
Milton Keynes
£249
Book Now
Jun 23, 2015
Birmingham City Centre
£249
Book Now
Jun 23, 2015
Tower Bridge
£249
Book Now
Jun 30, 2015
Manchester Princess Street
£249
Book Now
Jun 30, 2015
Bristol
£249
Book Now
Jul 7, 2015
London Baker Street W1
£239
Book Now
Jul 7, 2015
Slough
£239
Book Now
Jul 14, 2015
Nottingham
£239
Book Now
Jul 28, 2015
Reading Green Park
£229
Book Now
Jul 28, 2015
Leeds
£229
Book Now
Aug 4, 2015
Tower Bridge
£229
Book Now
Aug 4, 2015
Birmingham City Centre
£229
Book Now
Aug 5, 2015
Milton Keynes
£229
Book Now
Aug 11, 2015
Manchester Princess Street
£219
Book Now
Aug 11, 2015
Bristol
£219
Book Now
Aug 18, 2015
London Baker Street W1
£219
Book Now
Aug 18, 2015
Slough
£219
Book Now
Aug 25, 2015
Nottingham
£219
Book Now
Excel Advanced (2003 & XP)
[ Click to Show/Hide Dates +/– ]
May 27, 2015
Slough
 
**Full**
May 27, 2015
London Baker Street W1
 
**Full**
Jun 3, 2015
Nottingham
£249
Book Now
Jun 17, 2015
Leeds
£249
Book Now
Jun 17, 2015
Reading Green Park
£249
Book Now
Jun 19, 2015
Milton Keynes
£249
Book Now
Jun 24, 2015
Tower Bridge
£249
Book Now
Jun 24, 2015
Birmingham City Centre
£249
Book Now
Jul 1, 2015
Manchester Princess Street
£249
Book Now
Jul 1, 2015
Bristol
£249
Book Now
Jul 8, 2015
Slough
£239
Book Now
Jul 8, 2015
London Baker Street W1
£239
Book Now
Jul 15, 2015
Nottingham
£239
Book Now
Jul 29, 2015
Leeds
£229
Book Now
Jul 29, 2015
Reading Green Park
£229
Book Now
Aug 5, 2015
Tower Bridge
£229
Book Now
Aug 5, 2015
Birmingham City Centre
£229
Book Now
Aug 6, 2015
Milton Keynes
£229
Book Now
Aug 12, 2015
Bristol
£219
Book Now
Aug 12, 2015
Manchester Princess Street
£219
Book Now
Aug 19, 2015
London Baker Street W1
£219
Book Now
Aug 19, 2015
Slough
£219
Book Now
Aug 26, 2015
Nottingham
£219
Book Now
Need another date or location ?   Click to schedule your own class from £299.
Quick Links

Information

About Microsoft Excel
Delegate Feedback
Prices
Dates

Course outlines

Click on a course title to view the outline.
Excel Introduction (2007, 2010 & 2013)
Excel Intermediate (2007, 2010 & 2013)
Excel Advanced (2007, 2010 & 2013)
Excel Professional (2007, 2010 & 2013)
Excel VBA Introduction (2007, 2010 & 2013)
Excel VBA Advanced (2007, 2010 & 2013)
Excel Introduction (2003 & XP)
Excel Intermediate (2003 & XP)
Excel Advanced (2003 & XP)

Tools

(Note: Tools open in a new window)

Contact details

Phone:
Sales & Bookings:   0845 230 6150
Customer Service:   0845 230 6159
Accounts:                 0845 230 6157
Fax:    
All departments:     08703 500 151
Email:
Click to  

Course Summaries for Excel Training Courses

Excel Introduction (2007, 2010 & 2013)

This intensive one-day training course is designed to let users get to grips with the main features of Microsoft Office Excel 2007, 2010 and 2013, including a thorough treatment of the new 'Ribbon' interface, introduced with Excel 2007. It is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets.

Delegates who attend should be: The course is intended for new users of Microsoft Excel 2007, 2010 or 2013 who want to become productive in the shortest possible time. Delegates should be proficient in using a PC with the Microsoft Windows operating system, but no prior experience with Excel is required.

Excel Intermediate (2007, 2010 & 2013)

This hands-on one-day training course has been designed to give delegates a solid understanding of more advanced tools and concepts used in Excel 2007, 2010 and 2013, in order to increase their knowledge and productivity.

Delegates who attend should be: Users with a basic understanding of Microsoft Excel 2007, 2010 or 2013 who want to take their knowledge of the basic features further in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

Excel Advanced (2007, 2010 & 2013)

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

Delegates who attend should be: Users with a good understanding of Microsoft Excel 2007, 2010 or 2013 who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Excel Professional (2007, 2010 & 2013)

This intensive hands-on one-day training course has been designed to provide delegates with a very advanced set of tools and concepts for Excel 2007, 2010 and 2013 in order to further increase their knowledge and productivity.

Delegates who attend should be: Users with a solid understanding of, and experience with, Microsoft Excel 2007, 2010 or 2013 who want to increase their ability in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction, Intermediate and Advance courses.

Excel VBA Introduction (2007, 2010 & 2013)

This intensive, hands-on one-day course has been designed for people who wish to learn the basics of the Excel VBA programming language, get used to the concepts and methods of VBA programming, and understand (and use) the relevant techniques.

Delegates who attend should be: The course is designed for existing, experienced users of Excel 2007, 2010 or 2013 who need to use VBA to automate their spreadsheets. Delegates should therefore have a solid grounding in, and understanding of, Microsoft Excel to a high level.   Familiarity with the content of the Advanced course would be a minimum requirement although the Professional level is ideal.

Excel VBA Advanced (2007, 2010 & 2013)

This intensive, hands-on one-day course has been designed to build on the foundation created in the VBA Introduction course, to increase their capability to automate and enhance their Excel spreadsheets by the use of advanced tools and concepts.

Delegates who attend should be: This is a course which naturally follows on from the Introduction course. Delegates must either have attended the Introduction course or be fully conversant with all its subject matter.

Excel Introduction (2003 & XP)

Microsoft Excel 2003 is the popular spreadsheet from Microsoft and part of the Microsoft Office XP suite. This training course is designed to let users get to grips with the main features of Microsoft Excel. It is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets.

Delegates who attend should be: New or intending users of Microsoft 2003 or XP who wish to gain a good understanding of the software. Note : A working knowledge of using PCs in the Microsoft Windows environment is required.

Excel Intermediate (2003 & XP)

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

Delegates who attend should be: Users with a basic understanding of Microsoft Excel 2003 or XP who want to consolidate and expand on their knowledge of the basic features in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

Excel Advanced (2003 & XP)

This course will give students the ability to create advanced spreadsheets using the full range of Microsoft Excel 2003's tools and features.

Delegates who attend should be: The course is intended for existing users of Microsoft Excel 2003 or XP who want to use the more advanced features of the software in order to increase their productivity and effectiveness. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Quality Assured Training

Quick Course Finder

With truly hundreds of training courses to choose from, we have a Quick Course Finder that will help you to find the subject area and course you need.

Just click on any heading (in black) or section
(in blue) to go straight to where you need to be.

Click to use our Quick Course Finder

Contact Us

Activia Training
Head Office:
    Regus House, 268 Bath Road
    Slough,   SL1 4DX

Sales:       0845 230 6150
Service:    0845 230 6159
Accounts: 0845 230 6157

Excel Training Courses from Activia

We can provide courses for training in Excel at any of our sixteen centres UK wide, or we can come to your offices – if you have groups of staff, this is a particularly convenient, flexible and cost effective option.

We have been training since 1995 and have continually developed our philosophy of high quality, flexible and cost effective provision of courses for training in Excel.   This means you can be confident that we have the expertise, and the experience, to give all you need with courses for Microsoft Excel.

Call us now on 0845 230 6150 or request a free callback.

Quality Assurance