Harness the Incredible Power of Excel Pivot Tables in 90 Minutes: Learn To Slice, Dice and Crunch Numbers with Expert Ability - Part 3

Instructor: Joe Weil
Product ID: 704624
  • Duration: 90 Min

recorded version

1x Person - Unlimited viewing for 6 Months
(For multiple locations contact Customer Care)
Recorded Link and Ref. material will be available in My CO Section

Training CD

One CD is for usage in one location only.
(For multiple locations contact Customer Care)
CD and Ref. material will be shipped within 15 business days

Customer Care

Fax: +1-650-963-2556


Read Frequently Asked Questions

This easy-to-follow Excel Pivot Table training program will help attendees harness all the impressive advantages of Excel Pivot Tables, Pivot Charts and Pivot Slicers. Learn to use this fun, versatile Excel tool to easily and readily manage data more effectively than you thought possible. Attendees will also be aided by an accompanying flowchart to supplement their understanding.

Why Should You Attend:

This 90-minute, easy-to-follow webinar will illustrate the use of Pivot Tables, Pivot Charts and Pivot Table Slicers to analyze sales data by state, sales person and sales location. Pivot Tables are very versatile and allow the Excel professional to rapidly change rows, columns, and other tools to slice and dice raw data for detailed analysis and presentation. These same Pivot Table tools can be used for accounts receivable, inventories, personnel and much more.

Pivot Table Charts give your data a dynamic view. Pivot Table Slicers allow you to automate data selection changes for managers who do not use Excel on a regular basis. This webinar will show you how to incorporate Pivot Table Slicers into your Pivot Table Charts for dynamic dashboard presentations. It’s easy to learn this. For Slicers, Excel 2010 or higher is recommended.

Other training programs in this Excel series:

Learning Objectives:

  • Set up your data and create a Pivot Table in less than 5 minutes
  • Understand how to activate the Pivot Table and use the Pivot Field for instant versatility
  • Place key business metrics in an interactive Pivot Table for improved, instant analysis
  • Expand and collapse levels of data for focused results
  • Creating impressive Slicers and Pivot Charts
  • Instantly interchange rows and columns of information for added clarity and analysis
  • Instantly organize, subtotal, sort and analyze numeric data - alphabetize as necessary
  • Summarize your data by categories and subcategories
  • Creating custom pivot charts to illustrate your data
  • Create slicers to allow any user to automatically manipulate your data
  • Show your data as numbers or percent of totals
  • Group your data by numeric ranges

Areas Covered in the Webinar:

  • Pivot Table Basics – Overview – How Excel Pivot Tables Work
    • Creating a Pivot Table and Pivot Chart – Excel Commands
    • Creating or Importing Your Data Base
    • Understanding the Columns or Fields
  • Using the Pivot Table Field List to Slice and Dice Your Data
    • Activating Your Pivot Table and Using the Special Pivot Table Toolbar
    • Field Selection, Row Labels, Values, Filters
    • Changing Rows and Columns Instantly
  • Using the Pivot Table Tools – Basics
    • Design – Styles, Page Layout, Subtotals, Format, and More
    • Options – Sort/Filter, Data Calculation, Logical Operands, and More
  • Creating and Manipulating Pivot Charts
    • How to Create and Format Your Pivot Chart
    • Filtering a Pivot Chart with Slicers
  • Using Slicers to Filter Pivot Tables – Formatting Filters for Easy Client Use
  • Grouping Data by Numeric Ranges

Who Will Benefit:

Managers, supervisors, financial professionals, administrative assistants, sales professionals, marketers — anyone who uses Microsoft Excel and wants to save hours, avoid using cumbersome tables and analyze data in the most proficient manner possible.

  • Banking
  • Finance
  • Marketing
  • Sales
  • Investments
  • Pharmacy
  • Accounts
  • Credit Unions
  • Audit

Instructor Profile:

A former corporate controller and director of auditing, Joe Weil, CPA, has 25+ years of Excel instruction/presentation experience. He holds a Master of Accounting degree and is a college Excel and auditing professor. Mr. Weil has led over 400 Excel presentations.

Follow us :
ComplianceOnline Banking Summit 2016 | Risk Management and Data Security - 80390SEM
21 CFR Part 11 Compliance for SaaS/Cloud Applications - 80202SEM

Product Reviews

This product hasn't received any reviews yet. Be the first to review this product! Write review

Best Sellers
You Recently Viewed