Excel Pivot Tables

Excel PIVOT TABLES

ANALYSE YOUR DATA!

Please use the left and right arrows on the edge of each page to move through the presentation

CONTENTS

Create a PivotTable

Filter Data

Use the Field List

Create PivotCharts

Group Data

Time Well Spent!

Get in touch

CREATE A PIVOT TABLE

A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. Note PivotTables work a little bit differently depending on what platform you are using to run Excel.

Click on the image to access the Create a Pivot Table video

CONTENTS

Use the Field List

After you create a PivotTable, you'll see the Field List. You can change the design of the PivotTable by adding and arranging its fields.

Click on the image to access the Use the Field List video

CONTENTS

GROUP DATA

Grouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list of dates or times (date and time fields in the PivotTable) into quarters and months, like this image. Note: The time grouping feature is new in Excel 2016.

Click on the image to access the Group Data video

CONTENTS

FILTER DATA

After you create a PivotTable, you'll see the Field List. You can change the design of the PivotTable by adding and arranging its fields.

Click on the image to access the Filter Data in a PivotTable video

CONTENTS

pivot charts

Sometimes it's hard to see the big picture when your raw data hasn’t been summarized. Your first instinct may be to create a PivotTable, but not everyone can look at numbers in a table and quickly see what's going on. PivotCharts are a great way to add data visualizations to your data.

Click on the image to access the Create a PivotChart video

CONTENTS

Master macros and automate all your repetitive tasks

12

10

11

Understand formulas for easy, accurate calculations

Make sense of complex data with Pivot Tables

Use Excel's IF functions with ease

Enter data quickly with FlashFill

Get to grips with your data with Quick Analysis

Customise Excel to match how you work

Excel Training Time Well Spent

Create stylish and professional spreadsheets

Sort & filter data to find the answers you need

Spot trends with conditional formatting and spark lines

Speed up your work with shortcuts for every task

Create charts quickly and easily for maximum impact

THANKS FOR WATCHING

WWW.BLUENOVATION.CO.UK

PLEASE GET IN TOUCH

CONTENTS