Picture 1 of 5
Gallery
Picture 1 of 5
Have one to sell?
Microsoft Excel Data Analysis For Dummies (Paperback, Brand New) Nelson
US $33.99
ApproximatelyS$ 43.72
Condition:
Brand New
A new, unread, unused book in perfect condition with no missing or damaged pages.
Oops! Looks like we're having trouble connecting to our server.
Refresh your browser window to try again.
Shipping:
Free USPS Media MailTM.
Located in: Sandy, Utah, United States
Delivery:
Estimated between Sat, 30 Aug and Thu, 4 Sep to 94104
Returns:
14 days return. Buyer pays for return shipping. If you use an eBay shipping label, it will be deducted from your refund amount.
Coverage:
Read item description or contact seller for details. See all detailsSee all details on coverage
(Not eligible for eBay purchase protection programmes)
Shop with confidence
Seller assumes all responsibility for this listing.
eBay item number:303618083082
Item specifics
- Condition
- Brand New: A new, unread, unused book in perfect condition with no missing or damaged pages. See all condition definitionsopens in a new window or tab
- ISBN
- 9781119077206
- EAN
- 9781119077206
About this product
Product Identifiers
Publisher
Wiley & Sons, Incorporated, John
ISBN-10
1119077206
ISBN-13
9781119077206
eBay Product ID (ePID)
219484417
Product Key Features
Number of Pages
384 Pages
Publication Name
Excel Data Analysis
Language
English
Subject
Desktop Applications / Spreadsheets
Publication Year
2015
Type
Textbook
Subject Area
Computers
Format
Trade Paperback
Dimensions
Item Height
1 in
Item Weight
20 Oz
Item Length
9.1 in
Item Width
7.4 in
Additional Product Features
Edition Number
3
Intended Audience
Trade
LCCN
2015-955631
Illustrated
Yes
Table Of Content
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
Synopsis
Learn to: Navigate and analyze complex data Work with external databases, PivotTables, and PivotCharts Use Excel for statistical and financial functions Make the most of the latest features of Excel Put the power of Excel to work and excel at data analysis! Most businesses are drowning in data, and making sense of it all is critical. Excel is a powerful data analysis tool, and this book shows you how to use it and become a data deciphering expert. Youll learn to organize data in workbooks, create powerful magic with PivotTables and PivotCharts, and explore advanced statistical tools that take you to the next level. Table your data learn to export data from a database, build a table, get data from external sources, and query databases Keep it clean delete unnecessary columns and rows in an imported workbook and clean your data with text functions This way and that see how to view your data from different angles using PivotTables Fine-tune with formulas build PivotTable formulas to create custom calculations and retrieve data from a PivotTable Chart your course create and customize PivotCharts to display data in various ways, even in a 3D chart Dive deeper check out a dozen database functions you can use for more detailed analysis Statistically speaking explore Excels statistics functions for finding percentiles and standard deviations, doing regression analysis, and more Open the book and find: Ways to use filters with tables All about exporting and importing data Essential text functions for cleaning data How to use the PivotTable and PivotChart wizards Tips on customizing a PivotTable When to use Chart Commands Different types of PivotCharts What you can do with descriptive statistics, 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 dont take full advantage of Excels data analysis tools., 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., 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.
LC Classification Number
HF5548.4.M523
Item description from the seller
Seller feedback (13,164)
- o***o (72)- Feedback left by buyer.Past monthVerified purchaseAs described and quickly shipped!
- 9***g (5)- Feedback left by buyer.Past monthVerified purchaseGood value, new quality and condition. Shipped well to maintain appearance.
- l***r (194)- Feedback left by buyer.Past monthVerified purchaseI love them! As described and arrived very quickly given how they came from overseas.
Seller feedback (13,164)
- o***o (72)- Feedback left by buyer.Past monthVerified purchaseAs described and quickly shipped!
- 9***g (5)- Feedback left by buyer.Past monthVerified purchaseGood value, new quality and condition. Shipped well to maintain appearance.
- l***r (194)- Feedback left by buyer.Past monthVerified purchaseI love them! As described and arrived very quickly given how they came from overseas.