Excel Data Analysis For Dummies (For Dummies (Computer/Tech)), 4th Edition

Take Excel to the next level

Excel is the worlds leading spreadsheet application. Its 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, youll 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 youre 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.