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

810 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

Introductory Discounts & Offers - Call now!

Onsite/Closed Quote  

Version Date Location Places
available
Book Next place rate (£) List
price
Pay by
Card
Pay by
Invoice
2010 Mon 5 Jan 2015 Bloomsbury 6 Book now £244 £254£315
2010 Fri 16 Jan 2015 Southwark 10 Book now £242 £252£315
2010 Tue 20 Jan 2015 Limehouse 0 FULL    £315
2010 Mon 26 Jan 2015 Bloomsbury 4 Book now £241 £251£315
2010 Wed 28 Jan 2015 Bloomsbury 10 Book now £241 £251£315
2010 Wed 4 Feb 2015 Limehouse 8 Book now £240 £250£315
2010 Thu 12 Feb 2015 Bloomsbury 5 Book now £240 £250£315
2010 Thu 19 Feb 2015 Limehouse 8 Book now £239 £249£315
2010 Wed 25 Feb 2015 Limehouse 10 Book now £238 £248£315
2010 Thu 5 Mar 2015 Bloomsbury 10 Book now £237 £247£315
2010 Mon 9 Mar 2015 Bloomsbury 8 Book now £237 £247£315
2010 Mon 16 Mar 2015 Bloomsbury 10 Book now £236 £246£315
2010 Tue 24 Mar 2015 Bloomsbury 10 Book now £235 £245£315
2010 Tue 31 Mar 2015 Limehouse 10 Book now £234 £244£315
2010 Fri 10 Apr 2015 Limehouse 10 Book now £228 £238£315
2010 Wed 29 Apr 2015 Bloomsbury 10 Book now £216 £226£315
2010 Mon 18 May 2015 Bloomsbury 10 Book now £204 £214£315
2010 Tue 2 Jun 2015 Bloomsbury 10 Book now £195 £205£315
2010 Tue 16 Jun 2015 Limehouse 10 Book now £195 £205£315
2010 Tue 30 Jun 2015 Bloomsbury 10 Book now £195 £205£315
2010 Thu 16 Jul 2015 Bloomsbury 10 Book now £195 £205£315
2010 Wed 5 Aug 2015 Limehouse 10 Book now £195 £205£315
2010 Tue 18 Aug 2015 Limehouse 10 Book now £195 £205£315
2010 Tue 1 Sep 2015 Limehouse 10 Book now £195 £205£315
2010 Mon 14 Sep 2015 Bloomsbury 10 Book now £195 £205£315
2010 Mon 28 Sep 2015 Bloomsbury 10 Book now £195 £205£315
2010 Tue 13 Oct 2015 Limehouse 10 Book now £195 £205£315
2010 Wed 28 Oct 2015 Bloomsbury 10 Book now £195 £205£315
2010 Thu 12 Nov 2015 Limehouse 10 Book now £195 £205£315
2010 Wed 25 Nov 2015 Bloomsbury 10 Book now £195 £205£315
2010 Wed 9 Dec 2015 Bloomsbury 10 Book now £195 £205£315
2010 Wed 23 Dec 2015 Bloomsbury 10 Book now £195 £205£315
2010 Fri 15 Jan 2016 Bloomsbury 10 Book now £195 £205£315
2010 Mon 1 Feb 2016 Bloomsbury 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

Teach First
PA For Director /Co-ordinator Of London Region
Natasha Reynolds
Excel Intermediate
Very helpful, especially since I didn't know what I didn't know!

Great pacing and very adaptive to everyone.
NViro
Kim Scott
Excel Intermediate
I was extremely happy and do not think that I can find anything to be improved upon.
Sage Pay
Finance Executive
Sophie Powell
Excel Intermediate
Very good course, I got way more out of it than expected and the trainer was brilliant!

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
BBC UK Sport Virgin Media Television
17 delegates 29 delegates 19 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
Ricoh Europe plc markit Vue Entertainment
12 delegates 79 delegates 15 delegates
100% would
recommend us
95% would
recommend us
100% would
recommend us
British Sky Broadcasting Ltd DHL Hilton Hotels Corporation
14 delegates 42 delegates 27 delegates
100% would
recommend us
94% would
recommend us
100% would
recommend us
BP plc Sony Europe BNP Paribas Group
86 delegates 25 delegates 128 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
Barclays PLC Action for the Blind Marks and Spencer
83 delegates 18 delegates 30 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
Live Nation Entertainment Sotheby's J Sainsburys PLC
15 delegates 126 delegates 11 delegates
100% would
recommend us
99% would
recommend us
100% would
recommend us
AMAZON (previously LOVEFiLM) Al Jazeera International Ltd Betfair
61 delegates 17 delegates 15 delegates
100% 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