Menu

    Call us on:
    020 8108 0298

Intermediate Microsoft Excel 2010 trainingIntermediate Microsoft Excel 2010 Training Courses

If you’re looking for really great Intermediate Microsoft Excel 2010 training you’re in the right place.

Companies large and small choose us – why? Your own tailored, Microsoft Intermediate Excel 2010 training course, at your own premises at the same price as a standard course from elsewhere.

The JMD Training difference is clear:

  • We come to you - your Intermediate Microsoft Excel 2010 training will be given on your site
  • You get to keep the manuals - Intermediate Microsoft Excel 2010 training manuals are provided as PDFs
  • We can train using your own Microsoft Excel workbooks
  • There will only be people from your company on your course
  • We offer a money-back guarantee if any delegates are not completely satisfied
  • The training date is around you, not us!
  • Our prices are astounding
  • We can assess all learners in advance for free
  • Our courses are never cancelled

Organisations who have benefitted from our Intermediate Microsoft Excel 2010 training include:

Visit our blog If Only I’d Known That,; we have called it that because we hear it so many times in training sessions. In fact, if only we had an extra £100 for every time someone says “If only I’d known that.” …. There are many useful hints and tips about using Microsoft Excel on the blog; why not visit it to find out how many you knew!

Request Course Now »

Course TypeCost per day
1 to 1 training£295
2 to 4 delegates£455
5 to 8 delegates£595

Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £595. All prices exclude VAT

Provisional course outlines:

Our Microsoft Excel training courses London, are available not only in London, but Surrey, Middlesex, Richmond, Twickenham, Hounslow, Brentford, Putney, Wimbledon, Staines, Egham, Feltham, Reading, Kingston, Croydon, Epsom, Woking, Banstead, Farnham, High Wycombe, Crawley, Sutton, St Albans, Fulham – in fact anywhere within the Home Counties and M25 corridor. We have Microsoft Excel trainers in Twickenham, Richmond, Ashstead, Lightwater, Ascot, Central London, New Barnet, Ilford, Surbiton, Slough, St Albans, Bushey, Crowthorne, Basingstoke, Whiteley, Little Torrington, Wembley, Nottingham, Taunton, Doncaster, Immingham, Edinburgh, Sunderland, Leeds, Thatcham, Cardiff, Watford, Wallington, Littlehampton, Romford and Bolton! If you are based within 30 miles of any of these locations we would not charge travel expenses for the trainer. We can still provide Microsoft Excel training courses outside these areas but would then need to charge for the travel expenses of the Excel trainer.

“Amazing, helpful and smiles all the way through. The type of trainer I would inspire to be.” – David, Fizzy Living

Aims of the Intermediate Excel 2010 course

This course aims to give delegates a greater understanding of MS Excel 2010.

Course Objectives

On completion of the course delegates will have improved their skills in using Microsoft Excel 2010. They will be able to:

  • Manipulate worksheets
  • Apply conditional formatting
  • Use various functions, including financial, logical and date/time functions
  • Manage Excel tables
  • Customise charts
  • Use Excel in conjunction with other applications

The course is of one day’s duration.

How the course is run

This instructor-led course has a hands-on approach, with plenty of opportunity for delegates to practise the new skills they learn at the computer.

Pre-requisites

Familiarity with the Windows environment, and a basic knowledge of Excel.

Editing

  • Data - naming cell ranges in a worksheet, the Name Manager, importing text files, using Paste Special options
  • Formatting - applying formatting to a cell range by the use of styles, creating custom number formats, using conditional formatting options
  • Display - inserting a new worksheet, renaming a worksheet, deleting a worksheet, adding colour to worksheet tabs, formatting worksheet backgrounds, freezing row and/or column titles, splitting worksheet window into panes, freezing panes, hiding/unhiding rows and columns, hiding/unhiding worksheets, grouping and ungrouping worksheets
  • Using subtotalling features
  • Linking - Linking data within a worksheet, between worksheets and between workbooks, link charts within a worksheet, between worksheets and between workbooks, linking to a word-processing documents, consolidating data in adjacent worksheets using a 3D sum function
  • Charts and graphs - Changing angle of pie chart slices, formatting chart axes numbers or text, re-positioning title, legend or data labels in a chart, 'exploding' all the segments in a pie chart, adding or deleting a data series in a chart, modifying the chart type for a defined data series, widening the gap between columns or bars in a 2D chart, inserting an image in a 2D chart

Functions

  • Resizing the Formula Bar, Formula AutoComplete
  • Using date and time functions: TODAY, DAY, MONTH, YEAR
  • Using mathematical functions: SUMIF, SUMIFS, ROUND
  • Using statistical functions: COUNT, COUNT, COUNTBLANK, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS
  • Using text functions: PROPER, UPPER, LOWER, CONCATENATE
  • Converting text to columns
  • Using financial functions: FV, NPV, PMT, PV, RATE
  • Using lookup functions: IF, AND, OR, ISERROR
  • Using available database functions: DSUM, DMIN, DMAX and DCOUNT
  • Using nested functions

Excel tables

  • Creating an Excel table
  • Editing an Excel table
  • Table quick styles
  • Inserting and deleting rows and columns in tables
  • Sorting
  • Using the AutoFilter with tables
  • Totals
  • Removing duplicate rows from worksheets
  • Creating a dropdown list for table entry
  • Structured references

Request Course Now »

We provide Microsoft Excel training courses, Microsoft Office training courses, other IT training courses and Personal Development training courses in London, Richmond, Twickenham, Kingston, Hounslow, Brentford, Putney, Kingston, Wimbledon, Walton-on-Thames, Chiswick, Teddington, Hampton, Feltham, Acton, Ealing, Heathrow, Egham, Staines, Reading, Croydon, Epsom, Banstead, Hanwell, Sunbury, Hammersmith, Fulham, Greenford, Clapham, Chertsey, Woking, Weybridge, Wandsworth, Middlesex, Surrey, the M25 corridor, High Wycombe and beyond. We will travel further if expenses are covered.

For Microsoft Excel training courses Sydney, Australia, please visit our sister site http://www.jmdtraining.com.au/microsoft-office-training/microsoft-excel-training