Two great real-life examples (a training course booking system and a project RAG status report) of how to use Conditional Formatting to automatically change the background colour of cells based on the text value (i.e. words) in the cells
A question came up on my Twitter feed this week – how to sort a list of IP Addresses in Excel. On the face of it, this should be simple. However, because Excel treats the IP addresses as text strings, not numbers, the sort order will not be correct, for example...
A friend of mine created a spreadsheet to calculate how much it would cost him to change to a new mobile phone provider. The result scared him to death. According to his spreadsheet, based on his expected usage (he’s a low user) it was going to cost him almost £500...
My areas of specialisation include Microsoft applications (Excel, Access, PowerPoint, Word, SharePoint, Lync, VBA) and Apple Mac.
Business Solutions
Sometimes you don't want (or need) to be trained how to use an application. What you want is an "out-of-the-box solution.
In addition to delivering training, I design and develop solutions which will automate your key business tasks and processes and save you time and money.