In this episode, I discuss how to calculate trends over time in Excel for the purposes for forecasting future values. I reference an old post about calculating trends where someone recently left a comment about the counter-intuitiveness on calculating averages of changes in your values. In order to follow along with this episode, I would […]
In episode 12, I talked about how you can use the IMPORTRANGE() function in Google Sheets to import data form a source Google Sheet to a target Google Sheet. In this episode, I get a little more technical and discuss how you can import data using Google Apps Script. If you want to read the […]
Excel tables are a really powerful feature, but there are pros and cons to the feature depending on if you are an advanced or beginner Excel user. From what I’ve seen, most people who use Excel tables just to get the nice color formatting on the header row and the alternating banded rows color formatting. […]
Excel for the Real World III studentExcellent class for a beginner data analyst, great insight into this particular world, really appreciate it.
