The Office Watch “Shortcut of the Week” tips for Outlook, Excel and PowerPoint from 2005 in the one convenient place. Tip 1 – Outlook navigation The Outlook navigation shortcuts could be more intuitive but here they are: Switch to Mail CTRL+1 Switch to Calendar CTRL+2 Switch to Contacts CTRL+3 Switch to Tasks CTRL+4 Switch to […]
It is possible to add videos to a PowerPoint Kiosk or self-running presentation. Recently we’ve talked about Self-running of kiosk display in PowerPoint as well as the related PowerPoint Photo Album feature. But what about video’s? You can add videos to a PowerPoint presentation, you’ve been able to do that for years but it’s become […]
How to type Ghana Cedi currency character in Windows or Office, especially Word. After our article about inserting Numero and other symbols into Office – trust an Office Watch reader to find a character not available in a supplied Windows / Office font: ” The currency in Ghana is the Cedi. The symbol used is […]
Excel’s Unique() function itself can’t show distinct values that appear more than once in a list. Repeated only items in a distinct list are possible with a simple extended formula. We’ve already shown the basics of Unique() either getting a list of Distinct values or values that only appear once aka Unique. But Unique() doesn’t […]
=Rand.old() is a Word trick which adds common sentences that use all, or most, of the letters in that language’s alphabet. Here’s what Word does in English, French, German, Danish, Polish and many other languages. It’s useful filler text for testing formatting or other Word features just like “Lorem Ipsum …”. The sentence changes for […]
