MROUND() is lesser known but really useful rounding function in Excel, it’s worth considering for anyone dealing with cash money. In short: MRound() rounds up or down to the nearest multiple you choose. It’s very handy for rounding prices to match the lowest coin or note you want to handle, but it’ll have other uses […]
There’s an important difference between two seemingly similar Excel functions: Int() and Trunc() don’t always give the same results so we’ll explain how to choose wisely. Both Int() and Trunc() ‘shorten’ a number by removing digits to the right of the decimal place. Int() rounds the number, Trunc() doesn’t. And Trunc() has an option to […]
Here’s a complete list of the PowerPoint Function Key features from fast access to Help, jumping around the presentation, doc panes, spelling, grammar and guidelines. What you can do with the F-keys labelled F1 through F12 on your keyboard. Don’t like Function Keys? KeyTips are your way to faster Microsoft Office F1 – Help, hide ribbon […]
Office’s Document Inspector is supposed to remove or scrub information being accidentally included in Word, Excel or PowerPoint files. It’s not perfect and misses out on some critical hidden information that can give away secrets. Details in images, layers and even highlighting. Document Inspector is at File | Info in Office for Windows. The feature […]
Date handling in Excel can be confusing and it’s not your fault. Microsoft could do a better job. Here’s a quick guide to how Excel handles dates and date arithmetic with the settings you should know. What you see isn’t what’s saved What Excel shows in a cell is only a version of what’s actually […]
