Pivot Table Data Crunching for Microsoft Office Excel 2007
B. Jelen

This book consolidates all the best functionality of pivot tables into one guidethat provides you with a meaningful tutorial, offering practical solutions today-to-day problems. Within just the first 2 chapters, you will be creating basic pivot tables, increasingproductivity, and producing reports in minutes instead of hours. Within the first 6 chapters, you will learn how to use pivot tables to quicklyhighlight your top 10 customers or bottom 5 products in profitability; quicklycreate analysis comparing sales this period to last period by product or regionor both; easily summarize daily transactional data by month or quarter or year ina few mouse clicks–all without knowing any formulas! By the end of the book, you will truly be a pivot table guru, automating pivottables using VBA, creating pivot tables with external data in OLAP cubes, andeven creating dynamic reporting systems so that your managers can answer theirown queries with a few mouse clicks.  

Informacje dodatkowe o Pivot Table Data Crunching for Microsoft Office Excel 2007:

Wydawnictwo: angielskie
Data wydania: b.d
Kategoria: Informatyczne
ISBN: 978-0-7897-3601-7
Liczba stron: 0