Author Archives: jstead@ctccomputertraining.com

Tip #213_Excel

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.

Tip #212_Excel

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.

Tip #211_Windows10

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”.

Tip #210_Outlook

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.

Tip #209_Passwords

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.

Tip #208_Excel

Excel: Things you should never do #2

 

Full tip: Excel tip

Tip #207_Windows10

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.

Tip #206_GoogleTranslate

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!

Tip #205_Word

Word: Things you should never do #2

 

Full tip: Word tip

Tip #204_GoogleChrome

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.