Synopsis This book shows ordinary users how to tap the rich data analysis functionality of Excel, make sense of their organization's critical financial and statistical information, and put together compelling data presentations. It is now revised with over 30 percent new content to cover the enhancements in Excel 2007, including the completely redesigned user interface, augmented charting and PivotTable capabilities, improved security, and better data exchange through XML. It provides thorough coverage of Excel features that are critical to data analysis - working with external databases, creating PivotTables and PivotCharts, using Excel statistical and financial functions, sharing data, harnessing the Solver, taking advantage of the Small Business Finance Manager, and more. From the Back Cover Unleash the power of Excel to make sense of your data The fun and easy way to gain new insights into yourdataThis handy guide helps you analyze the information you work within your job to make better decisions. From grabbing external datato working with PivotCharts, database functions, and regressionanalysis, it shows you step by step how Excel can turn raw datainto intelligible information.Discover how toImport data into ExcelWork with PivotTablesUse database and statistical functionsCustomize PivotChartsSet up a Solver worksheetPerform regression analysis calculations See all Product description
H**R
Fairly easy to use, but not for a complete PC novice
Provided you know your way around the basic Excel functions this guide is great. If you don't know how to switch a PC on or even open programmes it will go over your head. The step-by-step explanations are easy to follow and I've learned a lot from it. As with all the '...for Dummies' series it's clear and easy to follow.
R**Z
Computer assistance at its best.
Very helpful just what was required
P**S
Well structured and good tips
As a very experienced Excel user I wanted to expand my knowledge of pivots and data analysis capabilities inExcel. I found this book surprisingly useful.it is well structured and generally the examples are easy to follow. A worthwhile addition to my technical library.
M**K
Five Stars
Very helpful, so far. Written in understandable language.
K**N
Great for beginners (like me) and experienced Excel Users
As an Excel novice, this teaches me in "baby steps". Fabulous.
M**L
Very useful
Very informative, and answered all my questions in an understandable way. Highly recommended. Have also bought other 'dummy' books, and they're brill.
M**S
Great book for some excel guidance
I am a strong user of excel and this book is a great reminder of how to do things, it is compact and is a great reference tool