X Close Window

This document sets forth the Privacy Policy (the "Privacy Policy") for this Web site, www.xchangetraining.co.uk (the "Site"). If you have objections to the Privacy Policy, you should not access or use this Site. This Privacy Policy does not govern privacy practices associated with offline activities or other XChange Training UK Ltd web sites.

Our commitment

XChange Training UK Ltd are committed to ensuring the security and protection of the personal information that we process, and to provide a compliant and consistent approach to data protection. We have a robust and effective data protection program in place which complies with existing law and abides by the data protection principles.

XChange Training UK Ltd are dedicated to safeguarding the personal information under our remit with a data protection regime that is effective and fit for purpose with GDPR compliance.

Collection of personal information

As a visitor to this Site, you can engage in many activities without providing any personal information. In connection with other activities, such as course bookings, enquiries or subscribing XChange Training UK Ltd will ask you to provide certain information about yourself by filling out and submitting an online form with a consent request to contact you in compliance with GDPR law.

When you use the Site, XChange Training UK Ltd or third parties authorised by XChange Training UK Ltd may also collect certain technical and routing information about your computer to facilitate your use of the Site and its services. For example, we may log environmental variables, such as browser type and operating system of your computer. We use these environmental variables to facilitate and track your use of the site and its services. Without expressly informing you in each particular circumstance, we do not match such information with any of your personal information.

What personal information we collect

The information we collect is based on what you provide us which can include:

What we do with the information we gather

We require this information to understand your needs and provide you with a better service, and in particular for the following reasons:

Security

We are committed to ensuring that your information is secure. In order to prevent unauthorised access or disclosure, we have put in place suitable physical, electronic and managerial procedures to safeguard and secure the information we collect online.

Links to other websites

The Site contains links to other sites at which personal information is collected. In such instances, unless expressly provided to the contrary, the collection and use of your personal information will be governed by the privacy policy applicable to that site. That privacy policy should identify the entity that is collecting your personal information.

Use of cookies

XChangeTraining.co.uk is built without the use of cookies meaning when you visit this Site, you can browse the Site and access important information without revealing your identity.

Communications from the site

Users who no longer wish to receive our newsletter and promotional communications may opt-out of receiving these communications by replying to unsubscribe in the subject line in the email or email us at info@xchangetraining.co.uk.

In your correspondence, please indicate with as much detail as possible the location on this Site where you provided your personal information.

Entities collecting personal information

Personal information on this Site is collected by XChange Training UK Ltd who are located at: 5 St John's Lane, Clerkenwell, London, EC1M 4BH, United Kingdom and its phone number is: +44 (0)345 363 1130.

Controlling your personal information

If you have previously agreed to us using your personal information for direct marketing purposes, you may change your mind at any time by writing to or emailing us at info@xchangetraining.co.uk

We will not sell, distribute or lease your personal information to third parties unless we have your permission or are required by law to do so. We may use your personal information to send you promotional information about third parties which we think you may find interesting if you tell us that you wish this to happen. You may request details of personal information which we hold about you. If you would like a copy of the information held on you please write to XChange Training, 5 St John’s Lane, London, EC1M 4BH.

If you believe that any information we are holding on you is incorrect or incomplete, please write to or email us as soon as possible, at the above address. We will promptly correct any information found to be incorrect.

How your personal information is used

XChangeTraining.co.uk collects your information in order to record and support your participation in the activities you select. If you subscribe to a service or register a product, for example, the information is used to register your rights, if any, to technical support or other benefits that may be made available to registered users. Your personal information is also used to keep you informed about product upgrades, special offers, and other products and services of XChange Training UK Ltd and selected third parties if you have so opted to receive such communications.

XChangeTraining.co.uk may collect information about the use of the Site, such as the types of services used and how many users we receive daily. This information is collected in aggregate form, without identifying any user individually. XChange Training UK Ltd may use this aggregate, non-identifying statistical data for statistical analysis, marketing, or similar promotional purposes.

Privacy-related queries

XChange Training UK Ltd takes its users' privacy concerns seriously. If you believe that XChange Training UK Ltd has not complied with this Online Privacy Policy with respect to your personal information or you have other related inquiries or concerns, you may write to the XChange Training UK Ltd Privacy Officer at the address indicated above.

X Close Window

Get more from your data with Excel Calculations & formulas Pivot tables and Analytics VLOOKUP Scheduling Macro programming

Bespoke Microsoft Excel - Intermediate

Key Course Details:

Level:

Intermediate

Duration:

1 Day (10am-5pm)

Price:

From £449 + 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.

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.

  • 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.

    classroom image
  • 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 interactive training. Trainer was excellent. Thanks''

    Andy Doust, RRG Group, Microsoft Excel VBA 1 Day 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 pace and very clear directions. I will definitely be recommending XChange Training in the future. ''

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

    ''Excellent course. I have a better understanding of WordPress and feel confident to make greater use of it by improving the website my company currently has. I only booked a one day course but will certainly consider booking the second day at a later stage.''

    Angela Russell, Decision Lab, WordPress - 1 Day Introduction

    ''Very informative course and thank you to the tutor for her clear and concise training day. She was very thorough in covering the points we needed to be trained up on.''

    Chris Cann, Perivan, Microsoft Word - 1 Day Intermediate

    ''Fantastic training and very good knowledge from the instructor.''

    Martin Cahill, Assa Abloy, Captivate - 2 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

    ''I've learnt a great deal in the space of four days and am very much looking forward to using my new Photoshop skills at work in my job! I have a new found confidence in using Photoshop as part of the work I do and I never thought I'd be able to say that as before I just completely avoided using it. ''

    Emily Ball, Brandfuel, Photoshop - 2 Day Advanced

    ''Thank you very much for a really good course yesterday. I have been a Photoshop user for several years but this is the first time I have understood how the program works which is exactly what I wanted to achieve, as well as learn good practice and new techniques.''

    Robert Green, Larato, Photoshop 1 Day Introduction

    ''The trainer was extremely helpful and structured the course around our needs, what is more, he quickly saw what level I was at and pitched accordingly. Excellent.''

    Carole Lowe, Genius Gluten Free, Adobe LiveCycle - 2 Day Designer Introduction

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.