Excel: PivotTables in Depth.
(Online Course)
Author
Contributors
Published
Carpenteria, CA linkedin.com, 2021.
Format
Online Course
Status
Description
Loading Description...
Also in this Series
Checking series information...
More Details
Language
English
Notes
General Note
11/17/202112:00:00AM
Participants/Performers
Presenter: Curt Frye
Description
Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel.
Description
Many Excel users aren’t sure how to use PivotTables. In this course, Excel power user Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. Curt explains how to build PivotTables from single or multiple data sources, pivot and configure a PivotTable, define a default PivotTable layout, and more. He demonstrates ways to summarize your data, add calculated fields, filter your results, and format your layout to make it more readable. Curt steps you through how to sort and filter PivotTable data, format your PivotTable and, and apply conditional formats. Plus, he goes over how to create PivotCharts to visualize your data, enhance PivotTables with macros, and use the Data Model feature to build PivotTables from related tables. Note: This course was recorded in Microsoft 365. However, anyone using a recent standalone version of Excel (Excel 2021, 2019, or 2016) should be able to follow along with the course contents.
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. (2021). Excel: PivotTables in Depth . linkedin.com.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Frye, Curt. 2021. Excel: PivotTables in Depth. linkedin.com.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Frye, Curt. Excel: PivotTables in Depth linkedin.com, 2021.
MLA Citation, 9th Edition (style guide)Frye, Curt. Excel: PivotTables in Depth linkedin.com, 2021.
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.