This chapter is either going to push you toward becoming a developer or push you to stay on the analysis side of the house. VBA is a simple programming language and this means that you have to write code. Now, do not be discouraged as you have already been writing little bits of code. When did I write the code? Remember those formulas that we have been "coding" in the previous chapters. You were writing the code and this is the reason why you should not be afraid of Excel's VBA. Excel's scripting language is going to give you the power to automate repetitive tasks and get the work done faster using macros. You will now have the power to give Excel instructions and offload some of your data analysis steps to Excel. We are going to start by defining some terms, writing the VBA code, and finally, putting it to use.
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