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


Your First Name:


Your Surname:


Your Email Address:



Subscribe
Close


Small logo
Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           

Quick Links

Click to view prices and options,
and book or buy your training

Need to know more? We're happy to help

Click for more about

What you get with Activia:
  • Training businesses & people since 1995
  • Quality assured with ISO9001, ILM
    and CPD accreditation
  • Fiercely competitive pricing
  • Small class sizes
  • Friendly, attentive staff for flexible,
    helpful service
  • Classes are never cancelled

Click for more information on
Microsoft Excel training

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.

Diploma course
A1 PACK - Diploma course
Videos with transcripts and tests to earn your diploma
Enhanced course
A2 PACK - Enhanced course
Full Diploma course 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 :
.
Click to  Add to cart
NOTE: 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 big discounts from the standard prices.

Full Excel Multi-Pack: Includes Intro, Intermediate, Advanced & Professional courses
  • Add to cart - D1 MULTI-PACK: Diploma multi-pack - $67 (SAVE $55)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack - $93 (SAVE $76)

MS Office Regular Multi-Pack: Includes all Excel, Word, Powerpoint & Outlook courses
  • Add to cart - D1 MULTI-PACK: Diploma multi-pack - $151 (SAVE $151)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack - $223 (SAVE $199)

MS Office Plus Multi-Pack: Includes all Excel, Word, Powerpoint, Outlook & Access courses
  • Add to cart - D1 MULTI-PACK: Diploma multi-pack - $187 (SAVE $241)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack - $273 (SAVE $309)

  • 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

Identify and Use Cells, Columns, Rows, Workbooks to enter and manage data.
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  (RRP $119)
SPECIAL $31  (Save $89)
Click to BUY
E-learning A2 Pack
A2 PACK  (RRP $155)
SPECIAL $43  (Save $113)
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 :
.
Click to  Add to cart
NOTE: 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 big discounts from the standard prices.

Full Excel Multi-Pack: Includes Intro, Intermediate, Advanced & Professional courses
  • Add to cart - D1 MULTI-PACK: Diploma multi-pack - $67 (SAVE $55)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack - $93 (SAVE $76)

MS Office Regular Multi-Pack: Includes all Excel, Word, Powerpoint & Outlook courses
  • Add to cart - D1 MULTI-PACK: Diploma multi-pack - $151 (SAVE $151)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack - $223 (SAVE $199)

MS Office Plus Multi-Pack: Includes all Excel, Word, Powerpoint, Outlook & Access courses
  • Add to cart - D1 MULTI-PACK: Diploma multi-pack - $187 (SAVE $241)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack - $273 (SAVE $309)

  • 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  (RRP $119)
SPECIAL $31  (Save $89)
Click to BUY
E-learning A2 Pack
A2 PACK  (RRP $155)
SPECIAL $43  (Save $113)
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 :
.
Click to  Add to cart
NOTE: 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 big discounts from the standard prices.

Full Excel Multi-Pack: Includes Intro, Intermediate, Advanced & Professional courses
  • Add to cart - D1 MULTI-PACK: Diploma multi-pack - $67 (SAVE $55)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack - $93 (SAVE $76)

MS Office Regular Multi-Pack: Includes all Excel, Word, Powerpoint & Outlook courses
  • Add to cart - D1 MULTI-PACK: Diploma multi-pack - $151 (SAVE $151)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack - $223 (SAVE $199)

MS Office Plus Multi-Pack: Includes all Excel, Word, Powerpoint, Outlook & Access courses
  • Add to cart - D1 MULTI-PACK: Diploma multi-pack - $187 (SAVE $241)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack - $273 (SAVE $309)

  • 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  (RRP $119)
SPECIAL $31  (Save $89)
Click to BUY
E-learning A2 Pack
A2 PACK  (RRP $155)
SPECIAL $43  (Save $113)
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 :
.
Click to  Add to cart
NOTE: 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 big discounts from the standard prices.

Full Excel Multi-Pack: Includes Intro, Intermediate, Advanced & Professional courses
  • Add to cart - D1 MULTI-PACK: Diploma multi-pack - $67 (SAVE $55)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack - $93 (SAVE $76)

MS Office Regular Multi-Pack: Includes all Excel, Word, Powerpoint & Outlook courses
  • Add to cart - D1 MULTI-PACK: Diploma multi-pack - $151 (SAVE $151)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack - $223 (SAVE $199)

MS Office Plus Multi-Pack: Includes all Excel, Word, Powerpoint, Outlook & Access courses
  • Add to cart - D1 MULTI-PACK: Diploma multi-pack - $187 (SAVE $241)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack - $273 (SAVE $309)

  • 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  (RRP $119)
SPECIAL $31  (Save $89)
Click to BUY
E-learning A2 Pack
A2 PACK  (RRP $155)
SPECIAL $43  (Save $113)
Click to BUY
Save money with our e-learning Multi-Packs
Full Excel Multi-Pack

Includes Intro, Intermediate, Advanced & Professional courses

Online Multi Pack D1
D1 MULTI-PACK  (RRP $335)
SPECIAL $67  (Save $269)
Click to BUY
Online Multi Pack D2
D2 MULTI-PACK  (RRP $407)
SPECIAL $93  (Save $315)
Click to BUY


MS Office Regular Multi-Pack

Includes all Excel, Word, Powerpoint & Outlook courses

Online Multi Pack D1
D1 MULTI-PACK  (RRP $839)
SPECIAL $151  (Save $689)
Click to BUY
Online Multi Pack D2
D2 MULTI-PACK  (RRP $995)
SPECIAL $223  (Save $773)
Click to BUY


MS Office Plus Multi-Pack

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

Online Multi Pack D1
D1 MULTI-PACK  (RRP $1,055)
SPECIAL $187  (Save $869)
Click to BUY
Online Multi Pack D2
D2 MULTI-PACK  (RRP $1,247)
SPECIAL $273  (Save $975)
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 £149
  • If you book in advance, Early Bird prices start at just £159
  • 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



Back to top
Site Cookies
We have placed cookies on your device to help make this website better.

You can change your cookie settings in your browser. Otherwise, we’ll assume you’re OK to continue.

I'm fine with this