Crossfooting is the Word of the Day. I woke up today and read a forum post about spreadsheet errors. Smart spreadsheet users include crossfooting to check the integrity of their spreadsheets and results. So: what is crossfooting? Crossfooting: calculating a...
What Are Pivot Tables Used For? What Are Pivot Tables Good For? Many of you have heard of Pivot Tables and aren’t sure what they are. I’ll leave you to Google how to mechanically get one working but if you’re like me, teaching the mechanics...
The Data Marshall returns to tell you about a feature in the forthcoming Excel 15. It’s going to be invaluable in Taming Dataville. There isn’t an official release date for Office 15 but there are previews and lots to be excited about. Check out this video...
There are plenty of tutorials about working inside spreadsheet cells: creating formulae, finding ways to extract elusive data, etc. However, some of the best Data Management attention is spent outside of the spreadsheet cells: development of the overall file. So...
Please don’t hold this against me: I don’t use Excel keyboard shortcuts. Why not? In the world of software CTRL+C and CTRL-V are almost universal for Copy and Paste. Beyond that I just got concerned about overlap and mentally keeping them straight. A key...
This video demonstrates one use of data generator results as follow-up to an earlier blog entry, Taming Dataville. In the video below, you will see: Use of dummy data While waiting for someone to create a Master List, I moved ahead by using random fish species where...
