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