Contact Us

Contact Us






Excel Pivot Tables 1 Day | 7 hours | $449 PLUS TAX

Pivot Tables – one of the most powerful features of Excel – allow large amounts of data to be summarized and analyzed with just a few mouse clicks, and without any formulas. You'll be able to drag and drop fields directly into a Pivot Table to change your report layout to whatever you want, whenever you want. This one-day workshop culminates in building a sophisticated, yet uncomplicated dashboard that communicates financial information with power and ease you never thought possible. Prerequisite: Knowledge of Excel 1 

You will become comfortable with:

    » Preparing data for Pivot Table analysis
    » Creating Pivot Tables
    » Understanding the field list
    » Using Pivot Table options like “Classic” layout
    » Re-arranging your own layouts with quick Drag-n-Drop
    » Changing field settings and formats
    » Displaying your data as percentages
    » Pivot Table column calculations
    » Sorting; Custom grouping of rows
    » Creating Drill-down/up Pivot Tables
    » Cloning/copying Pivot Tables
    » Creating/using/formatting Slicers and Timelines
    » Connecting Slicers to multiple Pivot Tables
    » Creating and formatting Pivot Charts
    » Building and arranging Dashboards
    » and more…
  • Online: Runs on request