Data Science Examples
Excel and VBA
I really like Excel – there are many Data Analytics programs out there, but you would be surprised at how far you can get with Excel.
Here are two files:
- An Excel File I keep, filled with examples of Models, Pivot Charts and Tables, Vlookup and more. You can get it here.
- A Macro file I made with VBA that Adds and formats headers to as many worksheets as you have, sums the total of the last row in each worksheets, and pastes the worksheets in an empty worksheet at the end. You can download the zipped XLSM file and text file of the Visual Basic code here.
Be sure to enable Macros in the Excel file so that you can run the Macros.