Limit this search to....

Excel Pivot Tables: Easy practical guide for everyone
Contributor(s): N, Dan (Author)
ISBN: 1720517088     ISBN-13: 9781720517085
Publisher: Createspace Independent Publishing Platform
OUR PRICE:   $10.44  
Product Type: Paperback
Published: June 2018
Qty:
Additional Information
BISAC Categories:
- Computers | Databases - General
Physical Information: 0.19" H x 6" W x 9" (0.29 lbs) 90 pages
 
Descriptions, Reviews, Etc.
Publisher Description:
This book is a guide for Excel users, business people and individuals on how to create and use Excel PivotTables. The author explains to you what PivotTables are and how they can be used. You will also know where PivotTables can be used and how they can benefit your business. The various steps involved in creation of a PivotTable have been discussed. First, PivotTables can easily be creating via the Excel interface. One only has to load the data to be used in this and do a number of clicks. They will then have the PivotTable created. This has been discussed. A PivotTable can also be created via an Excel Macro. The author guides you on how to create a PivotTable via Excel macros in a step-by-step manner. With PivotTables, you can add a slicer that will help you filter your data via the criteria that you need to use. You are guided on how to add these to your Excel PivotTable. Timelines are a good way of filtering your data via time. You will know how to work with these in Excel PivotTables. You will also know how to use data from different fields to create PivotTables. Here is a preview of what you'll learn:
  • What are PivotTables?
  • Using VBA Macros
  • Using Slicers
  • Adding a Timeline
  • Analyzing External Data
  • Changing Source Data
  • Creating a PivotTable from Multiple Tables
  • Arranging the Fields
  • Refreshing PivotTable Data
  • Deleting a PivotTable