|
Excel Pivot Tables and Pivot Charts: Your visual blueprint for creating dynamic spreadsheets |  | Author: Paul McFedries
Publisher: Visual
Category: Book
List Price: $26.99
Buy New: $9.52
as of 9/6/2010 20:35 EDT details
You Save: $17.47 (65%)
New (11) Used (15) from $4.31
Seller: thebookguyz
Rating:  3 reviews
Sales Rank: 504434
Media: Paperback
Edition: 1
Pages: 291
Number Of Items: 1
Shipping Weight (lbs): 1.4
Dimensions (in): 8.9 x 8 x 0.9
ISBN: 0471784893
Dewey Decimal Number: 005.54
EAN: 9780471784890
ASIN: 0471784893
Publication Date: March 20, 2006
Availability: Usually ships in 1-2 business days
| |
| Similar Items:
| |
| Editorial Reviews:
Product Description
Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 100 key techniques for creating PivotTables and PivotCharts, including:
* Building a basic PivotTable? report
* Pivoting fields to different areas
* Filtering PivotTable data
* Organizing PivotTable data into groups
* Formatting a PivotTable
* Changing the summary calculation
* Creating custom calculations
* Publishing a PivotTable to the Web
* Creating a PivotChart? from a PivotTable
* Building a PivotTable from external data
"I was stuck on an Excel problem for two days. Finally I opened one of your books, and there was a macro to accomplish exactly what I needed! You made me look good to the boss."
--Rob L. Meerscheidt (The Woodlands, TX)
* High-resolution screen shots demonstrate each task
* Succinct explanations walk you through step by step
* Two-page lessons break big topics into bite-sized modules
* "Apply It" and "Extra" sidebars highlight useful tips
|
| Customer Reviews:
Great book!...but March 2, 2010
Cesar Vallejo V (Guayaquil, Ecuador)
This book is an excellent guide to exploit the most important features of pivot tables and dynamics charts. It explains since fundamentals about those tables, its parts, and how you can use them. Something important to say is this book includes some guides (basic guides, however 100% valid), about business applications of pivot table, and I think that is a very important added value, in special for people who dont have deep knowledge about management, sales, etc (like me).
The only bad thing for me is I would have liked a CD with examples that include all functionality explained in the book without preparing and aligning my reports with those formulas or approach needed. This is my reason to rate this book with a 1 star less.
 Helpful September 29, 2006
Dr. Lee D. Carlson (Baltimore, Maryland USA)
7 out of 20 found this review helpful
Excel PivotTables and PivotCharts are widely used in the financial industry and those who intend to work in there must at least have some rudimentary knowledge of how to create or use them. This book gives a good introduction to the subject and is readily accessible to all who need learn it, even those readers who are not adept in Visual Basic. The latter is not really needed to create an effective PivotTable, but those readers who know Visual Basic will be able to create more customized PivotTables. Readers who need refreshing in Visual Basic will find a brief overview of it in one of the appendices to the book. Excel of course is not the tool of use if one is manipulating hundreds of megabytes of data, but it is, again, ubiquitous in finance and not likely to go away anytime soon. The author though shows how PivotTables can be constructed from large data cubes, with particular attention paid to OLAP cubes. Data modeling and business intelligence are now undergoing and explosion in all phases of business and industry, and PivotTables can be useful in these areas, even though they cannot be expected to handle large data sets. For small-to-medium data sets however, PivotTables are easily built and are an excellent way of reporting information to managers, team leaders, and other individuals who need a compact and visual representation of data. It will be interesting to see if some of the tools now being developed for business intelligence will replace PivotTables or even Excel for information reporting. Information-reporting tools definitely need to be "adaptive" in the sense of being able to deal with data as it comes into the business or laboratory. This means that these tools cannot be "brittle" and must be able to handle data that they have not seen before and then structure it automatically according to the needs of the business. PivotTables cannot do that at present, and so it is probable that they will take a back seat to the new information-reporting tools that are sensitive to the semantics of data, and can do so without the need of customized code or the intervention of a human programmer.
 PivotTables for skill Excel users September 4, 2006
Do (San Jose, CA, USA)
17 out of 18 found this review helpful
I think this book is great and helped me a lot to master both PivotTables and PivotCharts.
Before this book, I knew Excel very well and only the Pivot features were unkown to me. I like this book because it does not go over basic feature of Excel. The author assumes that you already know Excel very well.
If you do not feel very confortable with Excel, do not buy this book. I am pretty sure you will be very disappointed. However, I do not think an Excel beginner would be interested in learning about PivotTables at the first place.
In conclusion, if you want a solid book on PivotTables and PivotCharts and you know Excel very well, this is a great book. I would say this is THE book for you. I am very happy by this book, so will you.
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. Thank you for browsing ExcelBookstore.com! | |
