The Power of Pivot Tables and Lookups: Extracting Deeper Intelligence with Excel

Planning Information

The duration of this course is 3 hours.
Classes are priced from From $97.50. See individual sessions for details.


Description

Today’s organizations rely on business intelligence to achieve their strategic initiatives and maintain a competitive edge. Come learn how to harness the power of Pivot Tables and Lookups within Excel so you too can slice, dice, and analyze your data to achieve great things!


Prerequisites

If you are new to Excel, consider one of our full day courses instead as this intense 3-hour session is designed for seasoned Excel users that have yet to venture beyond their comfort zone. These individuals should have experience with:

  • Formatting Columns and Rows
  • Switching among worksheets and workbooks
  • Creating basic calculations in Excel

Course Outline

Part 1 – Extracting information from worksheets using Pivot Tables

Start out with a Pivot Table refresher. Then learn how to assemble data using Pivot Table features and functions. The icing on the cake – visualizing the results with charts and filters. Topics include:

  • Using the available aggregate functionality
  • Filtering the table using the Slicer Feature.
  • Creating multiple tables from the same worksheet
  • Creating Charts and adding filters
  • Creating basic reports using Pivot Tables

Part 2 – Finding information using Lookups

Got a lot of data? Harness the power of Lookups to quickly expose the trends that could lead to your next great success.

  • Comparing two lists for differences
  • Using traditional lookup functions
  • Using the new lookup functionality
  • Changing Excel options to help your search
  • Variations on Lookup functions

Pin It on Pinterest

Share This