Business Analytics iCademy: Introduction to Automation in Excel

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. Learning Outcomes - 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