We covered what VBA is and what a macro is all the way to creating sophisticated scripts to automate tasks. You learned about variables, data types, conditional statements, and loops. This alone will carry you very far in your programming journey. These concepts are very similar in many programming languages such as SQL, Python, and JavaScript. You got comfortable with the VBA Editor and got plenty of examples to create your very own Excel macros. We concluded the chapter with a very practical example of how you can leverage macros in your data preparation stage of the data analysis life cycle. From here, we will continue with the data presentation stage. In the next chapter, we will learn how to build effective charts to tell your very own data stories.
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