Excel Data Analysis For Dummies (eBook)

Stephen L. Nelson, E. C. Nelson (Autoren)

eBook Download: EPUB

2014 | 2. Auflage
360 Seiten
John Wiley & Sons (Verlag)
978-1-118-89808-6 (ISBN)

Infos

Harness the power of Excel to discover what your numbers arehiding

Excel Data Analysis For Dummies, 2nd Editionis the ultimate guide to getting the most out of your data. VeteranDummies author Stephen L. Nelson guides you through thebasic and not-so-basic features of Excel to help you discover thegems hidden in your rough data. From input, to analysis, tovisualization, the book walks you through the steps that lead tosuperior data analysis.

Excel is the number-one spreadsheet application, withever-expanding capabilities. If you're only using it to balance thebooks, you're missing out on a host of functions that can benefityour business or personal finances by uncovering trends and otherimportant information hidden within the numbers. Excel DataAnalysis For Dummies, 2nd Edition eliminates theneed for advanced statistics or analysis courses by allowing you toharness the full power of Excel to do the heavy lifting for you.This 2nd Edition is fully updated to include informationabout Excel's latest features, making it a your go-to Excel guidefor data analysis. Topics include:
* Working with external databases
* PivotTables and PivotCharts
* Using Excel for statistical and financial functions
* Solver, Small Business Finance Manager, and more

The book also includes a guide to chart types and formatting,and advice on effective visual data presentation. You already havethe data, so you might as well get something great out of it.Excel Data Analysis For Dummies, 2nd Edition isthe key to discovering what your numbers are hiding.

Autor

Stephen L. Nelson is an author and CPA who providesaccounting, business advisory, tax planning, and tax preparationservices to small businesses. He is the author of more than 100books, including QuickBooks For Dummies and Quicken ForDummies.

Inhalt

Introduction 1

Part I: Where's the Beef? 7

Chapter 1: Introducing Excel Tables 9

Chapter 2: Grabbing Data from External Sources 31

Chapter 3: Scrub-a-Dub-Dub: Cleaning Data 57

Part II: PivotTables and PivotCharts 79

Chapter 4: Working with PivotTables 81

Chapter 5: Building PivotTable Formulas 107

Chapter 6: Working with PivotCharts 127

Chapter 7: Customizing PivotCharts 141

Part III: Advanced Tools 155

Chapter 8: Using the Database Functions 157

Chapter 9: Using the Statistics Functions 177

Chapter 10: Descriptive Statistics 225

Chapter 11: Inferential Statistics 245

Chapter 12: Optimization Modeling with Solver 263

Part IV: The Part of Tens 287

Chapter 13: Ten Things You Ought to Know about Statistics289

Chapter 14: Almost Ten Tips for Presenting Table Results andAnalyzing Data 301

Chapter 15: Ten Tips for Visually Analyzing and Presenting Data307

Appendix: Glossary of Data Analysis and Excel Terms 319

Index 329

Produkt-Details

• Erscheint lt. Verlag: 14.4.2014
• Sprache: englisch
• Themenwelt: Informatik ► Office Programme ► Excel
• Schlagworte: Computer-Ratgeber • End-User Computing • Excel • Microsoft Excel
• ISBN-10: 1-118-89808-7 / 1118898087
• ISBN-13: 978-1-118-89808-6 / 9781118898086