Lynda - Excel 2010: Pivot Tables
Categories: Tutorials
Lynda - Excel 2010: Pivot Tables - 77968
Lynda - Excel 2010: Pivot Tables
In Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel PivotTables, including more advanced techniques such as using macros and the new PowerPivot add-in. The course shows how to connect and consolidate data sources to power PivotTables, sort and filter records, display data in a PivotChart, print tables and charts, and also introduces the DAX language for performing advanced summaries in PowerPivot. Exercise files are included with the course.


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 Formatting to PivotTables
  • 6. Creating and Manipulating PivotCharts
  • 7. Printing PivotTables and PivotCharts
  • 8. Manipulating PivotTables Using Macros
  • 9. Getting Started with PowerPivot
  • 10. Working with DAX Expressions
  • Conclusion

    • Lynda - Excel 2010: Pivot Tables
    Information
    Members of Guests cannot leave comments.


    Categories Sitemap



    rss