Excel Pivot Table - Data Analysis with Pivot Tables

Excel Pivot Table - Data Analysis with Pivot Tables

If you use Excel, but don't know how to use Pivot Tables, you're missing out...wasting time trying to do things that a Pivot Table can do for you automatically. Core Pivot is a step-by-step Excel video course that will teach you everything you need to know to use this very powerful tool. With a small investment, Pivot Tables will pay you back again and again

The basics

• Why pivot tables are so powerful, and how to set up a pivot table in less than 2 minutes.

• What it means to refresh a pivot table, and how to refresh a pivot table when your data changes (pivot tables work like a formula, but they don't automatically pick up new data).

• The goofy names you need to know to talk about (and understand) the parts of a pivot table.

• How to "drill down" into a pivot table to extract the data (incredibly useful way to get just a subset of your data).

Build

• Why it makes sense to use an Excel Table for your pivot table (this one tip can save you hours of frustration).

• How you can set up a pivot table so that you can add data every day, week, or month and have it work correctly every time.

• How to add new fields to a pivot table, and easily move a field from one place to another.

• How to use (and understand!) pivot table layouts. (The default layout is often *not* what you want).

Calculate

• Why sometimes you get a count, and sometimes you get a sum (and how to get what you want).

• The best way to format numbers in a pivot table (Hint: don't select the numbers and apply a format...there's a much better way!)

• How to add and remove grand totals and sub totals with ease.

• How to rename pivot table fields (It's easy, and it can make your pivot table much nicer to look at.)

• The easiest way to add the same field more than once (so you show sales by product as both $ and %, for example).

• How (and why) you might want to add a calculated item or a calculated field to a pivot table (hands down the most confusing thing in the entire pivot table universe).

Group

• Perhaps the coolest feature in pivot tables is grouping. This is what gives you clean breakdowns by month and year, by product, etc.

• How to group a pivot tables by number (great for showing, say, purchases by age-range, or by order size).

• How to easily group by year, month, and quarter, and how to arrange those groupings any way you want. (Even a cool way to group by day of week).

• How to group by just moving things around. (Most people don't know that you can do ad hoc grouping almost way you like).

Sort, filter, and Slice

• How to sort a pivot table alphabetically, or by value.

• A simple way to sort a pivot table with your own custom list, automatically.

• How to manually sort a pivot table, so you can arrange the data any way you like.

• How to filter a pivot table globally (great for building a quick report by region, or manager, or product).

• How to filter to show only top values, or bottom values.

• How to apply more than one filter at the same time.

• How to filter by name or date.

• Slicers are a cool tool that lets you filter a pivot table with large interactive buttons rather than tiny little filters (perfect for managers that want just want to click things).

• How to add a slicer to your pivot table, and make it look nice.

• How to make a slicer control more than one pivot table (this is, by far, the easiest way to make a simple, interactive dashboard).

• An easy way to add more than one slicer.

Professional polish

• How to apply a style to your pivot table (instant formatting).

• How to create your own styles (a huge time saver when you start using pivot tables more often and want them to look the same).

• An easy trick to move a pivot table style into a new workbook (strangely non-obvious).

• How to create pivot charts, and get rid of all the extra clutter they bring.

And more...

• How to easily clone a pivot table when you want another view of the same data (a great time saver).

• How to make a "standalone" pivot table that brings its own data with it.

• How to group a pivot table by age range (an eye-opener to the power of pivot tables).

Building Pivot Tables, Group, Sorting, Filtering, Slicers, Calculations, Pivot Charts, Pivot Styles

Url: View Details

What you will learn

• Why pivot tables are so powerful, and how to set up a pivot table in less than 2 minutes
• What it means to refresh a pivot table, and how to refresh a pivot table when your data changes (pivot tables work like a formula, but they don't automatically
• The goofy names you need to know to talk about (and understand) the parts of a pivot table

Rating: 0

Level: All Levels

Duration: 2 hours

Instructor: Rajesh Reddy