Excel for Mac: PivotTables in Depth.
(eVideo)
Summary
Loading Description...
Also in this Series
Checking series information...
Subjects
Library of Congress Subjects
More Details
Format
eVideo
Language
English
Notes
General Note
6/17/201912:00:00AM
Participants/Performers
Presenter: Curt Frye
Summary
Learn how to summarize and analyze data using one of the most powerful and overlooked features in Excel for Mac: PivotTables.
Summary
Learn to quickly summarize, sort, and analyze data with one of the most overlooked features in Microsoft Excel for Mac: PivotTables. Follow along with Curt Frye as he shows you how to gain more valuable insights from your data-demystifying 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. Note: This course was recorded in Office 365 for Mac. However, much of the content will be useful to those working with Office for Mac 2019 and 2016.
System Details
Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScript and cookies must be enabled. A broadband Internet connection.
Citations
APA Citation, 7th Edition (style guide)
Frye, C. (2019). Excel for Mac: PivotTables in Depth . linkedin.com.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Frye, Curt. 2019. Excel for Mac: PivotTables in Depth. linkedin.com.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Frye, Curt. Excel for Mac: PivotTables in Depth linkedin.com, 2019.
MLA Citation, 9th Edition (style guide)Frye, Curt. Excel for Mac: PivotTables in Depth linkedin.com, 2019.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.
