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.

Google Online Preview   Download