Lynda - Excel 2016: Pivot Tables in Depth
Categories: Tutorials
Lynda - Excel 2016: Pivot Tables in Depth - 431058
Lynda - Excel 2016: Pivot Tables in Depth
Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel 2016. Author Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to create PivotCharts to visualize your data, enhance PivotTables with macros, and use the Data Model feature to build PivotTables from related tables.


Table of Contents

  • Introduction
  • 1. Creating and Pivoting PivotTables
  • 2. Summarizing PivotTable Data
  • 3. Sorting and Filtering PivotTable Data
  • 4. Formatting PivotTables
  • 5. Applying Conditional Formats to PivotTables
  • 6. Creating and Manipulating PivotCharts
  • 7. Printing PivotTables
  • 8. Manipulating PivotTables
  • 9. Creating PivotTables Using the Data Model
  • Conclusion

    • Lynda - Excel 2016: Pivot Tables in Depth
    Information
    Members of Guests cannot leave comments.


    Categories Sitemap



    rss