مشخصات دوره :
نام دوره : Excel 2013 Pivot Tables in Depth
گروه اصلی : دوره های آموزشی Lynda
مدت زمان دوره : 4 ساعت و 20 دقیقه
قیمت دوره : رایگان
حداکثر زمان استفاده از دوره : نا محدود
سرفصل مطالب دوره :
00 - Introduction
01 - Welcome
02 - What you should know before watching this course
03 - Using the exercise files
01 - Creating and Pivoting PivotTables
01 - Introducing PivotTables
02 - Formatting data for use in a PivotTable
03 - Creating a PivotTable
04 - Creating a Recommended PivotTable
05 - Pivoting a PivotTable
06 - Configuring a PivotTable
07 - Connecting to an external data source
08 - Consolidating data from multiple sources
09 - Managing PivotTables
02 - Summarizing PivotTable Data
01 - Managing subtotals and grand totals
02 - Changing the data field summary operation
03 - Summarizing more than one data field
04 - Creating a calculated field
05 - Grouping PivotTable fields
06 - Using PivotTable data in a formula
07 - Drilling down to the underlying data
03 - Sorting and Filtering PivotTable Data
01 - Sorting PivotTable data
02 - Creating a custom sort order
03 - Filtering a PivotTable field by selection
04 - Filtering a PivotTable by rule
05 - Filtering a PivotTable using a search filter
06 - Filtering a PivotTable using slicers
07 - Formatting slicers
08 - Filtering with report filter fields
09 - Clearing and reapplying PivotTable filters
04 - Formatting PivotTables
01 - Applying a PivotTable style
02 - Creating a PivotTable style
03 - Changing the PivotTable layout
04 - Changing the data field number format
05 - Applying Conditional Formats to PivotTables
01 - Highlighting cells by applying a rule
02 - Highlighting the top or bottom values in a PivotTable
03 - Formatting cells using data bars
04 - Formatting cells using color scales
05 - Formatting cells using icon sets
06 - Editing a conditional formatting rule
07 - Controlling how multiple rules are applied
08 - Deleting a conditional formatting rule
06 - Creating and Manipulating PivotCharts
01 - Creating a PivotChart
02 - Pivoting a PivotChart
03 - Filtering a PivotChart
04 - Formatting a PivotChart
05 - Changing a PivotChart's layout
06 - Changing a PivotChart's chart type
07 - Adding a trendline to a PivotChart
07 - Printing PivotTables
01 - Printing a PivotTable
02 - Printing headers at the top of each printed page
03 - Printing each item on its own page
04 - Printing a PivotChart
08 - Manipulating PivotTables Using Macros
01 - Recording and reviewing an Excel macro
02 - Running an Excel macro
03 - Creating a simple PivotTable presentation kit
09 - Starting with PowerPivot and the Data Model
01 - Enabling PowerPivot in Office 2013 Professional Plus
02 - Introducing PowerPivot
03 - Importing PowerPivot data
04 - Adding tables to the data model
05 - Managing table columns
06 - Creating relationships between tables
07 - Creating a PowerPivot PivotTable
08 - Filtering data using a timeline
10 - Introducing Data Analysis Expressions (DAX)
01 - Introducing the DAX language
02 - Using DAX operators
03 - Surveying DAX functions
04 - Adding calculated columns
05 - Adding calculated fields
06 - Creating aggregate calculations
07 - Creating filtered calculations
11 - Visualizing Power View Data Using Matrices, Cards, and Tile
01 - Starting out with Power View
02 - Installing Microsoft Silverlight
03 - Creating a table or matrix
04 - Creating a card
05 - Creating a tile
06 - Filtering Power View objects
07 - Formatting Power View objects
12 - Visualizing Power View Data Using Charts and Maps
01 - Creating a column or bar chart
02 - Creating a pie chart
03 - Creating a line chart
04 - Creating a map
05 - Creating maps with multivalue series
06 - Creating chart multiples
13 - Conclusion
01 - Next steps
