Data Analysis with Pivot Tables

United Kingdom
Dates flexible
Course Type
Professional Training Course
Yes (Details)
Course Fee

Course Overview

Advances in technology have made it possible to store ever increasing amounts of data. Along with this the need to analyze that data and gain actionable insight is greater than ever. Being able to harness the power of advanced PivotTable features and create Pivot Charts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.

Who should take this course

Managers and staff taking this course are experienced. Excel users who are seeking to advance their data analysis capabilities by using PivotTables.



Course content

Preparing Data and Creating PivotTables. Prepare Data. Create a PivotTable from a Local Data Source. Create a PivotTable from Multiple Local Data Sources. Create a PivotTable from an External Data Source. Analysing Data Using PivotTables. Summarize PivotTable Data. Organize PivotTable. Data Filter PivotTable. Data Format a PivotTable Refresh and Change PivotTable Data. Working with Pivot Charts. Create a PivotChart Manipulate. PivotChart Data Format a PivotChart.

About Course Provider

London Training for Excellence offer a wide range of training courses in London for organisations and individuals who wish to advance their skills and knowledge in the business world. With a great training centre in London, London TFE have everything that is needed to understand the basic needs of a business. Each course focuses on the ‘real-life’ issues a business could face and how to tackle them with ease.

London TFE have a team of enthusiastic leaders and instructors who share a passion for education and want to deliver that same passion to every individual who wish to take a business to succession. Each training courses London encourages individual to aim high and reach their full potential.

How to enroll?

Provide us with your contact details, course provider will get back to you.

A representative from London Training For Excellence will contact you soon.