Quick Course Search

Bespoke Microsoft Excel - 1 Day Intermediate Training Course

Bespoke Excel Intermediate Microsoft Excel Icon
Excel Logo and Intermediate Course Delegates

This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of intermediate Excel tools and concepts in order to bring their ability to create powerful spreadsheets to a high level.

Microsoft Excel Icon
  • Private Training
  • Bespoke Course Content
  • Date(s) arranged to suit
  • Onsite courses available

This course can be based around our base outline or part/fully customised according to your level & requirements. Our bespoke Microsoft Excel training is offered at the London, Manchester and Glasgow centres or onsite at your offices.

Bespoke Excel Training Banner
Version: Microsoft Excel
Level: Intermediate
Duration: 1 Day (10am-5pm)
Computer: Windows & Mac

Bespoke Microsoft Excel - Intermediate Overview

Excel Logo and Intermediate Course Delegates

Microsoft Excel is the standard spreadsheet application, an essential component of the Microsoft Office Suite. Excel provides comprehensive tools to help you create, analyse, and share spreadsheets, and its powerful, enhanced formatting features allow users to analyse and visualise data through the creation of graphs and charts.

In this 1 day intermediate course on Microsoft Excel, it is assumed that you already have a basic understanding of the application. From this point we move on to more advanced use of the application, examining different ways to format and present information using Excel. You will be shown how to use both databases and charts to analyse data, and how to capitalise on timesaving features of Excel such as the use of templates, which will have an immediate and positive impact on your productivity.

By the end of this course you'll be an advanced user of Microsoft Excel and will feel confident using all the sophisticated features of this powerful application.


Course Target Audience and delegate prerequisites

You will need basic PC or Mac skills, including a solid understanding of a computer's operating system (Windows or Mac OS). You will also need to know how to launch a program, create and save files, and copy files from CDs and other media. Previous knowledge of Microsoft Excel will be beneficial.

 

Bespoke Training Prices

The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.

  • 1 delegate: £449
  • 2 delegates: £549
  • 3 delegates: £599
  • 4 delegates: £649
  • 5 delegates: £699
  • 6 delegates: £749
  • 7 delegates: £799
  • 8 delegates: £849
Book this training course

Good interactive training. Trainer was excellent. Thanks

Andy Doust, RRG Group, Microsoft Excel VBA 1 Day Introduction

Bespoke Microsoft Excel - Intermediate Outline

The following is a general outline. The range of topics covered during your training is dependent upon student level, time available and preferences of your course booking.

Workbooks, Worksheets and Calculations
  • Working with multiple worksheets and workbooks
  • Creating calculations between worksheets
  • Creating workbook templates
Working with Formulae and Functions
  • Insert Function button
  • Statistical functions
  • Conditional formulae - IF() function
  • Conditional formatting
  • Prevention of rounding errors
Creating Charts
  • Chart types
  • Chart formatting features
  • Use of trendlines
  • Using graphic objects to enhance worksheets and charts
Working with Databases
  • Setting up lists
  • Finding and organising data
  • Filtering, sorting and subtotalling database lists
  • Enhanced list functionality e.g. advanced filtering
  • Introduction to PivotTables to summarise and analyse data
Views and Customising Excel
  • View options - freeze panes, split and working on multiple windows
  • Number formatting and creating custom number formats
  • Using cell styles and text formats
  • Find and Replace, AutoCorrect
  • Linking Excel and Word
Formula Auditing
  • Tracing precedents and dependents
  • Showing all formulas
  • Error checking options
Document Options
  • Security and worksheet protection
  • Compatibility mode
  • Workbook inspection

Bespoke Training Prices

The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.

  • 1 delegate: £449
  • 2 delegates: £549
  • 3 delegates: £599
  • 4 delegates: £649
  • 5 delegates: £699
  • 6 delegates: £749
  • 7 delegates: £799
  • 8 delegates: £849
Book this training course

Good interactive training. Trainer was excellent. Thanks

Andy Doust, RRG Group, Microsoft Excel VBA 1 Day Introduction

What's Included

The following are provided for your best experience on this bespoke course:

  • Tailored course content arranged around your requirements
  • Flexible dates to suit your desired timeframe
  • Course location either at our training centres or onsite at your premises.
  • All computers for your use with choice of Windows or Mac systems (not onsite)
  • Quality reference manual for post course reference to take away with you
  • 6 months post course support to assist you where needed
  • Official Authorised Certificate for your successful completion of the course
  • Lunch To give you the most flexible options for lunch we provide lunch vouchers which can be redeemed locally at a number of popular eateries including Pret A Manger, EAT, Starbucks, Tesco, Sainsburys, Boots and Gregs (not onsite)
  • Refreshments to keep you on top form are available for you throughout the course with a full range of teas, coffees and biscuits (not onsite)
Normal daily course times run between 10am and 5pm however we can offer flexibility for this bespoke course should your time requirements vary.

Our trainers are certified Microsoft Excel specialists with years of experience teaching Excel. Get the spreadsheet skills you need with our Microsoft professionals.

Included with your course booking for all delegates on this course is 6 months free support so if you run into problems or need assistance relating to anything covered during your course we would be happy to assist you during this time.

After your class with XChange Training you will receive our official Certificate as a record of your successful completion of the course.

Bespoke Training Prices

The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.

  • 1 delegate: £449
  • 2 delegates: £549
  • 3 delegates: £599
  • 4 delegates: £649
  • 5 delegates: £699
  • 6 delegates: £749
  • 7 delegates: £799
  • 8 delegates: £849
Book this training course

Good interactive training. Trainer was excellent. Thanks

Andy Doust, RRG Group, Microsoft Excel VBA 1 Day Introduction

Training Location Options

This course is offered for your convenience either at one of our bespoke training centres in London, Manchester and Glasgow or onsite at your offices anywhere in the UK. Just let us know what would work best for you or your team.

The location details of our bespoke training centres are shown below:

LONDON
5 St John’s Lane
Clerkenwell
London
EC1M 4BH

St John’s Lane is located in the heart of Clerkenwell close to the junction of Farringdon and Clerkenwell Road. Farringdon tube & train station is just a few minutes away and the training centre can also be accessed from Chancery Lane and Barbican tubes in about 10 minutes. There is also easy direct access by bus from Waterloo (243) and West End (55) with nearby stops.

MANCHESTER
Piccadilly House
49 Piccadilly
Manchester
M1 2AP

Piccadilly House is located in central Manchester directly next to the Piccadilly Gardens transport interchange with excellent bus and tram connections and is easily accessed from Piccadilly train Station (5 mins). Victoria station is also close by (around 10 mins).

GLASGOW
Centrum Business Centre
38 Queen Street
Glasgow
G1 3DX

The Queen Street training centre is located in central Glasgow within easy walking distance of the 3 local train options of Central Station, Queen Street and Argyle Street offering excellent transport connections.


Courses are run between 10am and 5pm with an hour break for lunch and both mid morning and mid-afternoon refreshment breaks.

Bespoke Training Prices

The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.

  • 1 delegate: £449
  • 2 delegates: £549
  • 3 delegates: £599
  • 4 delegates: £649
  • 5 delegates: £699
  • 6 delegates: £749
  • 7 delegates: £799
  • 8 delegates: £849
Book this training course

Good interactive training. Trainer was excellent. Thanks

Andy Doust, RRG Group, Microsoft Excel VBA 1 Day Introduction

Bespoke Course Enquiry

If you are considering this Microsoft Excel Course but would like further information simply send us your query quickly & easily with the form below. Whether you would like to check date availability, pricing, course suitability or just need further information about a course send us your query and we will get you a swift reply, usually within 2 business hours!

If you would prefer to check course details by phone please call us on 0345 363 1130.

Course Name: Bespoke Microsoft Excel - Intermediate
Location Preference:
Knowledge level of delegate(s):
Number of delegates:
Nature of enquiry:
Lead contact name:
Email address:
Telephone number:
Company (if applicable):
Specific query details:
Captcha code CAPTCHA code  
Please enter the Captcha code
 

 

Bespoke Training Prices

The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.

  • 1 delegate: £449
  • 2 delegates: £549
  • 3 delegates: £599
  • 4 delegates: £649
  • 5 delegates: £699
  • 6 delegates: £749
  • 7 delegates: £799
  • 8 delegates: £849
Book this training course

Good interactive training. Trainer was excellent. Thanks

Andy Doust, RRG Group, Microsoft Excel VBA 1 Day Introduction

Related Courses

Excel Being Used on a Mac


Bespoke Microsoft Project Training Courses


Bespoke Microsoft Visio Training Courses


Bespoke Microsoft Outlook Training Courses


Bespoke Microsoft Powerpoint Training Courses


Bespoke Microsoft Word Training Courses

Bespoke Training Prices

The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.

  • 1 delegate: £449
  • 2 delegates: £549
  • 3 delegates: £599
  • 4 delegates: £649
  • 5 delegates: £699
  • 6 delegates: £749
  • 7 delegates: £799
  • 8 delegates: £849
Book this training course

Good interactive training. Trainer was excellent. Thanks

Andy Doust, RRG Group, Microsoft Excel VBA 1 Day Introduction

Scheduled Microsoft Excel Training Courses

Delegate being trained in Excel

We currently do not offer any public scheduled classes for this application however our bespoke courses will be able to suit your requirements.

Bespoke Training Prices

The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.

  • 1 delegate: £449
  • 2 delegates: £549
  • 3 delegates: £599
  • 4 delegates: £649
  • 5 delegates: £699
  • 6 delegates: £749
  • 7 delegates: £799
  • 8 delegates: £849
Book this training course

Good interactive training. Trainer was excellent. Thanks

Andy Doust, RRG Group, Microsoft Excel VBA 1 Day Introduction

Testimonials

Good interactive training. Trainer was excellent. Thanks

Andy Doust, RRG Group, Microsoft Excel VBA 1 Day Introduction

Good pace and very clear directions. I will definitely be recommending XChange Training in the future.

Charlotte Green, AXA Investment Managers, Powerpoint & Excel - Bespoke Introduction

I have done similar excel courses before but I felt I learnt a lot more on this one due to the way the trainer covered the material and explained everything very clearly.

Romilly Evans, Leo, Excel - 1 Day Intermediate

A very informative day, learnt a lot which I will go back and use in the work place
Louise Craigie, Hayes Fabrications Ltd, Microsoft Outlook - 1 Day Intermediate

A good introduction to the wider functions of Premiere Pro delivered at a speed that was good for me.
Andrew Fowler, Groundwork, Premiere Pro - 1 Day Introduction

Trainer did a great job explaining Enfocus PitStop with clear instructions
Brenda Youngman, Cambridge University Press, PitStop Pro - 1 Day Introduction

A day well spent with some excellent tips on dealing with pdf workflows.
Paul Adams, Schawk, Colour Management - 1 Day Introduction

Really enjoyed the day, training was fun as well as educational. Staff were really friendly and food and rereshments were great.
Jez Williams, Total UK, Acrobat for Creating Rich Media PDFs - 1 Day Introduction

Good course with a very knowledgeable instructor. I have a come away with a solid knowlege of After Effects.
Darren Mael, Billington Cartmell, After Effects - 2 Day Introduction

Found the course extremely interesting and tremendously useful. The instructor was a fountain of knowledge and provided great training materials to actively use. Although the course had a lot of commercial content there was so much that was absolutely relevant to the classroom. The attention to detail and excellence is quite inspiring.
John Whitehead, Hawkley High School, Premiere Pro - 2 Day Advanced

Bespoke Training Prices

The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.

  • 1 delegate: £449
  • 2 delegates: £549
  • 3 delegates: £599
  • 4 delegates: £649
  • 5 delegates: £699
  • 6 delegates: £749
  • 7 delegates: £799
  • 8 delegates: £849
Book this training course

Good interactive training. Trainer was excellent. Thanks

Andy Doust, RRG Group, Microsoft Excel VBA 1 Day Introduction