» » » Excel 2016: Pivot Tables in Depth

Information of news
  • Author: Solid
  • Date: 13-01-2016, 22:05
13-01-2016, 22:05

Excel 2016: Pivot Tables in Depth

Category: Tutorials / Other

Excel 2016: Pivot Tables in Depth

Excel 2016: Pivot Tables in Depth
3h 42m | Video: h264, yuv420p, 1280x720 | Audio: aac, 44100 Hz, 2 ch | 675 MB
Intermediate | Jan 13, 2016 | Genre: eLearning | Language: English

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
http://uploaded.net/file/1g3hi1m1/Excel 2016 Pivot Tables in Depth.part1.rar
http://uploaded.net/file/prboz8nn/Excel 2016 Pivot Tables in Depth.part2.rar
http://uploaded.net/file/wyr9g2ia/Excel 2016 Pivot Tables in Depth.part3.rar

check my other posts



Site BBcode/HTML Code:
Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.

Tag Cloud

archive of news

free html hit counter