1 option
Excel : PivotTables in Depth / with Curt Frye.
- Format:
- Video
- Author/Creator:
- Frye, Curt, speaker.
- Language:
- English
- Genre:
- Instructional films.
- Educational films.
- Physical Description:
- 1 online resource
- Place of Publication:
- Carpenteria, CA : linkedin.com, 2024.
- 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.
- Summary:
- Learn how to summarize and analyze data using Excel's most powerful feature: PivotTables.
- PivotTables are one of the most powerful features in Excel, yet many users are barely scratching the surface of what they can do. 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. Learn how to sort and filter PivotTable data, format your PivotTable, and apply conditional formats. Curt also explains 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.
- Participant:
- Presenter: Curt Frye
- Notes:
- 4/23/202412:00:00AM
- Access Restriction:
- Restricted for use by site license.
The Penn Libraries is committed to describing library materials using current, accurate, and responsible language. If you discover outdated or inaccurate language, please fill out this feedback form to report it and suggest alternative language.