Instructor-led training - excel 2010 intermediate course
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

Microsoft Partner

Learning & Performance Institute - Accredited Training Provider

How to book

Live 12+ month schedule

On-site / Closed company:

60 second quote

Need help or advice?

Enter your name/number and we will call you back

We'll call during UK business hours

Name:
Number:

Excel 2010 Intermediate Training CourseExcel 2010 Intermediate Training Course

Microsoft Excel 2010 spreadsheet training

Syllabus here

1 day from £195 List price £315

Instructor-led / Microsoft qualified trainers

Courses never cancelled: Guaranteed
Guarantee applies to Microsoft Desktop training and Management Skills Training.

Course rating:
4.6 stars - based on 731 reviews

Benefits

  • Quickly summarise multiple tabs of data
  • Turn long lists and reports into easy to read tables
  • Formulas & formatting to show you cells that pass or fail your business rules
  • Save time by converting your frequently used workbooks into templates
  • Connect spreadsheets so that one updates another
  • Get information at a glance with conditional formatting
  • Reduce human error with conditional formulas

900 Excel events in the next 12 months, live dates & pricing here


Who is this course for?

Our Microsoft Excel 2010 Intermediate course is suitable for those with a basic working knowledge of Excel. Recent attendees have included; Finance Manager, Strategist - Client Development, Business Manager, Credit Manager...

Prerequisites

A working knowledge of Excel or our Excel Introduction course.

Benefits

  • Quickly summarise multiple tabs of data
  • Turn long lists and reports into easy to read tables
  • Formulas & formatting to show you cells that pass or fail your business rules
  • Save time by converting your frequently used workbooks into templates
  • Connect spreadsheets so that one updates another
  • Get information at a glance with conditional formatting
  • Reduce human error with conditional formulas

Course Syllabus

Working with Large Worksheets

Viewing options
- Adjusting zoom
- Using Freeze Panes
- Using Split Window
Hiding and displaying data
- Hiding rows and columns
- Creating an outline
Printing large worksheets
- Page Break preview
- Working with page breaks
- Printing multiple sheets

Working with Multiple Worksheets and Workbooks

Using multiple worksheets
- Navigating between sheets
- Moving and copying sheets
Linking worksheets
- Creating 3-D formulas
- Consolidating data
Linking workbooks
- Creating a formula to link workbooks
- Using the Paste Link option
- Maintaining links

Working with dates

Entering date functions
- TODAY function
- NOW function
Date and time formats
Using dates in formulas

Conditional formulas and formatting

The IF function
Conditional formatting
- Based on a cell value
- Based on a formula
- Identifying cells with conditional formatting
- Copying conditional formats

List Management

Working with lists
- Structure of a list
Sorting and filtering lists
- Simple sorting
- Sorting by multiple columns
- Using AutoFilter
Advanced filtering
- Using custom filter
- Using Advanced Filter
Adding subtotals to a list

Documenting and Auditing

Comments
- Viewing, adding, editing and deleting comments
Auditing features
- Tracing formula errors
Protection
- Protecting a worksheet
- Protecting cell ranges

Using Templates

Built-in templates
- Accessing and using Excel’s templates
Creating and managing templates
- Creating, using and modifying a custom template file

Excel Intermediate 2010     1 day course

Onsite/Closed Quote    Introductory Discounts & Offers - Call now!   

Version Date Location Places
available
Book Next place rate (£) List
price
Pay by
Card
Pay by
Invoice
2010 Mon 3 Nov 2014 Southwark 0 FULL    £315
2010 Mon 10 Nov 2014 Limehouse 0 FULL    £315
2010 Thu 13 Nov 2014 Bloomsbury 7 Book now £225 £235£315
2010 Mon 17 Nov 2014 Bloomsbury 0 FULL    £315
2010 Mon 24 Nov 2014 Limehouse 8 Book now £225 £235£315
2010 Thu 27 Nov 2014 Limehouse 10 Book now £225 £235£315
2010 Thu 4 Dec 2014 Southwark 7 Book now £224 £234£315
2010 Wed 10 Dec 2014 Limehouse 9 Book now £224 £234£315
2010 Mon 15 Dec 2014 Southwark 8 Book now £224 £234£315
2010 Fri 19 Dec 2014 Bloomsbury 10 Book now £223 £233£315
2010 Mon 5 Jan 2015 Bloomsbury 8 Book now £223 £233£315
2010 Mon 12 Jan 2015 Limehouse 10 Book now £222 £232£315
2010 Tue 20 Jan 2015 Limehouse 9 Book now £222 £232£315
2010 Mon 26 Jan 2015 Bloomsbury 9 Book now £221 £231£315
2010 Wed 4 Feb 2015 Southwark 10 Book now £221 £231£315
2010 Thu 12 Feb 2015 Bloomsbury 9 Book now £218 £228£315
2010 Thu 19 Feb 2015 Southwark 10 Book now £215 £225£315
2010 Thu 26 Feb 2015 Limehouse 10 Book now £212 £222£315
2010 Thu 5 Mar 2015 Bloomsbury 10 Book now £209 £219£315
2010 Wed 11 Mar 2015 Southwark 10 Book now £207 £217£315
2010 Tue 17 Mar 2015 Southwark 10 Book now £204 £214£315
2010 Tue 24 Mar 2015 Southwark 10 Book now £202 £212£315
2010 Mon 30 Mar 2015 Limehouse 10 Book now £199 £209£315
2010 Thu 2 Apr 2015 Bloomsbury 10 Book now £198 £208£315
2010 Mon 13 Apr 2015 Bloomsbury 10 Book now £195 £205£315
2010 Tue 21 Apr 2015 Limehouse 10 Book now £195 £205£315
2010 Tue 28 Apr 2015 Southwark 10 Book now £195 £205£315
2010 Thu 7 May 2015 Limehouse 10 Book now £195 £205£315
2010 Tue 12 May 2015 Bloomsbury 10 Book now £195 £205£315
2010 Mon 18 May 2015 Southwark 10 Book now £195 £205£315
2010 Tue 26 May 2015 Limehouse 10 Book now £195 £205£315
2010 Wed 3 Jun 2015 Southwark 10 Book now £195 £205£315
2010 Mon 8 Jun 2015 Limehouse 10 Book now £195 £205£315
2010 Wed 17 Jun 2015 Bloomsbury 10 Book now £195 £205£315
2010 Fri 19 Jun 2015 Southwark 10 Book now £195 £205£315
2010 Wed 24 Jun 2015 Limehouse 10 Book now £195 £205£315
2010 Tue 30 Jun 2015 Bloomsbury 10 Book now £195 £205£315
2010 Mon 6 Jul 2015 Southwark 10 Book now £195 £205£315
2010 Wed 15 Jul 2015 Bloomsbury 10 Book now £195 £205£315
2010 Fri 24 Jul 2015 Southwark 10 Book now £195 £205£315
2010 Mon 27 Jul 2015 Limehouse 10 Book now £195 £205£315
2010 Fri 31 Jul 2015 Bloomsbury 10 Book now £195 £205£315
2010 Thu 6 Aug 2015 Limehouse 10 Book now £195 £205£315
2010 Wed 12 Aug 2015 Bloomsbury 10 Book now £195 £205£315
2010 Wed 19 Aug 2015 Bloomsbury 10 Book now £195 £205£315
2010 Mon 24 Aug 2015 Southwark 10 Book now £195 £205£315
2010 Tue 1 Sep 2015 Limehouse 10 Book now £195 £205£315
2010 Thu 3 Sep 2015 Bloomsbury 10 Book now £195 £205£315
2010 Wed 9 Sep 2015 Limehouse 10 Book now £195 £205£315
2010 Mon 14 Sep 2015 Bloomsbury 10 Book now £195 £205£315
2010 Mon 21 Sep 2015 Southwark 10 Book now £195 £205£315
2010 Fri 25 Sep 2015 Limehouse 10 Book now £195 £205£315
2010 Thu 1 Oct 2015 Bloomsbury 10 Book now £195 £205£315
2010 Wed 7 Oct 2015 Southwark 10 Book now £195 £205£315
2010 Tue 13 Oct 2015 Limehouse 10 Book now £195 £205£315
2010 Mon 19 Oct 2015 Southwark 10 Book now £195 £205£315
2010 Mon 26 Oct 2015 Bloomsbury 10 Book now £195 £205£315
2010 Mon 2 Nov 2015 Southwark 10 Book now £195 £205£315
2010 Mon 9 Nov 2015 Limehouse 10 Book now £195 £205£315
2010 Fri 13 Nov 2015 Limehouse 10 Book now £195 £205£315
2010 Tue 24 Nov 2015 Southwark 10 Book now £195 £205£315
2010 Mon 30 Nov 2015 Limehouse 10 Book now £195 £205£315
2010 Mon 7 Dec 2015 Bloomsbury 10 Book now £195 £205£315
2010 Thu 10 Dec 2015 Southwark 10 Book now £195 £205£315
2010 Wed 16 Dec 2015 Limehouse 10 Book now £195 £205£315

What you get

Training room

Training is held in our modern, comfortable, air-conditioned suites

Modern-spec IT, fully networked with internet access

"What do I get on the day?"

Learning tools

Breaks and TimingsBreaks and timing

Courses start at 9:30am.
Please aim to be with us for 9:15am.
Joining information (how to get to our venues)

In-course handbookIn-course handbook

Contains unit objectives, exercises and space to write notes

RefreshmentsRefreshments

Available throughout the day:

  • Hot beverages
  • Clean, filtered water
  • Biscuits
Reference materialReference material

Available online. 100+ pages with step-by-step instructions

LunchLunch

Lunch is provided at a local restaurant or pub. Browse the sample menus:

24 months forum access24 months access to Microsoft trainers

Your questions answered by Microsoft qualified trainers online.

Training Formats & Services

Some reasons why thousands of businesses trust us

Transparent quality control
Live 12 month schedule/bookings
Courses never cancelled: Guaranteed
Guarantee applies to Microsoft Desktop training and Management Skills Training.
Reschedule in seconds
Industry leading pricing model
Online quote
24 months training support

Testimonials

Xtralis
David McGraw
Excel Intermediate
A great course and fantastic value for money
London Borough of Barnet
Benefits Area Manager
Patricia Driver
Excel Intermediate
I really enjoyed the course. The trainer had a great rapport with everyone and ensured that individual needs were addressed.
Taybridge Associates
Bronia Lovegrove
Excel Intermediate
Thought it was a really useful course - everything explained thoroughly and clearly!

More testimonials

Some of our clients:

London 2012 Special Olympics Great Britain Transport for London
13 delegates 19 delegates 35 delegates
92% would
recommend us
100% would
recommend us
85% would
recommend us
UK Sport BBC Ricoh Europe plc
29 delegates 17 delegates 12 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
Virgin Media Television Accor Group Office for National Statistics
19 delegates 28 delegates 14 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
BP plc Legal & General LOVEFiLM International Ltd.
86 delegates 25 delegates 61 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
Al Jazeera International Ltd J Sainsburys PLC Mo Ibrahim Foundation
17 delegates 11 delegates 22 delegates
100% would
recommend us
100% would
recommend us
77% would
recommend us
BNP Paribas Group Metropolitan Police Fred Perry
128 delegates 121 delegates 53 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
EasyJet The Capita Group Plc Swarovski
16 delegates 61 delegates 27 delegates
100% would
recommend us
100% would
recommend us
96% would
recommend us
Cancer Research UK Unilever Nord Anglia Education
16 delegates 80 delegates 61 delegates
100% would
recommend us
96% would
recommend us
98% would
recommend us

Intermediate Excel Course London compliments our other Excel courses such as Introduction, Advanced Parts 1-3 and VBA training. For our full range of Excel courses, visit the Excel Training Overview page.


Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom