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. Veteran Dummies 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 Data Analysis 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
* Pivot Tables and Pivot Charts
* 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.
Зміст
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: Pivot Tables and Pivot Charts 79
Chapter 4: Working with Pivot Tables 81
Chapter 5: Building Pivot Table Formulas 107
Chapter 6: Working with Pivot Charts 127
Chapter 7: Customizing Pivot Charts 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 and Analyzing Data 301
Chapter 15: Ten Tips for Visually Analyzing and Presenting Data307
Appendix: Glossary of Data Analysis and Excel Terms 319
Index 329
Про автора
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 Quick Books For Dummies and Quicken For Dummies.
Більше електронних книг того самого автора / Редактор
16 598 Електронні книги в цій категорі
