Excel Pivot Tables: Shortcuts, Tricks, and Time-Saving Tips to Crunch Data More Efficiently

webinar Excel Pivot Tables: Shortcuts, Tricks, and Time-Saving Tips to Crunch Data More Efficiently

You Will Learn:

  • How to customize toolbars, ribbons, and screen layout
  • Keys to adding video into your presentation and onto the web
  • Steps for integrating Excel, Word and other Microsoft applications with PowerPoint
  • Tips and tricks for better animation and effects
Watch the pre-recorded web conference
$269.00
 

Need to crunch loads of data in a short amount of time?

In about six mouse clicks you can easily create an Excel Pivot Table that not only summarizes your data, but saves you time and increases your efficiency.

In fact, this powerful and easy to use tool is ideal for quickly creating summary information that you can easily manipulate with drag-and-drop techniques, and gives you greater flexibility to:

  • Change row and column layouts
  • Sort and filter results
  • Compare multiple field summary contents
  • Drill down to see the details behind the summary
  • Perform ad hoc grouping of information
  • Categorize date and time data in multiple levels
  • Show multiple levels of totals in a variety of layouts

Learning Objectives

This practical webinar explores “best practices” for building and modifying Pivot Tables and the many “not so obvious” commands and tools that unleash the power in Pivot Tables, including:

  • Effectively creating and using multiple masters and layouts
  • How to customize toolbars, ribbons, and screen layout
  • Keys to adding video into your presentation and onto the web
  • Integration of Excel, Word and other Microsoft applications with PowerPoint
  • Tips and tricks for better animation and effects

You’ll also learn shortcuts , tricks, and time-saving tips for mastering Excel 2007 / 2010 Pivot Tables, as our instructor takes you step-by-step through:

  • Creating your first Pivot Table
  • Adding and moving fields inside your Pivot Tables
  • Adding additional summaries in your Pivot Tables
  • Converting a series of daily transactions in to a Month, Quarter, Year Summary
  • How to take advantage of the new Natural Language Filters in Pivot Tables
  • How to drill-down to the detail level for any Pivot Table Summary
  • Creating multiple reports that you can email or distribute with one command button
  • Creating interactive Pivot Table Charts
  • Applying professional formatting to Pivot Tables and Pivot Charts
  • Refreshing your Pivot Tables and Charts when new data is added

Product ID: 6566

Learn Shortcuts, Tricks, and Time-Saving Tips to Crunch Data More Efficiently!

Get it on demand now

Faculty

Amy Coyner
Amy Coyner
Software Instructor

Amy Coyner is a software instructor with over 16 years of experience. She received her Bachelor of Science at Salisbury University and then went on to become a training manager at Montgomery Ward.

Continuing Education Units

  • cpe

    Receive 1.25 CPE credits by attending the live Audio Conference! C4CM is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be addressed to the National Registry of CPE Sponsors, 150 Fourth Avenue North, Suite 700, Nashville, TN, 37219-2417. Web site: www.nasba.org

    Recordings of the program do not qualify for CPE credits. For more information regarding administrative policies such as complaint and refund, please contact our offices at 877-900-C4CM (2426).

    • Program Level : Intermediate
    • Prerequisites : This course is for participants with some exposure to the subject.
    • Advanced Preparation : None
    • Delivery : Group Live

Learn Shortcuts, Tricks, and Time-Saving Tips to Crunch Data More Efficiently!

Get it on demand now

Scroll To Top