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...
With the first glimpses of Excel 2013 (as part of Office 15) being released & reviewed it’s a good time to address two prognostications about Excel’s future. 1. EXCEL IS DEAD, IT HAS NO FUTURE I was on a conference call recently and the premise...
