Excel: Show Me the Values
Did you know that if you select part of a formula (up in the formulas bar) and press the [F9] key – the actual value of that cell (instead of just it’s address) will appear.
Excel: Fun with Links
If you have a very large spreadsheet – consider adding HYPERLINKS to help you and others move around the spreadsheet must faster.
Windows: Suppress Unwanted Notifications with Focus
Scenario: You’re giving a PowerPoint presentation to a group and an email notification – which displays the Subject of the email – pops up in the bottom right-hand corner of the screen for all to see. (Note: I once had a smug colleague (knowing that I was giving a presentation) teach me a lesson by sending me an email with the subject “Your probation officer called”.
Outlook: Adding an iCal appointment to your Outlook Calendar
Scenario: I just signed up for a webinar. The confirmation included an iCal file (with an .ics file extension) – that includes the details of the event. I want to add it to my Outlook calendar…without having to manually repeat the information.
Passwords: No Fooling Around
With more and more of our life tied up in the digital clouds, it is more important than ever to secure your logins and personal and business information as strongly as possible.
Excel: Things you should never do #2
Full tip: Excel tip
Windows 10: EDITING the QUICK ACTIONS
As a traveler, I find myself needing to access my Wifi, HotSpot, Airplane Mode and similar features on a fairly regular basis.
Google Translate Offline: ¡Es fantástico!
Google Translate can be downloaded onto your phone so that you can use it even without an internet or cellular connection. Muy genial!
Word: Things you should never do #2
Full tip: Word tip
GOOGLE CHROME: Quicker BOOKMARK and HISTORY searches
I love to bookmark things – for when that elusive “spare time” arrives. But trying to later find that web page you bookmarked or visited last month (or year) can be time-consuming and frustrating.