Excel for Mac 2016: Pivot Tables in Depth

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2 Hours | 335 MB

Genre: eLearning | Language: English

Learn how to summarize, sort, and analyze your data in using one of the most overlooked features in Microsoft Excel for Mac 2016: pivot tables. Author Curt Frye shows you how to gain more valuable insights from your organization's data—demystifying the complexity of pivot tables while demonstrating their power. His tutorials show 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, create data bars, and share your pivot table results in printouts or via PDF.