PivotTables are powerful data analysis tools, yet most Excel users dont use them to their fullest potential. A Complete Guide to PivotTables: A Visual Approach shows you why PivotTables are so versatile for data analysis and how you can leverage PivotTables to rapidly spot trends and make fast business decisions on mountains of data.

A series of step-by-step tutorials and plenty of sample business data will help you get productive with PivotTables quickly and easily. Whereas most books only devote a small section to PivotTables, this book covers everything about this...

Excels what-if data analysis tools let you experiment with your data to project future results. In turn, these predictions will lead to better decision making and unlock the mystery of many business analysis scenarios. For example, what-if data analysis tools will enable you to forecast how lowering the price per unitwhile increasing projected unit salesmight affect your profit margins.

Beginning Excel What-If Data Analysis Tools explores the use of Goal Seek, Data Tables, Scenarios, and Solver to help you get insight on your data. This book is focused and to the point, and it...