Data Science Examples
Power BI Dashboard
Excel, VBA, Financial Analysis and Accounting
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 three 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.
- Here is a Financial Analysis spreadsheet I made – it covers the basics of Financial Analysis and Accounting. You can find it here.
Be sure to enable Macros in the Excel file so that you can run the Macros.