your one source for IT & AV

Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey | Standby Discounts

Excel Bits & Bytes: Creating Advanced Pivot Tables from Multiple Worksheets

SS Course: 3000707

Course Overview

To summarize and report results from separate worksheet ranges, you can consolidate data from each separate worksheet range into a PivotTable on a master worksheet. The separate worksheet ranges can be in the same workbook as the master worksheet or in a different workbook.                                                                  

Scheduled Classes

07/22/24 - VIR - Virtual Online Training - Virtual Instructor-Led (click to enroll)

What You'll Learn

By the end of the webinar, users should have a solid understanding of how to create and use PivotTables across multiple worksheets, enabling them to more effectively analyze and summarize data in their workbooks.


Viewing outline for:
  • Understanding the data structure
  • Combining data from multiple worksheets
  • Creating a PivotTable with multiple data sources
  • Using advanced PivotTable features
  • Refreshing and update the PivotTable
  • Prerequisites


    Who Should Attend

    Professionals in a wide range of industries, such as finance, accounting, sales, marketing, and more, as well as students and educators who use Excel for data analysis and reporting.

    Next Step Courses