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

866 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 Thu 4 Dec 2014 Southwark 2 Book now £237 £247£315
2010 Fri 5 Dec 2014 Limehouse 10 Book now £226 £236£315
2010 Wed 10 Dec 2014 Limehouse 7 Book now £225 £235£315
2010 Mon 15 Dec 2014 Southwark 9 Book now £225 £235£315
2010 Fri 19 Dec 2014 Bloomsbury 9 Book now £225 £235£315
2010 Mon 5 Jan 2015 Bloomsbury 7 Book now £224 £234£315
2010 Mon 12 Jan 2015 Limehouse 10 Book now £224 £234£315
2010 Thu 15 Jan 2015 Limehouse 10 Book now £223 £233£315
2010 Fri 16 Jan 2015 Southwark 9 Book now £223 £233£315
2010 Tue 20 Jan 2015 Limehouse 9 Book now £223 £233£315
2010 Mon 26 Jan 2015 Bloomsbury 9 Book now £223 £233£315
2010 Thu 29 Jan 2015 Bloomsbury 10 Book now £223 £233£315
2010 Wed 4 Feb 2015 Southwark 10 Book now £222 £232£315
2010 Thu 12 Feb 2015 Bloomsbury 7 Book now £222 £232£315
2010 Thu 19 Feb 2015 Southwark 10 Book now £222 £232£315
2010 Fri 20 Feb 2015 Bloomsbury 10 Book now £222 £232£315
2010 Thu 26 Feb 2015 Limehouse 10 Book now £221 £231£315
2010 Mon 2 Mar 2015 Bloomsbury 10 Book now £221 £231£315
2010 Thu 5 Mar 2015 Bloomsbury 10 Book now £220 £230£315
2010 Mon 9 Mar 2015 Limehouse 10 Book now £315 £315£315
2010 Wed 11 Mar 2015 Southwark 10 Book now £218 £228£315
2010 Fri 13 Mar 2015 Limehouse 10 Book now £315 £315£315
2010 Tue 17 Mar 2015 Southwark 10 Book now £215 £225£315
2010 Fri 20 Mar 2015 Bloomsbury 10 Book now £315 £315£315
2010 Tue 24 Mar 2015 Southwark 10 Book now £212 £222£315
2010 Fri 27 Mar 2015 Bloomsbury 10 Book now £315 £315£315
2010 Mon 30 Mar 2015 Limehouse 10 Book now £210 £220£315
2010 Tue 31 Mar 2015 Southwark 10 Book now £315 £315£315
2010 Thu 2 Apr 2015 Bloomsbury 10 Book now £209 £219£315
2010 Tue 7 Apr 2015 Southwark 10 Book now £315 £315£315
2010 Mon 13 Apr 2015 Bloomsbury 10 Book now £205 £215£315
2010 Fri 17 Apr 2015 Bloomsbury 10 Book now £315 £315£315
2010 Tue 21 Apr 2015 Limehouse 10 Book now £202 £212£315
2010 Fri 24 Apr 2015 Limehouse 10 Book now £315 £315£315
2010 Tue 28 Apr 2015 Southwark 10 Book now £199 £209£315
2010 Fri 1 May 2015 Bloomsbury 10 Book now £315 £315£315
2010 Thu 7 May 2015 Limehouse 10 Book now £195 £205£315
2010 Fri 8 May 2015 Southwark 10 Book now £315 £315£315
2010 Tue 12 May 2015 Bloomsbury 10 Book now £195 £205£315
2010 Fri 15 May 2015 Limehouse 10 Book now £315 £315£315
2010 Mon 18 May 2015 Southwark 10 Book now £195 £205£315
2010 Fri 22 May 2015 Bloomsbury 10 Book now £315 £315£315
2010 Tue 26 May 2015 Limehouse 10 Book now £195 £205£315
2010 Fri 29 May 2015 Bloomsbury 10 Book now £315 £315£315
2010 Wed 3 Jun 2015 Southwark 10 Book now £195 £205£315
2010 Fri 5 Jun 2015 Bloomsbury 10 Book now £315 £315£315
2010 Mon 8 Jun 2015 Limehouse 10 Book now £195 £205£315
2010 Fri 12 Jun 2015 Southwark 10 Book now £315 £315£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 Mon 22 Jun 2015 Bloomsbury 10 Book now £315 £315£315
2010 Wed 24 Jun 2015 Limehouse 10 Book now £195 £205£315
2010 Fri 26 Jun 2015 Southwark 10 Book now £315 £315£315
2010 Tue 30 Jun 2015 Bloomsbury 10 Book now £195 £205£315
2010 Fri 3 Jul 2015 Limehouse 10 Book now £315 £315£315
2010 Mon 6 Jul 2015 Southwark 10 Book now £195 £205£315
2010 Fri 10 Jul 2015 Southwark 10 Book now £315 £315£315
2010 Wed 15 Jul 2015 Bloomsbury 10 Book now £195 £205£315
2010 Mon 20 Jul 2015 Limehouse 10 Book now £315 £315£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 Wed 29 Jul 2015 Limehouse 10 Book now £315 £315£315
2010 Fri 31 Jul 2015 Bloomsbury 10 Book now £195 £205£315
2010 Mon 3 Aug 2015 Bloomsbury 10 Book now £315 £315£315
2010 Thu 6 Aug 2015 Limehouse 10 Book now £195 £205£315
2010 Mon 10 Aug 2015 Southwark 10 Book now £315 £315£315
2010 Wed 12 Aug 2015 Bloomsbury 10 Book now £195 £205£315
2010 Fri 14 Aug 2015 Southwark 10 Book now £315 £315£315
2010 Wed 19 Aug 2015 Bloomsbury 10 Book now £195 £205£315
2010 Fri 21 Aug 2015 Limehouse 10 Book now £315 £315£315
2010 Mon 24 Aug 2015 Southwark 10 Book now £195 £205£315
2010 Fri 28 Aug 2015 Bloomsbury 10 Book now £315 £315£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 Mon 7 Sep 2015 Bloomsbury 10 Book now £315 £315£315
2010 Wed 9 Sep 2015 Limehouse 10 Book now £195 £205£315
2010 Fri 11 Sep 2015 Southwark 10 Book now £315 £315£315
2010 Mon 14 Sep 2015 Bloomsbury 10 Book now £195 £205£315
2010 Thu 17 Sep 2015 Limehouse 10 Book now £315 £315£315
2010 Mon 21 Sep 2015 Southwark 10 Book now £195 £205£315
2010 Wed 23 Sep 2015 Bloomsbury 10 Book now £315 £315£315
2010 Fri 25 Sep 2015 Limehouse 10 Book now £195 £205£315
2010 Mon 28 Sep 2015 Southwark 10 Book now £315 £315£315
2010 Thu 1 Oct 2015 Bloomsbury 10 Book now £195 £205£315
2010 Mon 5 Oct 2015 Limehouse 10 Book now £315 £315£315
2010 Wed 7 Oct 2015 Southwark 10 Book now £195 £205£315
2010 Fri 9 Oct 2015 Bloomsbury 10 Book now £315 £315£315
2010 Tue 13 Oct 2015 Limehouse 10 Book now £195 £205£315
2010 Fri 16 Oct 2015 Bloomsbury 10 Book now £315 £315£315
2010 Mon 19 Oct 2015 Southwark 10 Book now £195 £205£315
2010 Thu 22 Oct 2015 Southwark 10 Book now £315 £315£315
2010 Mon 26 Oct 2015 Bloomsbury 10 Book now £195 £205£315
2010 Thu 29 Oct 2015 Limehouse 10 Book now £315 £315£315
2010 Mon 2 Nov 2015 Southwark 10 Book now £195 £205£315
2010 Thu 5 Nov 2015 Bloomsbury 10 Book now £315 £315£315
2010 Mon 9 Nov 2015 Limehouse 10 Book now £195 £205£315
2010 Wed 11 Nov 2015 Bloomsbury 10 Book now £315 £315£315
2010 Fri 13 Nov 2015 Limehouse 10 Book now £195 £205£315
2010 Wed 18 Nov 2015 Limehouse 10 Book now £315 £315£315
2010 Tue 24 Nov 2015 Southwark 10 Book now £195 £205£315
2010 Fri 27 Nov 2015 Bloomsbury 10 Book now £315 £315£315
2010 Mon 30 Nov 2015 Limehouse 10 Book now £195 £205£315
2010 Thu 3 Dec 2015 Southwark 10 Book now £315 £315£315
2010 Mon 7 Dec 2015 Bloomsbury 10 Book now £195 £205£315
2010 Tue 8 Dec 2015 Limehouse 10 Book now £315 £315£315
2010 Thu 10 Dec 2015 Southwark 10 Book now £195 £205£315
2010 Mon 14 Dec 2015 Bloomsbury 10 Book now £315 £315£315
2010 Wed 16 Dec 2015 Limehouse 10 Book now £195 £205£315
2010 Mon 4 Jan 2016 Bloomsbury 10 Book now £195 £205£315
2010 Wed 6 Jan 2016 Southwark 10 Book now £195 £205£315
2010 Mon 11 Jan 2016 Limehouse 10 Book now £195 £205£315
2010 Tue 19 Jan 2016 Limehouse 10 Book now £195 £205£315
2010 Mon 25 Jan 2016 Bloomsbury 10 Book now £195 £205£315
2010 Thu 28 Jan 2016 Bloomsbury 10 Book now £195 £205£315
2010 Wed 3 Feb 2016 Southwark 10 Book now £195 £205£315
2010 Fri 5 Feb 2016 Limehouse 10 Book now £195 £205£315
2010 Thu 18 Feb 2016 Southwark 10 Book now £195 £205£315
2010 Thu 25 Feb 2016 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

Inmarsat
Internal Auditor
Excel Intermediate
I thought the course and instructor were excellent. I was a bit worried some of the course would be too fast paced, but it was perfect. Overall very happy and come away with a much better understanding.
MVF Global
Online Marketing Executive
Bertrand Motte
Excel Intermediate
Very useful course.
I learned a lot in a short amount of time.
NViro
Kim Scott
Excel Intermediate
I was extremely happy and do not think that I can find anything to be improved upon.

More testimonials

Some of our clients:

London 2012 Special Olympics Great Britain BBC
13 delegates 19 delegates 17 delegates
92% would
recommend us
100% would
recommend us
100% would
recommend us
Virgin Media Television UK Sport Ricoh Europe plc
19 delegates 29 delegates 12 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
Transport for London Hilton Hotels Corporation HSBC
35 delegates 27 delegates 106 delegates
85% would
recommend us
100% would
recommend us
100% would
recommend us
National Lottery Commission Accor Group Swarovski
11 delegates 28 delegates 27 delegates
100% would
recommend us
100% would
recommend us
96% would
recommend us
Metropolitan Police Live Nation Entertainment Johnson Controls
121 delegates 15 delegates 31 delegates
100% would
recommend us
100% would
recommend us
97% would
recommend us
Westmill foods Legal & General Marks and Spencer
56 delegates 25 delegates 30 delegates
96% would
recommend us
100% would
recommend us
100% would
recommend us
London Stock Exchange Vue Entertainment Sotheby's
15 delegates 15 delegates 126 delegates
100% would
recommend us
100% would
recommend us
99% would
recommend us
White Stuff KPMG LLP (UK) Home Office
16 delegates 29 delegates 61 delegates
94% would
recommend us
100% would
recommend us
100% 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