Excel 2013 Pivot Tables In Depth Training

Excel 2013: Pivot Tables in Depth

Join Curt Frye as he explains how to leverage PivotTables to summarize, sort, count, and chart your data in Microsoft Excel. Curt 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 enhance PivotTable with macros, DAX expressions, and the PowerPivot add-in for analyzing millions of rows of data.

Topics include:
Creating a PivotTable
Summarizing multiple data fields
Managing subtotals and grand totals
Grouping PivotTable fields
Filtering with selections, rules, slicers, and search filters
Applying PivotTable styles
Formatting cells
Creating PivotCharts
Enabling PowerPivot
Using DAX operators
Visualizing data with matrices, cards, and tiles
Building charts and maps

HugeFiles
0._Introduction.rar - 10.5 MB
1._Creating_and_Pivoting_PivotTables.rar - 49.9 MB
2._Summarizing_PivotTable_Data.rar - 32.2 MB
3._Sorting_and_Filtering_PivotTable_Data.rar - 43.9 MB
4._Formatting_PivotTables.rar - 22.8 MB
5._Applying_Conditional_Formats_to_PivotTables.rar - 52.2 MB
6._Creating_and_Manipulating_PivotCharts.rar - 27.1 MB
7._Printing_PivotTables.rar - 16.9 MB
8._Manipulating_PivotTables_Using_Macros.rar - 14.1 MB 9._Starting_with_PowerPivot_and_the_Data_Model25m_44s.rar - 35.1 MB
10._Introducing_Data_Analysis_Expressions.rar - 28.5 
11._Visualizing_Power_View_Data_Using_Matrices__Cards__and_Tiles.rar - 26.1 MB
12._Visualizing_Power_View_Data_Using_Charts_and_Maps.rar - 20.4 MB
Conclusion.rar - 1017 KB
Exercise_Files.rar - 2.3 MB

Tusfiles
0. Introduction.rar - 10.5 MB
1. Creating and Pivoting PivotTables.rar - 49.9 MB
2. Summarizing PivotTable Data.rar - 32.2 MB
3. Sorting and Filtering PivotTable Data.rar - 43.9 MB
4. Formatting PivotTables.rar - 22.8 MB
5. Applying Conditional Formats to PivotTables.rar - 52.2 MB
6. Creating and Manipulating PivotCharts.rar - 27.1 MB
7. Printing PivotTables.rar - 16.9 MB
8. Manipulating PivotTables Using Macros.rar - 14.1 MB
9. Starting with PowerPivot and the Data Model25m 44s.rar - 35.1 MB
10. Introducing Data Analysis Expressions.rar - 28.5 MB
11. Visualizing Power View Data Using Matrices_ Cards_ and Tiles.rar - 26.1 MB
12. Visualizing Power View Data Using Charts and Maps.rar - 20.4 MB
Conclusion.rar - 1017 KB
Exercise Files.rar - 2.3 MB

Go4Up

http://q.gs/884Z9

http://q.gs/884ZA

http://q.gs/884ZB

http://q.gs/884ZC

http://q.gs/884ZD

http://q.gs/884ZE

http://q.gs/884ZF

http://q.gs/884ZG

http://q.gs/884ZH

http://q.gs/884ZI

http://q.gs/884ZJ

http://q.gs/884ZK

http://q.gs/884ZL

http://q.gs/884ZM

http://q.gs/884ZN

http://q.gs/884ZO