Book Image

Data Analysis and Business Modeling with Excel 2013

Book Image

Data Analysis and Business Modeling with Excel 2013

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
Data Analysis and Business Modeling with Excel 2013
Oct, 2015 | 226 pages
No titles found
Table of Contents (18 chapters)
Data Analysis and Business Modeling with Excel 2013
Data Analysis and Business Modeling with Excel 2013
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Getting Data into Excel
Getting Data into Excel
Getting started with data
Manually creating data
Importing data from various sources
Summary
2
Connecting to Databases
Connecting to Databases
Reading a table from MSSQL – the Microsoft SQL Server database
Reading multiple tables from MSSQL
Reading from MSSQL using SQL
Summary
3
How to Clean Texts, Numbers, and Dates
How to Clean Texts, Numbers, and Dates
Leading/trailing/in-between spaces
Capitalization
Duplicates
Text to Columns
Combine data from multiple columns into one column
Fixing similar words
Text to dates
Text to numbers
Summary
4
Using Formulas to Prepare Your Data for Analysis
Using Formulas to Prepare Your Data for Analysis
How to create formulas
Combining strings and numbers
Using built-in functions
If/else/then statements
Comparing columns
Summary
5
Analyzing Your Data Using Descriptive Statistics and Charts
Analyzing Your Data Using Descriptive Statistics and Charts
Gathering data
Preparing the data for analysis
Analyzing our data
Summary
6
Link Your Data Using Data Models
Link Your Data Using Data Models
Gathering data
Preparing data
Analyzing data
Data models
Summary
7
A Primer on Using the Excel Solver
A Primer on Using the Excel Solver
Activating the Excel Solver
Modeling our linear programming problem
Using the Excel Solver
Summary
8
Learning VBA – Excel's Scripting Language
Learning VBA – Excel's Scripting Language
What is VBA?
What is a macro?
Opening the VBA Editor
Your very first "Hello World" VBA script
Summary
9
How to Build and Style Your Charts
How to Build and Style Your Charts
Quick analysis charts
Charting options
Additional design options
Summary
10
Creating Interactive Spreadsheets Using Tables and Slicers
Creating Interactive Spreadsheets Using Tables and Slicers
What are slicers?
Final tweaks
Summary
Tips, Tricks, and Shortcuts
Tips, Tricks, and Shortcuts
Shortcuts
Tips and tricks
Index
Index

What is a macro?

An Excel macro is a set of instructions that can be run over and over again. These instructions are written in VBA, thus a macro is created by writing the VBA code. You can also create a macro without writing any VBA code, but getting some exposure to a macro will be beneficial to you.

Previous Section
End of Section 3
Next Section