Excel 2013: Pivot Tables
Offered By: LinkedIn Learning
Course Description
Overview
Learn to summarize, sort, count, and chart your data with PivotTables in these Excel tutorials.
Syllabus
Introduction
- Welcome
- What you should know before watching this course
- Using the exercise files
- Introducing PivotTables
- Formatting data for use in a PivotTable
- Creating a PivotTable
- Creating a Recommended PivotTable
- Pivoting a PivotTable
- Configuring a PivotTable
- Connecting to an external data source
- Consolidating data from multiple sources
- Managing PivotTables
- Managing subtotals and grand totals
- Changing the data field summary operation
- Summarizing more than one data field
- Creating a calculated field
- Grouping PivotTable fields
- Using PivotTable data in a formula
- Drilling down to the underlying data
- Sorting PivotTable data
- Creating a custom sort order
- Filtering a PivotTable field by selection
- Filtering a PivotTable by rule
- Filtering a PivotTable using a search filter
- Filtering a PivotTable using slicers
- Formatting slicers
- Filtering with report filter fields
- Clearing and reapplying PivotTable filters
- Applying a PivotTable style
- Creating a PivotTable style
- Changing the PivotTable layout
- Changing the data field number format
- Highlighting cells by applying a rule
- Highlighting the top or bottom values in a PivotTable
- Formatting cells using data bars
- Formatting cells using color scales
- Formatting cells using icon sets
- Editing a conditional formatting rule
- Controlling how multiple rules are applied
- Deleting a conditional formatting rule
- Creating a PivotChart
- Pivoting a PivotChart
- Filtering a PivotChart
- Formatting a PivotChart
- Changing a PivotChart's layout
- Changing a PivotChart's chart type
- Adding a trendline to a PivotChart
- Printing a PivotTable
- Printing headers at the top of each printed page
- Printing each item on its own page
- Printing a PivotChart
- Recording and reviewing an Excel macro
- Running an Excel macro
- Creating a simple PivotTable presentation kit
- Enabling PowerPivot in Office 2013 Professional Plus
- Introducing PowerPivot
- Importing PowerPivot data
- Adding tables to the data model
- Managing table columns
- Creating relationships between tables
- Creating a PowerPivot PivotTable
- Filtering data using a timeline
- Introducing the DAX language
- Using DAX operators
- Surveying DAX functions
- Adding calculated columns
- Adding calculated fields
- Creating aggregate calculations
- Creating filtered calculations
- Starting out with Power View
- Installing Microsoft Silverlight
- Creating a table or matrix
- Creating a card
- Creating a tile
- Filtering Power View objects
- Formatting Power View objects
- Creating a column or bar chart
- Creating a pie chart
- Creating a line chart
- Creating a map
- Creating maps with multivalue series
- Creating chart multiples
- Next steps
Taught by
Curt Frye
Related Courses
Intro to StatisticsStanford University via Udacity Introduction to Data Science
University of Washington via Coursera Passion Driven Statistics
Wesleyan University via Coursera Information Visualization
Indiana University via Independent DCO042 - Python For Informatics
University of Michigan via Independent