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


Your First Name:


Your Surname:


Your Email Address:



Subscribe
Close


Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           
Microsoft Excel Intermediate
Microsoft Excel Intermediate
 

EXCEL INTERMEDIATE

The best source of Intermediate Excel Training

A hands-on one-day course with free e-learning revision after your training and pre-course online skills testing. Free bespoke course design is also available for private classes if the content needs to be adjusted
See Our Latest Reviews on TrustPilot:
Activia Training Silver Jubilee - training since 1995

Our SILVER JUBILEE OFFER
Prices you'll not see anywhere else!

Training vouchers

Prices cut by up to 30%

Scheduled Public Classes: Additional delegates for just £99

Training at Your Offices: Prices from £299

Training Vouchers: Prices for block tickets from £725

Click the orange "Book Your Training" button on the right of the page, and see how much you can save ... but remember: these prices won't last for ever!



CPD CERTIFIED COURSE
CPD accredited course

Note: this Excel Intermediate course is CPD certified.
It is available as either a classroom course with online revision, or an online course.
This means that not only has it been rigorously assessed in terms of content and quality, but it comes with a FREE CPD Certification certificate, as well as an Activia diploma of completion.
We are a corporate member of the CPD: the highest level of association available.

COURSE OUTLINE

Full details of modules and topics covered in this one-day course

VERSIONS COVERED

This course covers 2010, 2013, 2016 and Office 365 versions

Blended learning
FREE E-LEARNING REVISION

Note: Free e-learning revision is available with this course: 12 months of access for each delegate on scheduled public (open) classes and standard on-site/private classes (not available for bespoke courses) .

DURATION

This is a one-day training course structured into 7 modules

COURSE AIMS

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, 2013 or 2016, in order to increase their knowledge and productivity.

TARGET AUDIENCE

Users with a basic understanding of Microsoft Excel 2007, 2010, 2013 or 2016 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.

Want to see prices and options for delivery of your training?

MODULE 1:  Advanced File Tasks
Learning outcomes:
A look at some important administrative features which are useful for managing and controlling Excel files.
Topics covered:
  • Saving and File Management
  • Converting and Encrypting Files
  • File Properties and Digital Signatures
  • File Accessibility and Compatibility
MODULE 2:  Working with Functions and Formulas
Learning outcomes:
Some key formulas and functions essential to Excel users along with features to help manage formulas, functions and ranges.
Topics covered:
  • 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
Learning outcomes:
Managing spreadsheet data in table format, an excellent feature to administrate large sets of data.
Topics covered:
  • Creating Excel Tables
  • Working with Records and Filters
  • Advanced Filters
MODULE 4:  Data Tools in Excel
Learning outcomes:
Features to help with managing spreadsheet data making it a less daunting and repetitive task to manage the data.
Topics covered:
  • Text to Columns
  • Flash Fill
  • Remove Duplicates
  • Data Validation
  • Consolidate
MODULE 5:  Doing More with Charts in Excel
Learning outcomes:
Developing your ability to effectively create charts and format them specific to the reader
Topics covered:
  • Trendlines
  • Error Bars
  • Working with Axis Options
  • Advanced Chart Formatting
MODULE 6:  Sparklines
Learning outcomes:
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
Topics covered:
  • Creating Sparklines
  • Editing Sparklines
MODULE 7:  Excel Styles and Themes
Topics covered:
  • Working with Themes
  • Creating Custom Styles
  • Applying Cell Styles

Want to see prices and options for delivery of your training?

NEXT CLASS DATES
Microsoft Excel Intermediate
Apr 22, 2020
Leeds West One
£199
Book Now
Apr 23, 2020
Manchester Piccadilly
£199
Book Now
Apr 28, 2020
Tower Bridge
£199
Book Now
Apr 29, 2020
Birmingham Queensway
£199
Book Now
May 6, 2020
Bristol Easton BS5
£199
Book Now
May 11, 2020
London Victoria
£199
Book Now

Don't see a date you want?

RELATED COURSES

Microsoft Excel Introduction

COURSE OUTLINE
[Duration: one day]

Excel Introduction

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

Microsoft Excel Advanced

COURSE OUTLINE
[Duration: one day]

Excel Advanced

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

Microsoft Excel Professional

COURSE OUTLINE
[Duration: one day]

Excel Professional

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

Microsoft Excel VBA Introduction

COURSE OUTLINE
[Duration: one day]

Excel VBA Introduction

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

Microsoft Excel VBA Advanced

COURSE OUTLINE
[Duration: one day]

Excel VBA Advanced

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

Microsoft Excel Dashboards

COURSE OUTLINE
[Duration: one day]

Excel Dashboards

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


Excel Business Intelligence (BI)

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

Microsoft Excel for Accounting: Introduction

COURSE OUTLINE
[Duration: one day]

Excel for Accounting: Introduction

  • Working with Functions and Formulas
  • Outlining, Grouping and Sub Totals
  • Protecting Your Spreadsheet
  • Presenting Data with Charts
  • Formatting Financial Data
  • Data Tools: Managing Your Data
  • Formula Auditing
  • LOOKUP Functions

Microsoft Excel for Accounting: Advanced

COURSE OUTLINE
[Duration: one day]

Excel for Accounting: Advanced

  • Logical and Error Functions
  • WhatIf Analysis & Financial Modelling
  • Specialist Financial Functions
  • Using Pivot Tables
  • More About Charts
  • Introduction to Macros
  • Advanced LOOKUP Functions
  • Advanced PivotTable Tools

Microsoft Excel for Accounting Fast Track

COURSE OUTLINE
[Duration: one day]

Excel for Accounting Fast Track

  • Formatting Financial Data
  • Data Tools: Managing Your Data
  • Formula Auditing
  • LOOKUP Functions
  • Logical and Error Functions
  • WhatIf Analysis & Financial Modelling
  • Specialist Financial Functions
  • Using Pivot Tables

DELEGATE FEEDBACK FOR OUR
MICROSOFT EXCEL INTERMEDIATE COURSE

AVERAGE REVIEW: 4.8 out of 5  BASED ON 712 REVIEWS

Adam Bracegirdle
, Jan 30 2020
"Excellent course led by an excellent trainer. All-in-all it far exceeded my expectations and was one of the most enjoyable training courses I've ever attended."


 
Course rating of 5 stars
Sarah Trendall
, Jan 30 2020
"Was very impressed with this training - would definitely recommend to others."


 
Course rating of 5 stars
Amy FRANKLIN
, Jan 29 2020
"Great trainer, decent venue/location, have booked onto another!"


 
Course rating of 5 stars
David Sharp
, Jan 27 2020
"Faultless training by Daren at an appropriate fast pace for the amount of material covered. Glad we were able to cover so much in one day. Also lots of useful relevant tips from the instructor that wasn't in the manual. Liked the classroom size. And the introdructions were good idea so we felt more comfortable helping each other. Everyone kept up. Tower Hill good location and facilities."


 
Course rating of 5 stars
Sian Egdell
, Jul 18 2019
"Great teacher very knowlegable "


 
Course rating of 5 stars
Stacey Taylor
, Jul 17 2019
"Trainer was friendly and energetic and very knowledgable."


 
Course rating of 5 stars
Alice Plunkett
, Jul 17 2019
"The course was very useful and informative. Steve was lovely, and clearly had a huge depth of knowledge. His ability to teach everyone with different objectives, and keep the course interesting was very good."


 
Course rating of 5 stars
Samantha Matthews
, Jun 25 2019
"Enjoyed the course. Jamie was very easy to understand and I came away with lots of helpful material he had created"


 
Course rating of 4 stars
Jazmin Francis
, Jun 18 2019
"Steve was great! Asset to the company! "


 
Course rating of 5 stars
Natasha Gajadhar
, Jun 11 2019
"Really enjoyed the course our trainer was brilliant! "


 
Course rating of 5 stars

MORE INFORMATION FOR
MICROSOFT EXCEL INTERMEDIATE

Blended learning
FREE Online Revision

With our latest Microsoft Excel courses, you get free online revision for a full 12 months after your class so you can reinforce the knowledge you have gained.

Access is simple: go to www.activia.co.uk/login/ and log in using your email address.   This will give you free access to our e-learning revision modules.

Note: These have been developed and written exclusively by Activia to maximise effectiveness, by matching the online content exactly to what you cover in class.   We hope you have fun, on the day of the course and with honing your knowledge afterwards!

General Information

All Activia intermediate excel training has been created, reviewed and developed to ensure up to date provision and constantly improving standards of content. Our Microsoft Excel training is interactive and classroom-based which maximises learning through the ability to ask questions and discuss specific issues.

Class Sizes

Maximum class size for Microsoft Excel courses is 8 delegates, which ensures that attendees get adequate time for personal attention from the instructor. At some of our centres, the maximum class size is 6 delegates.

Note that we never cancel our scheduled classes -- even if there are only one or two delegates -- so once you have booked, your place is assured.

Larger Class Sizes for Excel Intermediate

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

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

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

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

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

How to book
Course, dates and delegate numbers
Decide on the Microsoft Excel course you want, the date(s) you can attend, and the number of delegates involved
Training location
Also decide whether you want training at your offices or at one of our centres
Speedy course booking
You can use the Speedy Quote option to contact us for a quick price, or you can book online from the schedule on this website
Call us
if at any time you want help or advice, or you want to book on the telephone, just call us on 0333 6000 111 to speak to one of our friendly training advisors

Note: With non-credit card bookings you must sign and return a Booking Form before we can confirm your training.

Also note: If you are a private individual you must pay by credit card at the time of booking.

The confirmation process
Course places allocated
Your place is allocated, along with the trainer, workbooks and exercise files if appropriate
Booking confirmation
You receive an official confirmation, with joining instructions (and directions if it's at our centre)
Training invoice
You receive a VAT invoice

Note: Please allow 1 - 2 working days for your confirmation and invoice.

What happens on the day

If you are coming to our centre, dress code is smart casual.   Refreshments in the form of tea/coffee will be provided for morning and afternoon breaks, but please note that we do not provide lunch.   The timetable is as follows:

9:15

ARRIVAL TIME

9:30

TRAINING STARTS

11:00

MID-MORNING BREAK



1:00

ONE HOUR LUNCH BREAK

3:15

MID-AFTERNOON BREAK

4:30

WRAP UP

Note: break times can vary according to the needs of the training, and course duration for smaller class sizes are usually shorter because fewer delegates have fewer questions !

For training at your offices, this itinerary can be varied by prior arrangement.

What you get

With every Microsoft Excel training course with Activia, you get a free workbook as well as downloadable exercises, which match the course content exactly, so you can review and revise afterwards to reinforce your knowledge. With all courses, you are also given 12 months access to free online revision which will further help you to reinforce the lessons you have learned.

Every delegate on a Microsoft Excel course also gets an Activia Training Attendance Certificate.



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
Information & Resources
Special Offers
Information Updates
About Activia
Admin Tools
Cloud Tools
Development Tests
Quality Assurance

[NOTE: Mouse over the titles above,
then to visit the website pages you want,
click on the links in the right hand panel]
About Activia Training
Silver Jubilee training offers
To celebrate our 25 years in business, we're offering prices you won't see anywhere else:
  • Prices cut by up to 30%
  • Scheduled Public Classes: Extra delegates for just £99
  • Training at Your Offices: Prices from £299
  • Training Vouchers: Prices for block tickets from £725
e-Directory
Training e-directory
More than a brochure
Download on to a PC or Mac and
reference whenever you like
Newsletter
Activia newsletter
Stay In Touch
Don't miss out on out latest courses,
resources and special offers
Training Vouchers
Training vouchers
The Smart Way to Organise Training
Activia's Training Vouchers allow you to purchase
your training in advance at big discounts
Useful Information
Useful information
What Would You Like to Know?
Information about how we work, and think,
what we provide and the resources we offer
Download Your Certificate
Get your course certificate
Sent Straight to Your Inbox

Download your Activia certificate: just enter a few details
GateWay Login
Training GateWay
Your Complete Learning Management System
Schedule and manage company-wide training requirements
E-Learning Dashboard
Online dashboard
Log in and Get Started

View and manage your online courses
and videos
Test Your Skills
Test your skills
Check Your Skill Level

Identify your skills gaps
with a simple online test
Build a Bespoke Course
Bespoke course builder
Create Your Own Bespoke Course Online
Get the most from your training by
using our unique bespoke form
Schedule Your Own
Schedule your own class
If You Can't See a Date
that Suits...
Arrange a public/open class
on a date of your choice
Assertiveness
Assertiveness test
Time Management
Time management test


Communication Skills
Communication skills test
Likeability
Likeability test
ISO9001
ISO9001 logo
Quality Assured continuously
since 2005

ISO9001 guarantees the quality of
operations and customer service
CPD Corporate Member
CPD corporate logo
CPD accredited courses:
quality content AND delivery

Get a CPD certificate with
most courses we deliver
ILM
ILM logo
See details of our ILM
development awards

Get official ILM certificates
after your training
Our Courses
Microsoft Desktop Software
Management
Project Management
HR, Training & Recruitment
Sales & Developing Business
Personal & Business Skills
Crystal Reports
 
Online Training: Videos
Online Training: Webinars
 
Use our Full Course Finder

[NOTE: Mouse over the titles above,
then to visit the website pages you want,
click on the links in the right hand panel]
Our courses
Select Your Course
We cover all you need
to improve productivity and
quality at work
Upgrade your skills in the shortest time!
Browse the categories on the left
but if you can't see what you want, click below:
Training course finder
Our Locations
London
South and South East
Midlands
North
 
About Our Training Centres
 
Training at Your Offices
 
Online Training: Videos
Online Training: Webinars

[NOTE: Mouse over the titles above,
then to visit the website pages you want,
click on the links in the right hand panel]
Our training centres
Activia's Centres in London
London Victoria training centre
60 Buckingham Palace Road
London
SW1W 0RR

0207 118 0069
Tower Bridge training centre
Tower Bridge Business Centre
46-48 East Smithfield
London
E1W 1AW
0207 118 0069
 
Activia's Centres in the South and South East
Reading training centre
9 Greyfriars Road
Reading
Berkshire
RG1 1NU
0118 418 1009
Bristol training centre
Easton Business Centre
Felix Road
Bristol
BS5 0HE
0117 259 1009
Milton Keynes training centre
Technology House
151 Silbury Boulevard
Milton Keynes
MK9 1LH
01908 984 151
Activia's Centres in the Midlands
Birmingham training centre
The McLaren Building
46 The Priory, Queensway
Birmingham
B4 7LR
0121 4011 369
Leicester training centre
Rutland House
23-25 Friar Lane
Leicester
LE1 5QQ
0116 416 1005
Nottingham training centre
Two King Street Nottingham
NG1 2AS

0115 7401 464
Activia's Centres in the North
Manchester training centre
111 Piccadilly
Manchester
M1 2HY
0161 207 1221
Leeds training centre
100-114 Wellington Street
Leeds
LS1 1BA
0113 4001 246
 
About our training centres
About Our Training Centres
With ten training centres, and a national network of trainers, we're sure to fit the bill for your training.
Training at Your Offices
How about this for easy training of groups of people?
All you need is a suitable room, and we can bring your training to you!
In house training
Ways to Contact Us
Email
Email Us Direct

Call
0333 6000 111 for Sales/Bookings
0333 6000 555 for Service
Callback request
Free Callback
If you'd like us to call you back, just fill in a simple form and we'll get back to you very soon!
More information
Request More Information
If you want more information, use our request form and we'll be in touch.



Contact us
Speedy Quote
If you can't see a price for what you want on the website, get in touch!

Feedback
Give Us Feedback
We always want to know what our customers think, so please contact us!

Schedule your own training course
Schedule Your Own
Only at Activia can you actually schedule your own Public/Open course.

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