Contact Us

Contact Us





    Microsoft 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…
    • Online:
    • May 19
    • Jun 13
    • Aug 09
    • Sep27
    • Also runs on request.