Overview

Want to take the guesswork out of analyzing data? Let Excel do all the work for you! Data collection, management and analysis is the key to making effective business decisions, and if you are like most people, you probably don't take full advantage of Excel's data analysis tools. With Excel Data Analysis For Dummies, 3rd Edition, you'll learn how to leverage Microsoft Excel to take your data analysis to new heights by uncovering what is behind all of those mind-numbing numbers. The beauty of Excel lies in its functionality as a powerful data analysis tool. This easy-to-read guide will show you how to use Excel in conjunction with external databases, how to fully leverage PivotTables and PivotCharts, tips and tricks for using Excel's statistical and financial functions, how to visually present your data so it makes sense, and information about the fancier, more advanced tools for those who have mastered the basics! Once you're up to speed, you can stop worrying about how to make use of all that data you have on your hands and get down to the business of discovering meaningful, actionable insights for your business or organization. Excel is the most popular business intelligence tool in the world, and the newest update ? Microsoft Excel 2016 ? features even more powerful features for data analysis and visualization. Users can slice and dice their data and create visual presentations that turn otherwise indecipherable reports into easy-to-digest presentations that can quickly and effectively illustrate the key insights you are seeking. Fully updated to cover the latest updates and features of Excel 2016 Learn useful details about statistics, analysis, and visual presentations for your data Features coverage of database and statistics functions, descriptive statistics, inferential statistics, and optimization modeling with Solver Helps anyone who needs insight into how to get things done with data that is unwieldy and difficult to understand With Excel Data Analysis For Dummies, 3rd Edition, you'll soon be quickly and easily performing key analyses that can drive organizational decisions and create competitive advantages.

Full Product Details

Author:   Stephen L. Nelson ,  E. C. Nelson
Publisher:   John Wiley & Sons Inc
Imprint:   John Wiley & Sons Inc
Edition:   3rd Edition
Dimensions:   Width: 18.90cm , Height: 2.50cm , Length: 23.40cm
Weight:   0.730kg
ISBN:  

9781119077206

ISBN 10:   1119077206
Pages:   384
Publication Date:   14 December 2015
Audience:   Professional and scholarly ,  General/trade ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Active
Availability:   In Print  
This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us.

Table of Contents

Introduction 1 Part I: Getting Started with Data Analysis 7 Chapter 1: Introducing Excel Tables 9 Chapter 2: Grabbing Data from External Sources 31 Chapter 3: Scrub-a-Dub-Dub: Cleaning 59 Part II: PivotTables and PivotCharts 81 Chapter 4: Working with PivotTables 83 Chapter 5: Building PivotTable Formulas 111 Chapter 6: Working with PivotCharts 133 Chapter 7: Customizing PivotCharts 147 Part III: Advanced Tools 161 Chapter 8: Using the Database Functions 163 Chapter 9: Using the Statistics Functions 183 Chapter 10: Descriptive Statistics 237 Chapter 11: Inferential Statistics 257 Chapter 12: Optimization Modeling with Solver 277 Part IV: The Part of Tens 303 Chapter 13: Ten Things You Ought to Know about Statistics 305 Chapter 14: Almost Ten Tips for Presenting Table Results and Analyzing Data 317 Chapter 15: Ten Tips for Visually Analyzing and Presenting Data 323 Appendix: Glossary of Data Analysis and Excel Terms 335 Index 345

Reviews

Author Information

Stephen L. Nelson provides accounting, business advisory, tax planning, and tax preparation services to small businesses. He belongs to the American Institute of CPAs and teaches graduate tax courses. Among Steve's 100-plus books are all editions of QuickBooks For Dummies and Quicken For Dummies. Elizabeth C. Nelson is a CPA and specializes in multi-state and international taxation of S corporations and partnerships. She holds a Bachelor of Science in Accounting from Western Governors University and is the co-author of the popular monographs Preparing the 3115 Form for the New Tangible Property Regulations and Small Businesses and the Affordable Care Act.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions