About Us
  |  
Free Tools
  |  
Courses
  |  
Locations
  |  
Contact Us
ABOUT ACTIVIA
Activia for Microsoft Excel Training
Tutor led training that gets results
Bookings and Enquiries:
Customer Service:
We're here to help!
Access your Dashboard:
0845 230 6150
0845 230 6159
FREE CALLBACK
log in
Icon for Training courses for Excel 2003 to 2013

Excel Training Courses

Training courses for Excel 2003 to 2013

Contact information Click to request a callback
Excel training at our centres or your offices UK-wide
All Courses
Course Outlines
Prices
Dates and Venues
Delegate Feedback
General Information
Heading image for Excel Training Courses from Activia
General Information
about Microsoft Excel training
eLearning icon
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.

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.

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 (see the button above 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.

You can also build your own Microsoft Excel course (click the button above on the right) to suit your own or your company project requirements, incorporating the modules which cover the subjects you want to learn.

Delegate Feedback  from our Microsoft Excel courses
Average Review 4.4/5 based on 752 reviews.

"Alistair delivered our training and he was excellent. He was patient, encouraging and instilled confidence. One of the most informative and enjoyable training courses we have attended."     Caroline Taylor     Jun 26 2015     Rating for feedback (4 stars)

"Lee was a very good trainer and very helpful."     Richard Harrop     Jun 25 2015     Rating for feedback (5 stars)

"the course was very informative. I liked that there were only a small group of us in the room."     Charis Randall     Jun 25 2015     Rating for feedback (4 stars)

"I really enjoyed the course and trainer was excellent, patient and very helpful."     Louise Pakes     Jun 23 2015     Rating for feedback (5 stars)

"Our trainer was brilliant, he had all the answers and was very patient!"     Louise Forshaw     Jun 23 2015     Rating for feedback (5 stars)

"The training course was extremely informative and easy to understand. Lara was a brilliant trainer and I would recommend Activia to anyone."     Lynsey Mitchinson     Jun 22 2015     Rating for feedback (5 stars)

"Heather was an excellent tutor "     Charlotte Williams     Jun 18 2015     Rating for feedback (4 stars)

"a good course with excellent trainer"     Julie McGonagle     Jun 17 2015     Rating for feedback (4 stars)

"Very informative yet fun course"     Nicola Porter     Jun 16 2015     Rating for feedback (5 stars)

"good trainer "     Craig Walton     Jun 10 2015     Rating for feedback (4 stars)

"the trainer was very engaging and built a good rapport with her audience."     Angie Gibson     Jun 9 2015     Rating for feedback (4 stars)

"the trainer was very engaging and built a good rapport with her audience."     Angie Gibson     Jun 9 2015     Rating for feedback (4 stars)

"Trainer was very well informed with the excel functions + she was very helpful with answering my queries."     ARVINDER GHATTAORA     Jun 9 2015     Rating for feedback (4 stars)

"I thoroughly enjoyed all aspects of the course.."     Julia Zimmerman     Jun 8 2015     Rating for feedback (4 stars)

"the course was brilliant especially the way the tutor taught. "     Sophina Ahmed     Jun 8 2015     Rating for feedback (5 stars)

"Great day, best course done at work ever"     Ian Walmsley     Jun 8 2015     Rating for feedback (4 stars)

"Chris is an excellent trainer who constantly assessed the knowledge base of the delegates and tailored his teaching to accommodate this."     Trudy Perrett     Jun 4 2015     Rating for feedback (5 stars)

"The training was very clearly taught and the trainer made every effort to help with any individual queries people had both within the perimeters of the course and beyond."     Jessica Bell     Jun 3 2015     Rating for feedback (4 stars)

"My teacher Clare was excellent"     Ursula Grover     Jun 3 2015     Rating for feedback (4 stars)

"Thank you. "     Nick Seecharan     Jun 2 2015     Rating for feedback (5 stars)

Microsoft Excel Introduction (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course
Click to view all courses
eLearning icon
FREE eLearning revision
Note: FREE eLearning revision is available with this course.   Click the right-hand "General Information" tab for more details.
Activia icon
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
Click to view all courses
eLearning icon
FREE eLearning revision
Note: FREE eLearning revision is available with this course.   Click the right-hand "General Information" tab for more details.
Activia icon
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
Click to view all courses
eLearning icon
FREE eLearning revision
Note: FREE eLearning revision is available with this course.   Click the right-hand "General Information" tab for more details.
Activia icon
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
Click to view all courses
eLearning icon
FREE eLearning revision
Note: FREE eLearning revision is available with this course.   Click the right-hand "General Information" tab for more details.
Activia icon
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
Click to view all courses
Activia icon
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
Click to view all courses
Activia icon
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
Click to view all courses
Activia icon
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
Click to view all courses
Activia icon
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
Click to view all courses
Activia icon
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
All Courses  for Microsoft Excel training
Course Summaries

  TIP :    Click on the blue Course Outline button for any course to see its content.

Image for Excel Introduction (2007, 2010 & 2013)
Excel Introduction (2007, 2010 & 2013)

Learn how to get to grips with the main features of Microsoft Office Excel 2007, 2010 and 2013, including how to navigate the new 'Ribbon' interface, create and modify spreadsheets on this practical course.
Who should attend: New users of Microsoft Office Excel 2007, 2010 and 2013 who want to become more efficient in a short space of time. No prior experience of Excel is needed but basic IT skills are required.

Image for Excel Intermediate (2007, 2010 & 2013)
Excel Intermediate (2007, 2010 & 2013)

This functional course will equip learners with a solid understanding of the more advanced tools and concepts used in Microsoft Excel 2007, 2010 or 2013.
Who should attend: Anyone with a basic understanding of Microsoft Excel 2007, 2010 or 2013 who would like to build upon their existing knowledge.

Image for Excel Advanced (2007, 2010 & 2013)
Excel Advanced (2007, 2010 & 2013)

Provides delegates with a solid understanding of advanced Excel 2007, 2010 or 2013 tools and concepts in order to increase their knowledge and productivity.
Who should attend: Users with a good understanding of Microsoft Excel 2007, 2010 or 2013 who need to develop their capabilities. Delegates should have a good working knowledge and understanding of the concepts taught in the Introduction and Intermediate courses.

Image for Excel Professional (2007, 2010 & 2013)
Excel Professional (2007, 2010 & 2013)

In this in-depth course, delegates will be provided with a very advanced set of tools and concepts for Microsoft Excel 2007, 2010 or 2013 which will further increase their knowledge and productivity.
Who should attend: People with a solid understanding of the concepts covered in the Introduction, Intermediate and Advanced Excel courses, who want to increase their knowledge and skills.

Image for Excel VBA Introduction (2007, 2010 & 2013)
Excel VBA Introduction (2007, 2010 & 2013)

This comprehensive course is designed to teach people the basics of how to use the Excel VBA programming language, become familiar with the concepts and methods of VBA programming, and be able to and understand the relevant techniques.
Who should attend: Existing, highly experienced users of Microsoft Excel 2007, 2010 or 2013 who need to use VBA to automate their spreadsheets. Ideally, learners need to be familiar with the content of either the Advanced or Professional course.

Image for Excel VBA Advanced (2007, 2010 & 2013)
Excel VBA Advanced (2007, 2010 & 2013)

This practical course has been designed to further develop the skills and knowledge learnt on the VBA Introduction course, to increase learners' capabilities to automate and enhance their Excel spreadsheets by the use of advanced tools and concepts.
Who should attend: This course follows on directly from the Excel VBA Introduction course. Learners must either have attended the Introduction course or be fully proficient in the all of the subject matter covered in the course.

Image for Excel Introduction (2003 & XP)
Excel Introduction (2003 & XP)

In this course newcomers will become proficient in how to use the main features of Microsoft Excel by creating and modifying spreadsheets.
Who should attend: New or intending users of Microsoft Excel 2003 or XP and would like to gain a good understanding of the software. No prior knowledge of Excel is needed but it basic IT skills are required.

Image for Excel Intermediate (2003 & XP)
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.
Who should attend: This course is suitable for those who have a basic understanding of Microsoft Excel 2003 or XP who would like to consolidate and expand upon their knowledge of the basic features.

Image for Excel Advanced (2003 & XP)
Excel Advanced (2003 & XP)

This course will enable delegates to create advanced spreadsheets by using the full range of tools and features of Microsoft Excel 2003.
Who should attend: Current users of Microsoft Excel 2003 or XP who want to learn how to use the advanced features of the software and become more efficient.

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 £169
•  Excel Introduction (2007, 2010 & 2013)
 
First delegate: £199
2nd delegate: £169
3rd delegate +: £149 each
•  Excel Intermediate (2007, 2010 & 2013)
 
First delegate: £199
2nd delegate: £169
3rd delegate +: £149 each
•  Excel Advanced (2007, 2010 & 2013)
 
First delegate: £199
2nd delegate: £169
3rd delegate +: £149 each
•  Excel Professional (2007, 2010 & 2013)
 
First delegate: £199
2nd delegate: £169
3rd delegate +: £149 each
•  Excel VBA Introduction (2007, 2010 & 2013)
 
First delegate: £249
2nd delegate: £199
3rd delegate +: £159 each
•  Excel VBA Advanced (2007, 2010 & 2013)
 
First delegate: £249
2nd delegate: £199
3rd delegate +: £159 each
•  Excel Introduction (2003 & XP)
 
First delegate: £249
2nd delegate: £199
3rd delegate +: £159 each
•  Excel Intermediate (2003 & XP)
 
First delegate: £249
2nd delegate: £199
3rd delegate +: £159 each
•  Excel Advanced (2003 & XP)
 
First delegate: £249
2nd delegate: £199
3rd delegate +: £159 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]

Dates and Venues  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 +/– ]
Aug 4, 2015
Slough
£199
Book Now
Aug 4, 2015
London Baker Street W1
£199
Book Now
Aug 4, 2015
Leeds
£199
Book Now
Aug 4, 2015
Reading Green Park
 
**Full**
Aug 11, 2015
Birmingham City Centre
£199
Book Now
Aug 11, 2015
Nottingham
£199
Book Now
Aug 11, 2015
Tower Bridge
£199
Book Now
Aug 17, 2015
Bristol
£199
Book Now
Aug 18, 2015
Manchester Princess Street
£199
Book Now
Aug 24, 2015
Slough
£199
Book Now
Aug 24, 2015
London Baker Street W1
£199
Book Now
Aug 25, 2015
Leeds
£199
Book Now
Aug 25, 2015
Milton Keynes
£199
Book Now
Aug 25, 2015
Reading Green Park
£199
Book Now
Sep 1, 2015
Nottingham
£199
Book Now
Sep 1, 2015
Birmingham City Centre
£199
Book Now
Sep 2, 2015
Tower Bridge
£199
Book Now
Sep 8, 2015
Manchester Princess Street
£199
Book Now
Sep 8, 2015
Bristol
£199
Book Now
Sep 15, 2015
Milton Keynes
£199
Book Now
Sep 15, 2015
Reading Green Park
£199
Book Now
Sep 15, 2015
Slough
£199
Book Now
Sep 15, 2015
Leeds
£199
Book Now
Sep 15, 2015
London Baker Street W1
£199
Book Now
Sep 22, 2015
Tower Bridge
£189
Book Now
Sep 22, 2015
Birmingham City Centre
£189
Book Now
Sep 22, 2015
Nottingham
£189
Book Now
Sep 29, 2015
Bristol
£189
Book Now
Sep 29, 2015
Manchester Princess Street
£189
Book Now
Oct 5, 2015
Reading Green Park
£179
Book Now
Oct 5, 2015
Milton Keynes
£179
Book Now
Oct 5, 2015
Leeds
£179
Book Now
Oct 6, 2015
Slough
£179
Book Now
Oct 6, 2015
London Baker Street W1
£179
Book Now
Oct 12, 2015
Tower Bridge
£179
Book Now
Oct 12, 2015
Birmingham City Centre
£179
Book Now
Oct 13, 2015
Nottingham
£179
Book Now
Oct 19, 2015
Bristol
£169
Book Now
Oct 19, 2015
Manchester Princess Street
£169
Book Now
Oct 26, 2015
Slough
£169
Book Now
Oct 27, 2015
Leeds
£169
Book Now
Oct 27, 2015
Milton Keynes
£169
Book Now
Oct 27, 2015
Reading Green Park
£169
Book Now
Oct 27, 2015
London Baker Street W1
£169
Book Now
Excel Intermediate (2007, 2010 & 2013)
[ Click to Show/Hide Dates +/– ]
Aug 5, 2015
Reading Green Park
£199
Book Now
Aug 5, 2015
Slough
£199
Book Now
Aug 5, 2015
London Baker Street W1
 
**Full**
Aug 5, 2015
Leeds
£199
Book Now
Aug 12, 2015
Birmingham City Centre
£199
Book Now
Aug 12, 2015
Nottingham
£199
Book Now
Aug 12, 2015
Tower Bridge
 
**Full**
Aug 18, 2015
Bristol
£199
Book Now
Aug 19, 2015
Manchester Princess Street
£199
Book Now
Aug 25, 2015
Slough
£199
Book Now
Aug 25, 2015
London Baker Street W1
 
**Full**
Aug 26, 2015
Reading Green Park
£199
Book Now
Aug 26, 2015
Leeds
£199
Book Now
Aug 26, 2015
Milton Keynes
£199
Book Now
Aug 27, 2015
London Baker Street W1
£199
Book Now
Sep 2, 2015
Birmingham City Centre
 
**Full**
Sep 2, 2015
Nottingham
£199
Book Now
Sep 3, 2015
Tower Bridge
£199
Book Now
Sep 9, 2015
Manchester Princess Street
£199
Book Now
Sep 9, 2015
Bristol
£199
Book Now
Sep 16, 2015
London Baker Street W1
£199
Book Now
Sep 16, 2015
Reading Green Park
£199
Book Now
Sep 16, 2015
Leeds
£199
Book Now
Sep 16, 2015
Milton Keynes
£199
Book Now
Sep 16, 2015
Slough
£199
Book Now
Sep 23, 2015
Tower Bridge
£189
Book Now
Sep 23, 2015
Birmingham City Centre
£189
Book Now
Sep 23, 2015
Nottingham
£189
Book Now
Sep 30, 2015
Manchester Princess Street
£189
Book Now
Sep 30, 2015
Bristol
£189
Book Now
Oct 6, 2015
Reading Green Park
£179
Book Now
Oct 6, 2015
Leeds
£179
Book Now
Oct 6, 2015
Milton Keynes
£179
Book Now
Oct 7, 2015
London Baker Street W1
£179
Book Now
Oct 7, 2015
Slough
£179
Book Now
Oct 13, 2015
Birmingham City Centre
£179
Book Now
Oct 13, 2015
Tower Bridge
£179
Book Now
Oct 14, 2015
Nottingham
£179
Book Now
Oct 20, 2015
Bristol
£169
Book Now
Oct 20, 2015
Manchester Princess Street
£169
Book Now
Oct 27, 2015
Slough
£169
Book Now
Oct 28, 2015
Milton Keynes
£169
Book Now
Oct 28, 2015
Reading Green Park
£169
Book Now
Oct 28, 2015
Leeds
£169
Book Now
Oct 28, 2015
London Baker Street W1
£169
Book Now
Excel Advanced (2007, 2010 & 2013)
[ Click to Show/Hide Dates +/– ]
Aug 6, 2015
Reading Green Park
 
**Full**
Aug 6, 2015
Leeds
£199
Book Now
Aug 13, 2015
Tower Bridge
£199
Book Now
Aug 13, 2015
Birmingham City Centre
 
**Full**
Aug 19, 2015
Bristol
£199
Book Now
Aug 19, 2015
Tower Bridge
 
**Full**
Aug 20, 2015
Manchester Princess Street
£199
Book Now
Aug 26, 2015
Slough
£199
Book Now
Aug 26, 2015
London Baker Street W1
£199
Book Now
Sep 3, 2015
Nottingham
£199
Book Now
Sep 17, 2015
Milton Keynes
£189
Book Now
Sep 17, 2015
Reading Green Park
£189
Book Now
Sep 17, 2015
Leeds
£189
Book Now
Sep 24, 2015
Tower Bridge
£189
Book Now
Sep 24, 2015
Birmingham City Centre
£189
Book Now
Oct 1, 2015
Manchester Princess Street
£189
Book Now
Oct 1, 2015
Bristol
£189
Book Now
Oct 8, 2015
Slough
£179
Book Now
Oct 8, 2015
London Baker Street W1
£179
Book Now
Oct 15, 2015
Nottingham
£179
Book Now
Oct 29, 2015
Reading Green Park
£169
Book Now
Oct 29, 2015
Milton Keynes
£169
Book Now
Oct 29, 2015
Leeds
£169
Book Now
Excel Professional (2007, 2010 & 2013)
[ Click to Show/Hide Dates +/– ]
Aug 7, 2015
Reading Green Park
£199
Book Now
Aug 7, 2015
Leeds
£199
Book Now
Aug 14, 2015
Tower Bridge
£199
Book Now
Aug 14, 2015
Birmingham City Centre
£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
Sep 3, 2015
London Baker Street W1
£199
Book Now
Sep 4, 2015
Nottingham
£199
Book Now
Sep 18, 2015
Reading Green Park
£189
Book Now
Sep 18, 2015
Leeds
£189
Book Now
Sep 18, 2015
Milton Keynes
£189
Book Now
Sep 25, 2015
Tower Bridge
£189
Book Now
Sep 25, 2015
Birmingham City Centre
£189
Book Now
Oct 2, 2015
Manchester Princess Street
£179
Book Now
Oct 2, 2015
Bristol
£179
Book Now
Oct 9, 2015
Slough
£179
Book Now
Oct 9, 2015
London Baker Street W1
£179
Book Now
Oct 16, 2015
Nottingham
£179
Book Now
Oct 30, 2015
Leeds
£169
Book Now
Oct 30, 2015
Reading Green Park
£169
Book Now
Oct 30, 2015
Milton Keynes
£169
Book Now
Excel VBA Introduction (2007, 2010 & 2013)
[ Click to Show/Hide Dates +/– ]
Aug 6, 2015
Bristol
 
**Full**
Aug 13, 2015
Slough
£249
Book Now
Aug 20, 2015
Nottingham
£249
Book Now
Aug 28, 2015
Milton Keynes
£249
Book Now
Aug 28, 2015
Reading Green Park
£249
Book Now
Sep 1, 2015
Leeds
£249
Book Now
Sep 10, 2015
Birmingham City Centre
£249
Book Now
Sep 14, 2015
Bristol
£249
Book Now
Sep 21, 2015
Slough
£239
Book Now
Sep 24, 2015
London Baker Street W1
£239
Book Now
Sep 28, 2015
Nottingham
£239
Book Now
Oct 12, 2015
Reading Green Park
£229
Book Now
Oct 15, 2015
Leeds
£229
Book Now
Oct 15, 2015
Milton Keynes
£229
Book Now
Oct 19, 2015
Birmingham City Centre
£219
Book Now
Oct 19, 2015
Tower Bridge
£219
Book Now
Oct 26, 2015
Manchester Princess Street
£219
Book Now
Oct 29, 2015
Bristol
£219
Book Now
Excel VBA Advanced (2007, 2010 & 2013)
[ Click to Show/Hide Dates +/– ]
Aug 6, 2015
Manchester Princess Street
 
**Full**
Aug 7, 2015
Bristol
 
**Full**
Aug 14, 2015
Slough
£249
Book Now
Aug 21, 2015
Nottingham
£249
Book Now
Sep 1, 2015
Reading Green Park
£249
Book Now
Sep 1, 2015
Milton Keynes
£249
Book Now
Sep 2, 2015
Leeds
£249
Book Now
Sep 11, 2015
Birmingham City Centre
£249
Book Now
Sep 15, 2015
Bristol
£249
Book Now
Sep 22, 2015
Slough
£239
Book Now
Sep 25, 2015
London Baker Street W1
£239
Book Now
Sep 29, 2015
Nottingham
£239
Book Now
Oct 13, 2015
Reading Green Park
£229
Book Now
Oct 16, 2015
Milton Keynes
£229
Book Now
Oct 16, 2015
Leeds
£229
Book Now
Oct 20, 2015
Birmingham City Centre
£219
Book Now
Oct 20, 2015
Tower Bridge
£219
Book Now
Oct 27, 2015
Manchester Princess Street
£219
Book Now
Oct 30, 2015
Bristol
£219
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 +/– ]
Aug 3, 2015
Tower Bridge
 
**Full**
Aug 3, 2015
Birmingham City Centre
 
**Full**
Aug 4, 2015
Milton Keynes
£249
Book Now
Aug 10, 2015
Bristol
 
**Full**
Aug 10, 2015
Manchester Princess Street
 
**Full**
Aug 17, 2015
London Baker Street W1
£249
Book Now
Aug 17, 2015
Slough
£249
Book Now
Aug 24, 2015
Nottingham
£249
Book Now
Sep 7, 2015
Leeds
£249
Book Now
Sep 7, 2015
Milton Keynes
£249
Book Now
Sep 7, 2015
Reading Green Park
£249
Book Now
Sep 14, 2015
Birmingham City Centre
£249
Book Now
Sep 14, 2015
Tower Bridge
£249
Book Now
Sep 21, 2015
Bristol
£239
Book Now
Sep 21, 2015
Manchester Princess Street
£239
Book Now
Sep 28, 2015
London Baker Street W1
£239
Book Now
Sep 28, 2015
Slough
£239
Book Now
Oct 5, 2015
Nottingham
£229
Book Now
Oct 19, 2015
Milton Keynes
£219
Book Now
Oct 19, 2015
Leeds
£219
Book Now
Oct 19, 2015
Reading Green Park
£219
Book Now
Oct 26, 2015
Tower Bridge
£219
Book Now
Oct 26, 2015
Birmingham City Centre
£219
Book Now
Excel Intermediate (2003 & XP)
[ Click to Show/Hide Dates +/– ]
Aug 4, 2015
Birmingham City Centre
 
**Full**
Aug 4, 2015
Tower Bridge
 
**Full**
Aug 5, 2015
Milton Keynes
 
**Full**
Aug 11, 2015
Manchester Princess Street
£249
Book Now
Aug 11, 2015
Bristol
£249
Book Now
Aug 18, 2015
London Baker Street W1
£249
Book Now
Aug 18, 2015
Slough
£249
Book Now
Aug 25, 2015
Nottingham
£249
Book Now
Sep 8, 2015
Milton Keynes
£249
Book Now
Sep 8, 2015
Leeds
£249
Book Now
Sep 8, 2015
Reading Green Park
£249
Book Now
Sep 15, 2015
Birmingham City Centre
£249
Book Now
Sep 15, 2015
Tower Bridge
£249
Book Now
Sep 22, 2015
Manchester Princess Street
£239
Book Now
Sep 22, 2015
Bristol
£239
Book Now
Sep 29, 2015
Slough
£239
Book Now
Sep 29, 2015
London Baker Street W1
£239
Book Now
Oct 6, 2015
Nottingham
£229
Book Now
Oct 20, 2015
Milton Keynes
£219
Book Now
Oct 20, 2015
Leeds
£219
Book Now
Oct 20, 2015
Reading Green Park
£219
Book Now
Oct 27, 2015
Birmingham City Centre
£219
Book Now
Oct 27, 2015
Tower Bridge
£219
Book Now
Excel Advanced (2003 & XP)
[ Click to Show/Hide Dates +/– ]
Aug 5, 2015
Birmingham City Centre
 
**Full**
Aug 5, 2015
Tower Bridge
 
**Full**
Aug 6, 2015
Milton Keynes
 
**Full**
Aug 12, 2015
Bristol
£249
Book Now
Aug 12, 2015
Manchester Princess Street
£249
Book Now
Aug 19, 2015
London Baker Street W1
£249
Book Now
Aug 19, 2015
Slough
£249
Book Now
Aug 26, 2015
Nottingham
£249
Book Now
Sep 9, 2015
Reading Green Park
£249
Book Now
Sep 9, 2015
Milton Keynes
£249
Book Now
Sep 9, 2015
Leeds
£249
Book Now
Sep 16, 2015
Tower Bridge
£249
Book Now
Sep 16, 2015
Birmingham City Centre
£249
Book Now
Sep 23, 2015
Bristol
£239
Book Now
Sep 23, 2015
Manchester Princess Street
£239
Book Now
Sep 30, 2015
Slough
£239
Book Now
Sep 30, 2015
London Baker Street W1
£239
Book Now
Oct 7, 2015
Nottingham
£229
Book Now
Oct 21, 2015
Leeds
£219
Book Now
Oct 21, 2015
Reading Green Park
£219
Book Now
Oct 21, 2015
Milton Keynes
£219
Book Now
Oct 28, 2015
Tower Bridge
£219
Book Now
Oct 28, 2015
Birmingham City Centre
£219
Book Now
Need another date or location ?   Click to schedule your own class from £299.
Quick Links Icon for Training courses for Excel 2003 to 2013
Quick Links
[Click the blue arrow icon to view]
Show links to information and tools
Information and tools
Show links to information and tools
Course outlines
Show links to information and tools
You may also like ...
Contact details
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  

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

Activia Training logo

We can provide courses for training in Excel at any of our ten 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.

Activia Training logo
Quality Assurance
Quality assurance from Activia Training
 
Privacy Policy     |     Terms & Conditions     |     News     |     Blog     |     Course Finder