Subscribe for access to this FREE e-learning mini-course!


Your First Name:


Your Surname:


Your Email Address:



Subscribe
Close


Small logo
Hamburger sub menu
More
Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           
Excel Training at Competitive Prices
Excel Training at Competitive Prices
Search

PRICES FOR MICROSOFT EXCEL TRAINING

Excel Training Courses to suit your budget

Interactive hands-on courses for users of Microsoft Excel – great prices with flexibility and friendly helpful service included
Please note: all prices exclude VAT
E-Learning

A great option if your time and/or budget are limited.

Standard e-learning pack
A1 PACK - Standard e-learning pack
Videos with transcripts and tests to earn your diploma
Enhanced pack with downloads
A2 PACK - Enhanced pack with downloads
Standard pack PLUS downloadable workbook & exercises
Save money with our e-learning package bundles!
You have chosen to add the following pack to your cart at a cost of £:
.
You may like to know that this course also comes bundled in the Multi-Packs below which, and as you'd expect, allows you to buy several courses at a substantial discount to the standard prices.

Full Excel Multi-Pack: Includes Intro, Intermediate, Advanced & Professional courses
Choose your preference:
  • Add to cart - D1 MULTI-PACK: Standard e-learning multi-pack - £45 (SAVE £31)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack with downloads - £69 (SAVE £47)

MS Office Regular Multi-Pack: Includes all Excel, Word, Powerpoint & Outlook courses
Choose your preference:
  • Add to cart - D1 MULTI-PACK: Standard e-learning multi-pack - £89 (SAVE £101)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack with downloads - £129 (SAVE £161)

MS Office Plus Multi-Pack: Includes all Excel, Word, Powerpoint, Outlook & Access courses
Choose your preference:
  • Add to cart - D1 MULTI-PACK: Standard e-learning multi-pack - £119 (SAVE £146)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack with downloads - £165 (SAVE £230)

  • No thank you, just add the single-course pack to my shopping cart

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

Excel Introduction   
[Click for course outline]
E-learning A1 Pack
A1 PACK - £19
Click to BUY
E-learning A2 Pack
A2 PACK - £29
Click to BUY
Save money with our e-learning package bundles!
You have chosen to add the following pack to your cart at a cost of £:
.
You may like to know that this course also comes bundled in the Multi-Packs below which, and as you'd expect, allows you to buy several courses at a substantial discount to the standard prices.

Full Excel Multi-Pack: Includes Intro, Intermediate, Advanced & Professional courses
Choose your preference:
  • Add to cart - D1 MULTI-PACK: Standard e-learning multi-pack - £45 (SAVE £31)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack with downloads - £69 (SAVE £47)

MS Office Regular Multi-Pack: Includes all Excel, Word, Powerpoint & Outlook courses
Choose your preference:
  • Add to cart - D1 MULTI-PACK: Standard e-learning multi-pack - £89 (SAVE £101)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack with downloads - £129 (SAVE £161)

MS Office Plus Multi-Pack: Includes all Excel, Word, Powerpoint, Outlook & Access courses
Choose your preference:
  • Add to cart - D1 MULTI-PACK: Standard e-learning multi-pack - £119 (SAVE £146)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack with downloads - £165 (SAVE £230)

  • No thank you, just add the single-course pack to my shopping cart

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

Excel Intermediate   
[Click for course outline]
E-learning A1 Pack
A1 PACK - £19
Click to BUY
E-learning A2 Pack
A2 PACK - £29
Click to BUY
Save money with our e-learning package bundles!
You have chosen to add the following pack to your cart at a cost of £:
.
You may like to know that this course also comes bundled in the Multi-Packs below which, and as you'd expect, allows you to buy several courses at a substantial discount to the standard prices.

Full Excel Multi-Pack: Includes Intro, Intermediate, Advanced & Professional courses
Choose your preference:
  • Add to cart - D1 MULTI-PACK: Standard e-learning multi-pack - £45 (SAVE £31)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack with downloads - £69 (SAVE £47)

MS Office Regular Multi-Pack: Includes all Excel, Word, Powerpoint & Outlook courses
Choose your preference:
  • Add to cart - D1 MULTI-PACK: Standard e-learning multi-pack - £89 (SAVE £101)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack with downloads - £129 (SAVE £161)

MS Office Plus Multi-Pack: Includes all Excel, Word, Powerpoint, Outlook & Access courses
Choose your preference:
  • Add to cart - D1 MULTI-PACK: Standard e-learning multi-pack - £119 (SAVE £146)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack with downloads - £165 (SAVE £230)

  • No thank you, just add the single-course pack to my shopping cart

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

Excel Advanced   
[Click for course outline]
E-learning A1 Pack
A1 PACK - £19
Click to BUY
E-learning A2 Pack
A2 PACK - £29
Click to BUY
Save money with our e-learning package bundles!
You have chosen to add the following pack to your cart at a cost of £:
.
You may like to know that this course also comes bundled in the Multi-Packs below which, and as you'd expect, allows you to buy several courses at a substantial discount to the standard prices.

Full Excel Multi-Pack: Includes Intro, Intermediate, Advanced & Professional courses
Choose your preference:
  • Add to cart - D1 MULTI-PACK: Standard e-learning multi-pack - £45 (SAVE £31)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack with downloads - £69 (SAVE £47)

MS Office Regular Multi-Pack: Includes all Excel, Word, Powerpoint & Outlook courses
Choose your preference:
  • Add to cart - D1 MULTI-PACK: Standard e-learning multi-pack - £89 (SAVE £101)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack with downloads - £129 (SAVE £161)

MS Office Plus Multi-Pack: Includes all Excel, Word, Powerpoint, Outlook & Access courses
Choose your preference:
  • Add to cart - D1 MULTI-PACK: Standard e-learning multi-pack - £119 (SAVE £146)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack with downloads - £165 (SAVE £230)

  • No thank you, just add the single-course pack to my shopping cart

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

Excel Professional   
[Click for course outline]
E-learning A1 Pack
A1 PACK - £19
Click to BUY
E-learning A2 Pack
A2 PACK - £29
Click to BUY
Save money with our e-learning Multi-Packs
Full Excel Multi-Pack

Includes Intro, Intermediate, Advanced & Professional courses

E-learning revision
D1 MULTI-PACK: £45
(Save £31)

Click to BUY
E-learning revision
D2 MULTI-PACK: £69
(Save £47)

Click to BUY


MS Office Regular Multi-Pack

Includes all Excel, Word, Powerpoint & Outlook courses

E-learning revision
D1 MULTI-PACK: £89
(Save £101)

Click to BUY
E-learning revision
D2 MULTI-PACK: £129
(Save £161)

Click to BUY


MS Office Plus Multi-Pack

Includes all Excel, Word, Powerpoint, Outlook & Access courses

E-learning revision
D1 MULTI-PACK: £119
(Save £146)

Click to BUY
E-learning revision
D2 MULTI-PACK: £165
(Save £230)

Click to BUY



NOTES:
Licenses for e-learning allow up to 40 sessions for each module on one PC in any 12-month period.
But once purchased and accessed, no refund can be given.
Due to screen resolution requirements, they are not suitable for mobile devices.

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

Scheduled Public Classes

The simplest and most cost-effective option for 1, 2 or 3 delegates.

  • For scheduled public classes, prices start at £199
  • For multiple delegates, prices can be as low as £139
  • If you book in advance, Early Bird prices start at just £169
  • If a course is not scheduled, you can usually Schedule Your Own from £199

NOTES:
Lower prices for additional delegates are subject to booking at the same time.
Bookings made at discounted prices cannot be cancelled.

To view course dates or book a place please click here.

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

Training At Your Offices

A convenient and very cost-effective option for groups of delegates

  • Onsite training is available from just £449
    [NOTE: small additional charges apply per delegate]

Notes:
For delivery of training over more than one day, make sure to multiply the full day rate by the number of days to get the total cost.

We can also deliver "Private" (or "Closed") courses for you at one of our centres from £499
[NOTE: small additional charges apply per delegate].

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


Click for more about Microsoft Excel training

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 PRICES

We are here you help you improve your skills with Microsoft Excel spreadsheet training with a UK wide network of twelve centres, as well as the ability to come to your offices: for groups of three or more staff, this is a very convenient, flexible and cost effective option for training. All our excel courses are 1 day, and this keeps "out of office" periods for delegates at a minimum.

Be sure that we have the expertise, the experience and the dedication to provide the best return on your investment in Microsoft Excel Training.   Since our formation in 1995, we have been delivering Microsoft Excel training across the UK, continually developing our quality, flexibity and effectiveness in supplying Courses for Training in Excel from Activia which has ensured continually improving standards.

Please contact us today to see how we can assist you with courses for training in 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