Contact Us

Contact Us






    Excel Pivot Tables 1 Day | 7 hours | $395 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…
    • Runs on request