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. You'll 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 Excel's statistics functions for finding percentiles and standard deviations, doing regression analysis, and more