Microsoft® Excel® 2013: Getting Started with PivotTables and PivotCharts is a two-lesson advanced level course that guides you through creating, formatting and modifying PivotTables and PivotCharts in Excel 2013 using step-by-step hands-on activities. In Lesson 1, you learn how to create a blank PivotTable; then use the Field List to manually arrange data in the PivotTable. Next you learn how to create a PivotTable using three additional methods-the Recommended PivotTables button, the Quick Analysis feature and the Summarize as PivotTable button with the Data Model. You learn how to format a PivotTable by applying Number formatting, changing the PivotTable layout, hiding and showing subtotals and grand totals and applying a PivotTable style. You also learn how to refresh a PivotTable when the underlying data is changed; how to filter a PivotTable; and how to rearrange the structure of a PivotTable. In Lesson 2, you learn to create a PivotChart from a PivotTable using multiple methods-the PivotChart button, standard Excel charting buttons and a keyboard shortcut-plus you learn how to create a PivotChart and its underlying PivotTable simultaneously. Next you learn to format the overall PivotChart by applying a chart style and chart layout; then you learn to format individual chart elements, such as the Chart Area, Axes and Titles using formatting task panes. Finally, you learn to modify a PivotChart by filtering it, changing its chart type/subtype, adding, removing and repositioning its fields and changing the underlying data’s row and column orientation. Note that this course emphasizes using the traditional keyboard and mouse actions to perform tasks in Excel 2013. Course Prerequisites The following Napier-Rivers LLC courses (or equivalent experience working with Excel 2013 in the Windows operating system environment) are prerequisites for this course Microsoft® Excel ® 2013: Getting Started with Excel, Microsoft® Excel ® 2013: Working with Formulas a
