Use Excel with visual indicators to make lists easier to understand. Use IF function together with Conditional Formatting to display icons, text based on specific conditions There are so many possibilities available using Conditional Formatting or simple IF statements like these. Use IF Formula to show icons First, decide the conditions under which icons should […]
There’s a little trap in Excel when figuring out the number of days between two dates. Excel has one way, but the real world has two others. It’s easy to forget the differences and it can matter when the date calculation is close to some limit, for example in a Schenghen Visa Calculation. How Excel […]
Some readers may know that the Office Watch head honcho, Peter Deegan, goes to the famous Edinburgh Festivals each year. Here’s some shows he’s looking forward to seeing and a few sadly MIA in 2025. Get the most for less money (and hassle) at the Edinburgh Festivals Mitch Benn Mitch has been doing great shows […]
Good news for Excel on Mac users who like to “live dangerously” with more than one worksheet at a time. Excel for Mac is finally catching up with Windows to view multiple worksheets from the same workbook side-by-side. No more tabbing back and forth like you’re playing Whack-A-Mole with your data. Historically, Excel for Mac […]
Ever felt like your PowerPoint comments had a mind of their own, wandering off when you moved content around? At long last, PowerPoint has learned a new trick: keeping comments ‘sticky’ attached to their content, no matter where you paste it. Previously, moving content in PowerPoint was like playing a game of hide-and-seek with your […]
