Excel 2007 Data Analysis FD (For Dummies Series) - Softcover

Nelson, Stephen L.

Softcover

ISBN 10: 047004599X ISBN 13: 9780470045992

Publisher: For Dummies, 2007

Synopsis

* 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* 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* 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

About this title

About the Author

Stephen L. Nelson, MBA, CPA, provides accounting, business advisory, tax planning, and tax preparation services to small businesses. He belongs to the American Institute of CPAs and is a prolific author.

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 your data

This handy guide helps you analyze the information you work with in your job to make better decisions. From grabbing external data to working with PivotCharts, database functions, and regression analysis, it shows you step by step how Excel can turn raw data into intelligible information.

Discover how to

• Import data into Excel
• Work with PivotTables
• Use database and statistical functions
• Customize PivotCharts
• Set up a Solver worksheet
• Perform regression analysis calculations

Edition details

• Publisher: For Dummies
• Publication date: 2007
• Language: English
• ISBN 10: 047004599X
• ISBN 13: 9780470045992
• Binding: Paperback
• Number of pages: 384