Home>All Courses > Microsoft Excel Training> Bespoke Microsoft Excel - Intermediate

Bespoke Microsoft Excel - Intermediate

Key Course Details:

Level:

Intermediate

Location:

UK Centres, Online, Onsite

Class, Online, Onsite

Duration:

1 Day (10am-5pm)

Price:

From £595 + VAT

Dates:

Dates to suit you

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.

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 either Online, Onsite at your offices or at one of the XChange centres in London, Manchester and Glasgow.

Overview Full Outline Location Options Related Courses Client Reviews

Bespoke Microsoft Excel - Intermediate

Course Details

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.

View Full Course Outline
Full Course 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
Training Location Options
Online ↓ London ↓ Manchester ↓ Glasgow ↓ Onsite ↓
This course is offered for your convenience at one of our bespoke training centres in London, Manchester and Glasgow, Remote Online, or Onsite at your offices anywhere in the UK. Just let us know what would work best for you or your team.

Remote Online

Delivered Online to your location

Live online training offers an extremely flexible and convenient way of covering the same content as our bespoke classroom based courses. You will receive professional, certified design training from one of our experienced instructors direct to your screen, offering the perfect solution for those wishing to learn without having to travel.
Click to view Full details of our
Remote Online Training Courses

Central London

5 St John’s Lane, Clerkenwell, 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.
Click to view Full details of our
London Training Centre

Central Manchester

Piccadilly House, 49 Piccadilly, 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).
Click to view Full details of our
Manchester Training Centre

Central Glasgow

Centrum Business Centre, 38 Queen Street, 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.
Click to view Full details of our
Glasgow Training Centre

Onsite

Onsite at your Offices/Premises

If you have the required set up and would prefer to have the training at your location we will be able to deliver the same session onsite at your premises as in our training centres. This will provide you with the same tailored training but without the need to travel and less disruption to you or your teams work schedule.
Click to view Full details of
Onsite Training
Related Courses

Below are related bespoke courses for alternative tailored training options.

Bespoke Microsoft Project Training Courses
Microsoft Project - Intermediate 1 Day Training Course
Bespoke Microsoft Visio Training Courses
Microsoft Visio - Introduction 1 Day Training Course
Bespoke Microsoft Outlook Training Courses
Microsoft Outlook - Intermediate Training Course
Bespoke Microsoft Powerpoint Training Courses
Microsoft PowerPoint - Intermediate Training Course
Bespoke Microsoft Word Training Courses
Microsoft Word - Intermediate Training Course
Client Reviews

''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
''Good interactive training. Trainer was excellent. Thanks''
Andy Doust, RRG Group, Microsoft Excel VBA 1 Day Introduction
''The training provided by XChange Training was excellent. I have learned so much that can be taken away and implemented into my work. Working in a small group is really good and you are able to interact with trainer and other learners.''
Rawinder Sandher, Vanquis Bank, Articulate Storyline - 2 Day Introduction
''I was really impressed with the instructor's knowledge of the programme and he explained things in a very clear and easy to understand manner. He was also very flexible and open to working with me to set the agenda for what I needed to learn.''
Sarah Hathaway, Royal Brompton & Harefield , QuarkXPress - 1 Day Bespoke
''The course was helpful and informative but not overly taxing and complicated. I came with some understanding of HTML 'jargon' but felt it was pitched at the right level and at comfortable pace. The instructor was friendly and approachable. Overall very well done and a nice atmosphere.''
Florence Clark, Voodoo Research, HTML - 1 Day Introduction
''Very Good, All my questions were answered and I had a comprehensive introduction to Cinema4D. I will be coming back for the intermediate and advanced course along with an After Effects course.''
Fraser Crick, Estee Lauder, Cinema 4D - 2 Day Introduction
''I was very pleased with the course from start to finish, the course was very informative and the instructor was especially helpful. I would recommend this course to anyone.''
Steve Thomas, Robinsons Equestrian, Dreamweaver for Responsive Emails
''A very good syllabus that covered the basics needed for After Effects with links to other Creative Cloud packages.''
Lori Smith, IKM Consulting, After Effects - Two Day Introdcution
''Fantastic course and enthusiastic instructor. Thanks.''
Kelly Western, Video Combo - 5 Day Masterclass

Frequently Asked Questions:

What dates are available for this course?

As a bespoke course the date arrangement is based around your requirements and availability in our schedule. With your guide of when you are looking for the training we will advise suitable date options ahead of finalising the planned date(s).

Can the content be tailored to my requirements?

Yes we are flexible about tailoring content and can adapt to be fully based on your requirements, a mixture of content from different levels of our base courses or a base outline with some additional focus areas.

Can this course be delivered live online?

Yes we can provide the same bespoke course as a live online session connecting to you or your group with either Zoom or Microsoft Teams if preferred.

What is the cost to deliver the course onsite?

We are equally able to deliver our bespoke training onsite at your premises and the cost to deliver this is the same structure as classroom with the addition of basic expenses depending on your location. Onsite courses in and around London, Manchester and Glasgow are usually without additional costs.

Can the course include my work samples?

It is often possible to review and include consideration towards sample files however the main course content is usually structured around prepared examples which are best suited to the planned content and structure of teaching the required skills in the best format.