Excel Data Analysis For Dummies
- ISBN-10
- 1119518164
- ISBN-13
- 9781119518167
- Series
- Excel Data Analysis For Dummies
- Category
- Computers
- Pages
- 352
- Language
- English
- Published
- 2018-11-13
- Publisher
- John Wiley & Sons
- Author
- Paul McFedries
Description
Take Excel to the next level Excel is the world’s leading spreadsheet application. It’s a key module in Microsoft Office—the number-one productivity suite—and it is the number-one business intelligence tool. An Excel dashboard report is a visual presentation of critical data and uses gauges, maps, charts, sliders, and other graphical elements to present complex data in an easy-to-understand format. Excel Data Analysis For Dummies explains in depth how to use Excel as a tool for analyzing big data sets. In no time, you’ll discover how to mine and analyze critical data in order to make more informed business decisions. Work with external databases, PivotTables, and Pivot Charts Use Excel for statistical and financial functions and data sharing Get familiar with Solver Use the Small Business Finance Manager If you’re familiar with Excel but lack a background in the technical aspects of data analysis, this user-friendly book makes it easy to start putting it to use for you.
Get the book
Other editions
Similar books
-
Excel Data Analysis For Dummies
By Stephen L. Nelson, E. C. NelsonPEARSON: Pearson correlation coefficient The PEARSON calculates a correlation coefficient for two data sets by using a different formula than the CORREL function does but one that should return the same result.
-
Financial Modeling in Excel For Dummies
By Danielle Stein FairhurstThis book shows you how to harness Excel's capabilities to determine profitability, develop budgetary projections, model depreciation, project costs, value assets and more.
-
Excel Power Pivot & Power Query For Dummies
By Michael AlexanderRev up your reporting fire up Power Pivot, build table relationships, and create robust pivot table reporting using multiple data sources Formulate a plan find out how to add formulas to Power Pivot reports and get the know-how to share ...
-
Excel 2007 Data Analysis For Dummies
By Stephen L. NelsonShows 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 ...
-
Predictive Analytics For Dummies
By Anasse Bari, Mohamed Chaouchi, Tommy JungThis practical book does not bog you down with loads of mathematical or scientific theory, but instead helps you quickly see how to use the right algorithms and tools to collect and analyze data and apply it to make predictions.
-
Excel Data Analysis for Dummies
By Stephen L. Nelson, Elizabeth C. NelsonMost businesses are drowning in data, and making sense of it all is critical. Excel is a powerful data analysis tool, and this books shows you how to use it and become a data deciphering expert.
-
Excel 2007 Dashboards and Reports For Dummies
By Michael AlexanderAnd, before long, everyone’s eyes will be riveted to your dashboards and reports too! This revolutionary guide shows you how to turn Excel into your own personal Business Intelligence tool.
-
Excel 2019 For Dummies
By Greg HarveyThe bestselling Excel book on the market — now in a new edition covering the latest version of Excel!
-
Excel Data Analysis for Dummies
By NelsonShows 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 ...
-
Excel All-in-One For Dummies
By Greg Harvey, Paul McFedriesBeing able to control which outline level is displayed in the worksheet makes it easy to print summary reports with ... when compared to word-processing outlines is that, most often, to calculate your summary totals in the worksheet, ...