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

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

806 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 Wed 30 Jul 2014 Southwark 0 FULL    £315
2010 Thu 7 Aug 2014 Bloomsbury 0 FULL    £315
2010 Fri 8 Aug 2014 Bloomsbury 0 FULL    £315
2010 Mon 11 Aug 2014 Limehouse 6 Book now £228 £238£315
2010 Fri 15 Aug 2014 Southwark 0 FULL    £315
2010 Fri 15 Aug 2014 Southwark 10 Book now £228 £238£315
2010 Tue 19 Aug 2014 Southwark 1 Book now £239 £249£315
2010 Wed 20 Aug 2014 Limehouse 0 FULL    £315
2010 Wed 27 Aug 2014 Bloomsbury 10 Book now £228 £238£315
2010 Tue 2 Sep 2014 Bloomsbury 7 Book now £227 £237£315
2010 Tue 9 Sep 2014 Limehouse 10 Book now £227 £237£315
2010 Fri 19 Sep 2014 Southwark 8 Book now £226 £236£315
2010 Wed 1 Oct 2014 Limehouse 9 Book now £226 £236£315
2010 Fri 3 Oct 2014 Limehouse 0 FULL    £315
2010 Fri 10 Oct 2014 Southwark 10 Book now £225 £235£315
2010 Mon 20 Oct 2014 Southwark 10 Book now £225 £235£315
2010 Wed 29 Oct 2014 Bloomsbury 10 Book now £224 £234£315
2010 Mon 10 Nov 2014 Limehouse 10 Book now £220 £230£315
2010 Mon 24 Nov 2014 Limehouse 10 Book now £214 £224£315
2010 Fri 28 Nov 2014 Limehouse 10 Book now £315 £315£315
2010 Thu 4 Dec 2014 Southwark 10 Book now £210 £220£315
2010 Tue 9 Dec 2014 Limehouse 10 Book now £315 £315£315
2010 Mon 15 Dec 2014 Southwark 10 Book now £205 £215£315
2010 Wed 24 Dec 2014 Bloomsbury 10 Book now £315 £315£315
2010 Mon 5 Jan 2015 Bloomsbury 7 Book now £195 £205£315
2010 Thu 8 Jan 2015 Bloomsbury 10 Book now £315 £315£315
2010 Mon 12 Jan 2015 Limehouse 10 Book now £195 £205£315
2010 Mon 19 Jan 2015 Southwark 10 Book now £315 £315£315
2010 Mon 26 Jan 2015 Bloomsbury 10 Book now £195 £205£315
2010 Fri 30 Jan 2015 Bloomsbury 10 Book now £315 £315£315
2010 Fri 6 Feb 2015 Limehouse 10 Book now £195 £205£315
2010 Thu 12 Feb 2015 Bloomsbury 10 Book now £315 £315£315
2010 Wed 18 Feb 2015 Limehouse 10 Book now £195 £205£315
2010 Tue 24 Feb 2015 Limehouse 10 Book now £315 £315£315
2010 Mon 2 Mar 2015 Bloomsbury 10 Book now £195 £205£315
2010 Fri 6 Mar 2015 Limehouse 10 Book now £315 £315£315
2010 Wed 11 Mar 2015 Southwark 10 Book now £195 £205£315
2010 Tue 17 Mar 2015 Bloomsbury 10 Book now £315 £315£315
2010 Mon 23 Mar 2015 Limehouse 10 Book now £195 £205£315
2010 Fri 27 Mar 2015 Limehouse 10 Book now £315 £315£315
2010 Tue 31 Mar 2015 Bloomsbury 10 Book now £195 £205£315
2010 Tue 7 Apr 2015 Bloomsbury 10 Book now £315 £315£315
2010 Fri 10 Apr 2015 Limehouse 10 Book now £195 £205£315
2010 Thu 16 Apr 2015 Southwark 10 Book now £315 £315£315
2010 Wed 22 Apr 2015 Bloomsbury 10 Book now £195 £205£315
2010 Wed 29 Apr 2015 Bloomsbury 10 Book now £315 £315£315
2010 Thu 7 May 2015 Southwark 10 Book now £195 £205£315
2010 Mon 11 May 2015 Limehouse 10 Book now £315 £315£315
2010 Fri 15 May 2015 Southwark 10 Book now £195 £205£315
2010 Wed 20 May 2015 Bloomsbury 10 Book now £315 £315£315
2010 Tue 26 May 2015 Limehouse 10 Book now £195 £205£315
2010 Mon 1 Jun 2015 Southwark 10 Book now £315 £315£315
2010 Mon 8 Jun 2015 Bloomsbury 10 Book now £195 £205£315
2010 Fri 12 Jun 2015 Limehouse 10 Book now £315 £315£315
2010 Tue 16 Jun 2015 Southwark 10 Book now £195 £205£315
2010 Fri 19 Jun 2015 Southwark 10 Book now £315 £315£315
2010 Thu 25 Jun 2015 Bloomsbury 10 Book now £195 £205£315
2010 Tue 30 Jun 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 Limehouse 10 Book now £315 £315£315
2010 Thu 16 Jul 2015 Southwark 10 Book now £195 £205£315
2010 Thu 23 Jul 2015 Limehouse 10 Book now £315 £315£315
2010 Thu 30 Jul 2015 Southwark 10 Book now £195 £205£315
2010 Tue 4 Aug 2015 Bloomsbury 10 Book now £315 £315£315
2010 Mon 10 Aug 2015 Limehouse 10 Book now £195 £205£315
2010 Mon 17 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 Southwark 10 Book now £315 £315£315
2010 Thu 3 Sep 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
Environ UK
Aleisha Swaby
Excel Intermediate
I really enjoyed the course and feel that it was enjoyable and informative
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 UK Sport
13 delegates 19 delegates 29 delegates
92% would
recommend us
100% would
recommend us
100% would
recommend us
Transport for London BBC Virgin Media Television
35 delegates 17 delegates 19 delegates
85% would
recommend us
100% would
recommend us
100% would
recommend us
Ricoh Europe plc Barclays PLC Houses of Parliament
12 delegates 83 delegates 16 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
IOM Marks and Spencer EasyJet
85 delegates 30 delegates 16 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
Office for National Statistics Open University Vue Entertainment
14 delegates 12 delegates 15 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
Swarovski Sotheby's British Sky Broadcasting Ltd
27 delegates 126 delegates 14 delegates
96% would
recommend us
99% would
recommend us
100% would
recommend us
Betfair Marriott International Rabobank
15 delegates 29 delegates 54 delegates
100% would
recommend us
95% would
recommend us
100% would
recommend us
LOVEFiLM International Ltd. Lloyds Banking Group Shell UK Ltd
61 delegates 124 delegates 86 delegates
100% would
recommend us
97% 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: Facebook · Twitter · Google+ · LinkedIn · Pinterest

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