Pivot Tables In Excel How To Build PivotTables
Pivot Tables In Excel Mac 2019 And
Pivot Tables In Excel Download Courses Using

Pivot Tables In Excel How To Build PivotTables

Curt shows how to build PivotTables from Excel workbooks or external data sources, add calculated fields, filter results, and format your layout to make it more readable.

Plus, learn how to use conditional formatting to intelligently highlight cells, apply color scales, and format cells using data bars, as well as how to create and format PivotCharts.

Pivot Tables In Excel Mac 2019 And

However, much of the content will be useful to those working with Office for Mac 2019 and 2016.

He is the author of more than 40 books, including Microsoft Excel 2019 Step by Step for Microsoft Press, and has created and recorded more than 60 courses for Lynda.com and LinkedIn Learning.

As a performer, he has appeared in over 1,300 improv comedy shows with ComedySportz Portland and presents his Magic of the Mind show to theatrical and corporate audiences.

Curt earned his BA in political science from Syracuse University and his MBA from the University of Illinois.

A pivot table lets you rearrange, sort, and filter a data set on the fly so you can analyze it from several different perspectives with a minimum of effort.

In this movie, I will show you how to create a pivot table from an Excel table that is stored in the same workbook.

My sample file is 0103Create and you can find it in the chapter one folder of your exercise files collection.

This workbook contains an Excel table and in it you see I have order data, so I have the Order ID, Order Date, and so on.

To create a pivot table based on this data I click any cell within the body of the table and then go to the insert tab of the ribbon, and at the far left click pivot table.

And the one that is selected is table three, and that is the name for the table that Im working with.

Follow along and learn by watching, listening and practicing.

Pivot Tables In Excel Download Courses Using

Download courses using your iOS or Android LinkedIn Learning app.

Pivot Tables In Excel For Mac