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. 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. 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. In Lesson 1, you learn how to create a blank PivotTable then use the Field List to manually arrange data in the PivotTable. 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. Microsoft® Excel® 2013: Getting Started with PivotTables and PivotCharts
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |