If your dataset doesn’t have a unique identifier (e.g. customer ID, location ID, etc.), sometimes you have to make one up. The reason you need this unique ID is to summarize your dataset into a nice report to be shared with a client or internal stakeholders. Usually your dataset will have some kind of unique […]
When I worked in FP&A, I discovered that VBA could automate a lot of tedious tasks I was doing in Excel. From creating charts to formatting data, I realized that there possibilities with VBA were endless. As I started using Google Sheets more, I found that Google Apps Script offers similar functionality to extend what […]
Excel for the Real World I studentI use Excel and basic formulas already but there were basic techniques that I missed so this was great to fill in those gaps. On to class 2!
Emerald Green Cover for Mac Excel $24.99 
Hot Pink Cover for Mac Excel $24.99 
Clean Gray Cover for Mac Excel $24.99 
