
Lynda - Excel for Mac: PivotTables in Depth
Video: .MP4, 1280x720 | Audio: AAC, 48kHz, 2ch | Duration: 2h 7m
Genre: eLearning | Language: English | Size: 314 MB
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. Topics include: Formatting data for use in a PivotTable Creating a new PivotTable Connecting to external data sources Summarizing totals and other data fields Creating calculated fields Summarizing field data Sorting and filtering PivotTables Working with Excel slicers Formatting PivotTables styles and layouts Applying conditional formats Summarizing data visually using a PivotChart
Top Rated News
- Sean Archer
- AwTeaches
- Learn Squared
- PhotoWhoa
- Houdini-Course
- Photigy
- August Dering Photography
- StudioGuti
- Creatoom
- Creature Art Teacher
- Creator Foundry
- Patreon Collections
- Udemy - Turkce
- BigFilms
- Jerry Ghionis
- ACIDBITE
- BigMediumSmall
- Boom Library
- Globe Plants
- Unleashed Education
- The School of Photography
- Visual Education
- LeartesStudios - Cosmos
- All Veer Fancy Collection!
- All OJO Images
- All ZZVe Vectors