Both George Mount and Oz du Soleil have spent time as Commissions Analysts. Today, George and Oz discuss ways of handling negative numbers since Payroll can’t process a check for a negative amount. How do George and Oz address this in their Excel models? And what are other challenges that face real-world Commissions Analysts? The […]
This Funky Funktion Friday we look at the Anti Join in Excel’s Get & Transform (aka Power Query). The mission: matching songs & artists in an old list to find out what’s still missing on the new list. Thus, we do an anti-join to eliminate matches. The twist: a lot of songs have the same […]
Here’s the problem: WyattD KWilliam UBrian We need to separate the First Name and Last Initial but, for some names, the Last Initial is out front. So, we need to turn these into: Wyatt D William K Brian U Solution: CODE and Flash Fill My book: Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336 My blog: http://datascopic.net/blog2-2
Here’s my raw accent. The one that I try to cover over in my Excel tutorials. I recently discovered Accent Tag videos and decided to do one. I’m often asked about my accent and I don’t know where it came from. Most of my life has been spent in Chicago, but I’m asked if I’m […]
SSSVEDA 2016 has been great. A lot of good content was created. I’ve appreciated the comments, support and feedback. So, here’s a video thanking y’all, and sharing lessons I learned. LESSONS – A project like this reveals what a person gives a damn about. Being committed to something like this isn’t something you can phone […]
TIMELINE 0:00 – Context. Explanation of the need for cross-footing. “How would you know if the numbers are wrong?” 2:59 – My ghost pepper coffee recipe 4:57 – Example of Cross-footing This video begins with a story about an accountant who was annoying the hell out of me. She asked, “how would you know if […]
Today: a review of a fundamental element in Excel formulas: relative and absolute cell references. Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336 My blog: http://datascopic.net/blog2-2
Download the workbook here: http://datascopic.net/wine-calc This video is the result of someone at a wine restaurant who said he had transaction data by the glass and bottle but wanted a final calculation of “number of bottles” at the end of the week. Here’s high-speed footage of my actual development. I had no idea how I’d […]
Download the workbook here: http://datascopic.net/wine-calc This video is the result of someone at a wine restaurant who said he had transaction data by the glass and bottle but wanted a final calculation of “number of bottles” at the end of the week. Here’s high-speed footage of my actual development. I had no idea how I’d […]