Its a lot harder to explain a pivot table than to show you how one works, so lets take a look.

This data contains columns for date, customer, city, state, region, product, category, quantity, total sales.

To make sense of the information, we need to summarize it, and a pivot table is the perfect tool.

Once you create a pivot table, you can quickly transform huge numbers of rows and columns into a meaningful, nicely formatted report.

We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

My heart sank when I looked at a multi-line cell realised I needed each line in a separate column.

Worked a charm. Yes, I could have done it other ways but all of them would have been so much longer.

I sorted your method out in less time than it took me to send you this email.

Excel 2008 Pivot Table How To Gain More

Follow along with Curt Frye as he shows you how to gain more valuable insights from your datademystifying the complexity of PivotTables while demonstrating their power.

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.

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 speaker, he has presented talks on topics including Rhetorical Mathematics for CLE credit at the Law and Magic conference, Business Storytelling Using Microsoft Excel at the ATD-Cascadia annual conference, and his Improspectives approach to applying the techniques of improv theater to business and life for numerous audiences.

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.

Mastering the skills you need to manage pivot tables effectively will let you work quickly and make great decisions.

In this course, Ill use real-world examples to demonstrate how you can apply the incredible power of Excel pivot tables to your data.

Im Curt Frye. Join me at LinkedIn Learning for an introduction to the essential skills that will let you unlock the power and flexibility that comes with Excel pivot tables in Office 365 for Mac.

Follow along and learn by watching, listening and practicing.

Excel 2008 Pivot Table Download Courses Using

Download courses using your iOS or Android LinkedIn Learning app.

Excel 2008 For Mac Pivot Table