VBA stands for Visual Basic for Applications and was primarily designed to give you the ability to extend Excel's features. By default, Excel already has a vast amount of tools to help you in the data analysis life cycle. We have already seen a small sample in the previous chapters of this book. The problem of performing repetitive tasks becomes very apparent when you are analyzing data. For example, you may be removing leading spaces constantly in your daily work. So, instead of creating formulas, you can create and write some VBA code and bind it to a keyboard shortcut. The next time you need to remove a leading space from a cell, you can just call the VBA code you wrote and it is instantly done. If it is not clear how VBA can help you, that is okay, as you can continue educating yourself and going through some examples, and then everything will make more sense.
Data Analysis and Business Modeling with Excel 2013
Data Analysis and Business Modeling with Excel 2013
Overview of this book
Table of Contents (18 chapters)
Data Analysis and Business Modeling with Excel 2013
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
Getting Data into Excel
Connecting to Databases
How to Clean Texts, 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 – Excel's Scripting Language
How to Build and Style Your Charts
Creating Interactive Spreadsheets Using Tables and Slicers
Tips, Tricks, and Shortcuts
Index
Customer Reviews