Home > Store > Computer Software > Business Office Software > Spreadsheet Software > Microsoft Excel

Part VII: Tips, Downloadable Version

Part VII: Tips, Downloadable Version

Downloadable Video

  • Your Price: $15.99
  • About this video
  • Accessible from your Account page after purchase. Requires the free QuickTime Player software.

    Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.

Additional sample videos, individual lessons and other formats are available here.

Register your product to gain access to bonus material or receive a coupon.

Audio & Video

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.


  • Copyright 2013
  • Edition: 1st
  • Downloadable Video
  • ISBN-10: 0-13-348021-6
  • ISBN-13: 978-0-13-348021-4

These eight tips will save you time and frustration! In just under 40 minutes you'll learn how to:

Base your pivot table on a Table When New Data Might Be Added

Show Yes/No As the Values in a Pivot Table

Create Perfectly Formatted Pivot Tables Using GETPIVOTDATA

Create a Worksheet for Every Customer Using Show Report Filter Pages

Controlling Multiple Pivot Tables with One Set of Slicers

Reduce Pivot Table Workbook Size by 50% Before Sending

Create a Pivot Table from Access Data

Create a chart from a pivot table with Pivot Charts


Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership