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 your numbers are wrong?"
My response was, basically, "because I'm experienced and know what I'm doing." That wasn't good enough for her. This lead to her teaching me the valuable concept of 'cross-footing.'
'Cross-footing' is a way of ensuring that you've accounted for all of your data and it adds up correctly. This is so important that I added a section on cross-footing in my book, Guerrilla Data Analysis, 2nd Ed.
In the second half of the video I share a simple example of crossfooting. It's a real-world example of a non-profit that receives donated items, and a way of keeping track of them all.
Along the way, you get to see my coffee recipe. :)
#Crossfooting
#ExcelTables
#ConditionalFormatting
Guerrilla Data Analysis 2nd Edition
[ Ссылка ]
My blog: [ Ссылка ]
