Using Vlookup in Excel to work out tax, fees or commission from a table by David Goodmanson In part 1 we covered the basics of VLookup, let’s use it to calculate tax for a list of employees and their salaries. We’ve chosen this practical example because it contains a fixed amount plus a marginal percentage […]
Gmail stopped working, but Outlook users didn’t have to worry. Saul Hansell at the New York Times is reporting on an outage on the popular Gmail service. The Gmail breakdown happened at the start of the working day in Europe and lasted until about lunchtime. Early risers in the USA might have noticed the problem […]
How to format a Word or Excel document to print on someone else’s computer. On our new Twitter account we saw this question: ” When I send an Excel file to someone, should I have to set it up so they can print it? I don’t know the printer/size paper they use. “ It should […]
How to configure the list of recently used documents in Office and the glaring omission. The Most Recently Used (MRU) list is the list of documents you’ve recently opened in Word, Excel or PowerPoint. It is a handy way to reopen documents you’re currently working on but could be better. Setting the number In Word […]
Office Watch explains what can happen with Show Formulas in Excel and the simple fix. A slip of the fingers can make all your numbers disappear! An Office Watch reader wrote in a panic, her vital worksheet had gone crazy showing only formulas instead of numbers! She was the victim of a misplaced keystroke which […]
