Teaching analytics with modern Excel
An increasing number of jobs in industries as diverse as healthcare operations and maritime piracy analysis require quantitative aptitude.The response to prepare for this demand is often an emphasis …
Continue Reading about Data and the Liberal Arts Edge: Discussion with Matt Walje →
Paying commissions in Excel can be tricky. Not only does the data have to be 100% correct, it is structured differently than most financial data.It's not based on subaccounts or the general ledger -- …
Continue Reading about Paying Commissions in Excel: Understand Your Data →
This is a follow-up lesson from a great conversation I had recently with Oz du Soleil about paying commissions in Excel.In this video I cover another scenario:In most spreadsheet reports you have easy …
Continue Reading about Using logic between variables to add controls in Excel →
I had a great conversation this afternoon with Oz du Soleil about working with commissions and incentives in Excel.This is a key function of many financial analysts, including me.In this video we go …
Continue Reading about Lessons from a Commission Analyst: Interview with Oz du Soleil →
The other day I came across Gall's Law, developed in book on systems theory by pediatrician John Gall (polymath!). It's fascinating. Here is Gall's Law in all its fitting simplicity:Subscribe to the …
Continue Reading about How Gall’s Law Explains Crappy Spreadsheets →
I'm pleased to say that I made some pretty serious progress on the course this weekend. I am getting more comfortable with producing high-quality recordings and am locking down the logistics for …
