Bespoke Microsoft Excel PowerPivot 1 Day
Key Course Details:
Level:
Advanced
Duration:
1 Day (10am-5pm)
Price:
From £595 + VAT
Dates:
Dates to suit you
This hands-on course has been designed for current intermediate-advanced users of Excel 2010 or 2013 who are looking to enhance their skills to use powerful PivotTables to manipulate, analyse and report on large amounts of data from varying sources.
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 hands-on course has been designed for current intermediate-advanced users of Excel 2010 or 2013 who are looking to enhance their skills to use powerful PivotTables to manipulate, analyse and report on large amounts of data from varying sources.
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 PowerPivot 1 Day
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.
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 for users with a good working knowledge of Microsoft Excel 365 and 2010-2021 who wish to use PivotTables to manipulate, analyse and report on large amounts of data from varying sources.
A good working knowledge of Microsoft Excel 2010 or 2013 to intermediate/advanced level, including formula and function writing. Basic understanding of Excel Pivot Tables -
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.
PivotTable Refresher- Creating a PivotTable
- Connecting to External Data with PivotTables
- The PowerPivot environment
- Connecting to different data sources
- Pasting data into PowerPivot
- Using an Excel worksheet as a data source
- Managing data in PowerPivot
- Importing data from Windows Azure Marketplace
- Using Excel linked tables as a data source
- Working in the PowerPivot Diagram View
- Managing relationships and tables
- Working with Hierarchies
Calculations and KPIs- Create a Calculated Column
- Creating a Calculated Field (Measure)
- Working with dates in PowerPivot
- Creating a KPI
- Adding a KPI to a PivotTable
- Overview of DAX Functions
- Writing DAX Functions
- Using Slicers with PivotTables or PivotCharts
- Locking a Slicer to a PivotTable or PivotChart
- Adding a Timeline to a PivotTable or PivotChart
-
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 CoursesCentral 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 CentreCentral 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 CentreCentral 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 CentreOnsite
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
Advanced courses in Microsoft Project for specific workflows (bespoke)Bespoke Microsoft Visio Training Courses
Advanced courses in Microsoft Visio for specific workflows (bespoke)Bespoke Microsoft Outlook Training Courses
Advanced training courses in Microsoft Outlook for specific needs (bespoke)Bespoke Microsoft Powerpoint Training Courses
Advanced training courses in Microsoft PowerPoint for specific needs (bespoke)Bespoke Microsoft Word Training Courses
Advanced training courses in Microsoft Word for specific needs (bespoke) -
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
''I have used XChange Training many times and I have been very happy with the training sessions, information supplied and the instructor's knowledge. Thank you for all your help in organising the courses.''
Margaret Nolan-Meddings, Miller Insurance Services LLP, Digital Publishing Suite - 1 Day Introduction
''The trainer was good and worked at a pace which can be followed easily. The trainer also provided additional information which will allow me to make an informed choice when developing websites.''
Sital Kerai, Park High School, Dreamweaver - 2 Day Introduction
''The course was on a one to one basis which was brilliant because it allowed me to follow my own path through it. The tutor was extremely helpful and had an excellent knowledge of the topic. Based on my experience today I would certainly consider using XChange Training again.''
Nick Mills, Landmark Information, Captivate - Bespoke 1 Day
''Hugely helpful and really appreciated the amount of tailoring and personalisation of the content of the course to what I would be doing in my role. Will definitely recommend. ''
Emily Radforth, Octopus Healthcare, Adobe Illustrator - One Day Introduction
''The tutor was excellent! He was very friendly and his instruction has surpassed my expectations. I am extremely impressed by how much I have learned and I would definitely recommend this course to my friends and colleagues. The course was worth every penny. Thank you so much!''
Jonathan Cain, HTML/HTML5 & CSS/CSS3 Masterclass
''Very good course, learned a lot that I can apply straight away.''
Gary McCall, Getty Images, Photoshop - 2 Day Introduction
''Fantastic two day course on InDesign, well worth doing. Staff very friendly. 10 out of 10''
Daniel Kosta, Icon Productions, InDesign - 2 Day 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.