Introduction to Automation in Excel
Estimated Time Commitment: 4 Hours
This skill will help you automate data analyses using code. The lessons are organized around several useful tasks, including stacking multiple dataframes together into one dataframe, creating multiple histograms to accompany the descriptive statistics, and learning how to perform k-means clustering. After going through this skill, you will not only gain a foundation to help you understand coding, but you will also learn more about analyzing financial data. Along the way, I hope that you will also pick up on a few other useful Excel functions.
Upon successful completion, you will be able to:
Demonstrate how to record macros to perform repetitive tasks, and then identify how to edit the VBA code in VB Editor
Use the VB Editor to create a macro with VBA code for performing data assembly tasks
Use the VB Editor to create a macro that creates multiple histograms and to evaluate a macro that performs k-means clustering
Introduction Video
Introduction to the Skill
Glossary
Recording Macros
Basics of VB Editor
Basics of VBA
Knowledge Check 1
For Loops, Variables, Index Numbers, and Last Rows
Programming Hints
Conditional Statements
Knowledge Check 2
Macro for Creating Multiple Histograms
Clustering Overview
K-Means Clustering in Excel
K-Means Clustering Macro
Clustering on a Larger Scale
Knowledge Check 3
Instructions and Materials
Exercise Questions
Debriefing
Conclusion Video
Final Quiz
Survey Instructions
Feedback Survey
Survey Verification
Next Steps