Quick Course Search

Bespoke Microsoft Excel - 1 Day Dashboards Training Course (Intermediate-Advanced users)

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

This course is designed to familiarise existing users of Microsoft Excel in the building of dashboards. It covers the essential knowledge and skills needed to create dashboards and interactive controls.

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: Advanced
Duration: 1 Day (10am-5pm)
Computer: Windows & Mac

Bespoke Microsoft Excel Dashboards 1 Day Overview

Excel Logo and Advanced 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.

XChange Training offer Microsoft Excel bespoke courses that are tailored to focus on your specific needs.

If you are interested in discussing bespoke training from XChange Training please contact our training department to discuss this option further or fill in our course-builder form and we’ll contact you with a proposed course outline tailored to your needs.


Course Target Audience and delegate prerequisites

This course is designed to familiarise existing users of Microsoft Excel in the building of dashboards.

Delegates wishing to attend this course must have attended the Microsoft Excel advanced course or be familiar with the topics that are outlined.

 

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: £495
  • 2 delegates: £595
  • 3 delegates: £645
  • 4 delegates: £695
  • 5 delegates: £745
  • 6 delegates: £795
  • 7 delegates: £845
  • 8 delegates: £895
Book this training course

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

Bespoke Microsoft Excel Dashboards 1 Day 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.

  • Recap of Pivot table and Pivot chart creation
  • Modify formatting options within a chart
  • Insert slicers and amend slicer settings
  • Creating linked tables using Countifs() and Sumifs()
  • Other useful functions in dashboard creation Index() , Match(), Offset() and Choose()
  • Working with conditional formatting on a Pivot table by using formatted values, colour Scales and icon sets
  • Build navigational links and control the “look and feel” of the dashboard worksheet e.g. controlling worksheet properties, alignment of objects and protection
  • Adding the camera tool to the quick access toolbar and using the tool to link to worksheet data
  • Create a group containing option buttons and link them into a chart
  • Use further interactive controls e.g. combo box and horizontal scroll bar
  • Create differing types of charts e.g. Pie of bar or bar of Pie
  • Formatting chart objects e.g. adding secondary axes, chart templates and mixed chart creation
  • 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: £495
    • 2 delegates: £595
    • 3 delegates: £645
    • 4 delegates: £695
    • 5 delegates: £745
    • 6 delegates: £795
    • 7 delegates: £845
    • 8 delegates: £895
    Book this training course

    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

    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: £495
    • 2 delegates: £595
    • 3 delegates: £645
    • 4 delegates: £695
    • 5 delegates: £745
    • 6 delegates: £795
    • 7 delegates: £845
    • 8 delegates: £895
    Book this training course

    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

    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: £495
    • 2 delegates: £595
    • 3 delegates: £645
    • 4 delegates: £695
    • 5 delegates: £745
    • 6 delegates: £795
    • 7 delegates: £845
    • 8 delegates: £895
    Book this training course

    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

    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 Dashboards 1 Day
    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: £495
    • 2 delegates: £595
    • 3 delegates: £645
    • 4 delegates: £695
    • 5 delegates: £745
    • 6 delegates: £795
    • 7 delegates: £845
    • 8 delegates: £895
    Book this training course

    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

    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: £495
    • 2 delegates: £595
    • 3 delegates: £645
    • 4 delegates: £695
    • 5 delegates: £745
    • 6 delegates: £795
    • 7 delegates: £845
    • 8 delegates: £895
    Book this training course

    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

    Testimonials

    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

    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

    Thank you for the InDesign training which both Paula and I found extremely efficient and a well taught.

    Pippa Coffin, James Glancy Design

    A very enjoyable, informative course in a relaxed friendly environment

    Clare Beanland, Unilever, Acrobat - 1 Day Introduction

    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

    Very relaxed atmosphere & friendly atmosphere. Trainer very informative, knowledgable and willing to help with any questions or difficulties. Offices in a good central location. An enjoyable and informative course.

    Kerry Duguid, Plant Integrity Mgmt., Illustrator - Two Day Introduction

    An amazing course! I feel I have learned so much and cant wait to put it in practice.. and I love the 6 months after care.

    Rizwana Matadar, Illustrator - 2 Day Advanced

    Thoroughly enjoyable course. I have learned a great deal over the two days, putting a lot of things into perspective.

    Jill Williamson, East of England Development Agency, HTML & CSS - 2 Day Introduction

    Great course, really good fun. The trainer had a fantastic grasp of the subject and was very helpful.

    Cath Levett, Javascript - 2 Day Introduction

    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: £495
    • 2 delegates: £595
    • 3 delegates: £645
    • 4 delegates: £695
    • 5 delegates: £745
    • 6 delegates: £795
    • 7 delegates: £845
    • 8 delegates: £895
    Book this training course

    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