Excel Data Analysis For Dummies

Excel Data Analysis For Dummies
ISBN-10
1118898087
ISBN-13
9781118898086
Series
Excel Data Analysis For Dummies
Category
Computers
Pages
360
Language
English
Published
2014-04-14
Publisher
John Wiley & Sons
Authors
Stephen L. Nelson, E. C. Nelson

Description

Harness the power of Excel to discover what your numbers are hiding Excel Data Analysis For Dummies, 2nd Edition is the ultimate guide to getting the most out of your data. Veteran Dummies author Stephen L. Nelson guides you through the basic and not-so-basic features of Excel to help you discover the gems hidden in your rough data. From input, to analysis, to visualization, the book walks you through the steps that lead to superior data analysis. Excel is the number-one spreadsheet application, with ever-expanding capabilities. If you're only using it to balance the books, you're missing out on a host of functions that can benefit your business or personal finances by uncovering trends and other important information hidden within the numbers. Excel Data Analysis For Dummies, 2nd Edition eliminates the need for advanced statistics or analysis courses by allowing you to harness the full power of Excel to do the heavy lifting for you. This 2nd Edition is fully updated to include information about Excel's latest features, making it a your go-to Excel guide for 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 have the data, so you might as well get something great out of it. Excel Data Analysis For Dummies, 2nd Edition is the key to discovering what your numbers are hiding.

Other editions

Similar books

  • Statistical Analysis with Excel For Dummies
    By Joseph Schmuller

    What do you need to calculate? Manufacturing output? A curve for test scores? Sports stats? You and Excel can do it, and this non-intimidating guide shows you how.

  • Excel Data Analysis For Dummies
    By Stephen L. Nelson

    This is a book that assumes that you want to use Excel to learn new stuff, discover new secrets, and gain new insights into the information you’re already working with in Excel. Ready to take Excel to the next level?

  • Financial Modeling in Excel For Dummies
    By Danielle Stein Fairhurst

    If you’ve got this book and a working version of Microsoft Excel, you’ve got all the tools you need to build sophisticated and useful financial models in no time!

  • Excel Power Pivot & Power Query For Dummies
    By Michael Alexander

    Rev 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 ...

  • Microsoft Power BI For Dummies
    By Jack A. Hyman

    In Microsoft Power BI For Dummies, expert lecturer, consultant, and author Jack Hyman delivers a start-to-finish guide to applying the Power BI platform to your own firm’s data.

  • Excel 2019 For Dummies
    By Greg Harvey

    The bestselling Excel book on the market — now in a new edition covering the latest version of Excel!

  • Excel 2007 Dashboards and Reports For Dummies
    By Michael Alexander

    And, 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 All-in-One For Dummies
    By Greg Harvey, Paul McFedries

    Being 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, ...

  • Statistical Analysis with Excel For Dummies
    By Joseph Schmuller

    Means: The Lore of Averages . . . . . . . . . Calculating the mean ... . . . AVERAGE and AVERAGEA .. . AVERAGEIF and AVERAGEIFS TRIMMEAN ..... . . . . . . . . . . . . . . . . . . Other means to an end. . . . Medians: Caught in the ...

  • Excel 2016 Bible
    By John Walkenbach

    The complete guide to Excel 2016, from Mr. Spreadsheet himself Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs.