Data Analysis and Business Modeling with Excel 2013

Table of Contents

1. Getting Data into Excel
2. Connecting to Databases
3. How to Clean Text Numbers and Dates
4. Using Formulas to Prepare Your Data for Analysis
5. Analyzing Your Data Using Descriptive Statistics and Charts
6. Link your Data using Data Models
7. A Primer on using the Excel Solver
8. Learning VBA Excels Scripting Language
9. How to Build and Style your Charts
10. Creating Interactive Spreadsheets using Tables and Filters
11. Tips Tricks and Shortcuts