Contact Us

Contact Us





    Microsoft Excel – Pivot Tables 1 Day | 6 hours | $425 PLUS TAX

    Pivot Tables are one of Excel's most powerful features, and they don't require a single formula. This Ottawa course teaches you to summarize, filter, and analyze large datasets with just a few clicks -- and build Pivot Charts that communicate findings clearly. Essential for anyone who works regularly with data in Excel. 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…
    More dates available.