Data Analysis and Business Modeling with Excel 2013
Manage, analyze, and visualize data with Microsoft Excel 2013 to transform raw data into ready to use information
Publisher:Packt Publishing Limited
Paid access
|Nov 2015
Table of Contents
- Getting Data into Excel
- Connecting to Databases
- How to Clean Text Numbers and Dates
- Using Formulas to Prepare Your Data for Analysis
- Analyzing Your Data Using Descriptive Statistics and Charts
- Link your Data using Data Models
- A Primer on using the Excel Solver
- Learning VBA Excels Scripting Language
- How to Build and Style your Charts
- Creating Interactive Spreadsheets using Tables and Filters
- Tips Tricks and Shortcuts
PDF ISBN: 978-1-78528-403-8
Publisher: Packt Publishing Limited
Copyright owner: © 2015 Packt Publishing Limited
Publication date: 2015
Language: English
Pages: 226
