Excel 2013 - Pivot Tables
About this courseCourse title: Excel 2013 – Pivot TablesCourse description: (A short description of the service with a slightly advertising/pitch feel)What you should already know: You should have a basic knowledge of Excel 2013. You should be able to create spreadsheets, rows, columns, formulas, and functions. You should be able to manage data, and…What you will learn:By the end of class, you will…What you will need:For this course, you will need a KU Online ID. Course objectives:By the end of this course, participants will be able to:Recognize Pivot Tables in Excel 2013.Recognize when Pivot Tables can be used for data summarization and analysis. Successfully set up existing spreadsheets to create meaningful Pivot Tables.Create new Pivot Tables in Excel 2013.Modify field selections and options, format data, manage relationships, use calculation fields, and group data in Pivot Tables to create data summaries.Insert slicers to quickly analyze Pivot Tables from a number of angles.Create Pivot Charts from Pivot Table summaries.Apply styles to Pivot Charts.Time: 2 hoursCourse Outline: What are Pivot Tables?How are they used?Why would I use Pivot tables?Examples of pivot tables/spreadsheets/dataHow to set up your spreadsheet to successfully create Pivot Tables.Create new Pivot TablesModify field selections and optionsFormat dataManage relationshipsGroup dataUse calculation fieldsInsert SlicersCreate, manipulate, and manage Pivot ChartsIntroduction to Pivot Tables:What are Pivot Tables?How are they used?Why would I use Pivot Tables?Part 1:How to set up your spreadsheet to successfully create a Pivot Table.Create a new Pivot Table from existing data.Part 2:Modify field selections and optionsFormat dataManage RelationshipsGroup dataUse calculation fieldsPart 3:What are slicers?Insert slicersUse slicersPart 4:Create Pivot ChartsModify Pivot ChartsApply styles to Pivot Charts ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- ms excel 2013 tutorial pdf
- microsoft excel 2013 help guide
- microsoft excel 2013 textbook pdf
- excel 2013 training manual pdf
- excel 2013 for beginners pdf
- excel 2013 shortcuts cheat sheet
- excel 2013 user guide
- microsoft excel 2013 manual pdf
- microsoft excel 2013 tutorial pdf
- excel relationships pivot table
- pivot tables in office 365
- pivot tables for dummies pdf