Tags
Language
Tags
<<
April 2024
Su Mo Tu We Th Fr Sa
31 1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 1 2 3 4
  1. Home
  2. eBooks & eLearning

Excel 2016: Pivot Tables in Depth [Repost]

Posted By: IrGens
Date: 7 Jun 2016 17:42:23
Excel 2016: Pivot Tables in Depth [Repost]

Excel 2016: Pivot Tables in Depth
.MP4, AVC, 1000 kbps, 1280x720 | English, AAC, 64 kbps, 2 Ch | 3.7 hours | 568 MB
Instructor: Curt Frye

Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel 2016. Author Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to create PivotCharts to visualize your data, enhance PivotTables with macros, and use the Data Model feature to build PivotTables from related tables.

Topics include:

Formatting data for use in a PivotTable
Creating a new PivotTable
Connecting to data sources
Consolidating data from multiple data sources
Creating calculated fields
Summarizing field data
Sorting and filtering PivotTables
Working with Excel slicers
Formatting PivotTables with styles and formats
Applying conditional formats
Creating PivotCharts
Printing PivotTables
Running macros
Creating a PivotTable using the data model

More Info

Excel 2016: Pivot Tables in Depth [Repost]
PivotTablesinDepth.part1.rar
PivotTablesinDepth.part2.rar
PivotTablesinDepth.part3.rar
UPWARDS