Viewing Word Documents in Excel
Years ago I developed an Access database to manage shipping containers for a distribution centre. The solution needed to display the location and stacked position of 20 and 40 foot shipping containers on a 30-by-30 grid where each square in the grid represented a 20-foot area. The approach I took was to embed an Excel workbook on […]
Continue readingWhat version of Excel are you really using?
Knowing the precise version of Excel can save hours or days of frustration. I remember when my circle of friends were all turning 18, getting their driver’s licence and buying a car. In suburban Melbourne, no car meant no social life. After one of my close friends got her licence and brought a second-hand car, I […]
Continue readingMind the (Excel) Gap
When I moved to London in 2007, I found the fastest way to get around was the underground train network affectionately called “the Tube”. It’s the oldest underground train network in the world with the first section opening in 1863. If you’ve ever travelled on the Tube you’ll be familiar with the phrase “Mind the Gap”. This […]
Continue readingSpeed Up Data Entry in Excel with Prompts
Have you ever created a spreadsheet people used to enter data? A bit like a data entry form, but on a worksheet?You may have wondered how to make the form more intuitive. That way your users knew what they should enter in each field.If that’s the case, this post is for you.Making Data Entry More […]
Continue reading