Excel Analysing Data with Pivot Tables and Dashboards

COURSE CALENDAR
Face-to-face Instructor Led Courses, IT and Computing, Microsoft Office

What Is Excel Analysing Data with Pivot Tables and Dashboards Training?

This course contains an overview of a wide range of features within Excel that when used together can be used to create interactive visual reports and dashboards. The course will show delegates how these features can be used individually to present data but can also be used in combination to make powerful and insightful reports. The course content has been pulled from a mix of our Excel courses, some content will be recapped to ensure all delegates are at the same level as they are used in conjunction with each other to effectively present data and build reports.

Who Should Attend

Any person who requires the need to be trained in Excel Analysing Data with Pivot Tables and Dashboards through the course of their normal working duties. This course is suitable for anyone working in the Microsoft Office arena or IT and Computing sector, pre-requisites may be required.

Course Agenda

- Top Data Analysis Formulas and Functions
- Preparing Data for Analysis
- Building Insightful Pivot Tables
- Summarising Pivot Table Data
- Grouping Pivot Data
- Running Totals in Pivot Tables
- Calculated Fields in Pivot Tables
- Conditional Formatting For Pivot Tables
- Pivot Charts
- Slicers
- Pivot Table Dashboards
- Using Simple Macros to make Reports and Dashboards interactive.

Venue

Excel Analysing Data with Pivot Tables and Dashboards training is available at training centres UK wide, using a virtual classroom with a live tutor or on client premises (as required) provided minimum delegate numbers are achieved. Parking, public transport links and refreshments vary from centre to centre and these will be confirmed to you prior to your enrolment on any course.

Accreditation

The Excel Analysing Data with Pivot Tables and Dashboards course will be accredited to the latest in recognised certificating award. All successful delegates will also receive an Xyz certificate of attendance. Enrolled subscribers of the National Training Card will also have any certificate, qualification and/or ID card (where applicable) automatically added to their member account.

More Information

Delegates should have attended the Excel level 2 course, or have equivalent knowledge.

Course Availability

Available on client premises as an in-house course or at one of training venues, provided minimum delegate numbers are achieved. Whatever your requirement, simply complete the enquiry form below and we'll send you our quotation by return.

Make A Excel Analysing Data with Pivot Tables and Dashboards General Enquiry Here

Complete the form below and we'll send you some training options and / or a quote by return. Please only use this form if you are interested in Excel Analysing Data with Pivot Tables and Dashboards courses. For all other enquiries, please use the general contact page, refine your search above or call us on 0844 335 8882.

Excel Analysing Data with Pivot Tables and Dashboards Training Enquiry
Open / Public Course Dates
Open Courses Unavailable
eLearning Options
eLearning Currently Unavailable
Excel Analysing Data with Pivot Tables and Dashboards
Part of our Microsoft Office range of training courses

Course Information

  • Course Duration 1 day
  • Max Class Size 12

  • All prices exclude VAT. Discounts available for larger groups & for corporate clients.
Our Excel Analysing Data with Pivot Tables and Dashboards Training Courses

Rated 4.2 / 5
*based on 115 client reviews.