Word: Quick Line Borders

These borders are so quick and easy to create – and look terrific below a title or at the top of a résumé.

 

Full tip: Word Tip

Categories: Word

Read Less

Microsoft Office: Let Your Fingers do the Walking

Anyone who has taken our classes know that we are real advocates of keyboard shortcuts. Why? Because: (a) they’re easy (to remember); and (b) they’re consistent across most Microsoft products.

 

For those of your new to the Office suite you might find it a challenge to locate some common functions. But using keyboard shortcuts really does shorten the task.

 

Full tip: Microsoft Office tip

Categories: Microsoft

Read Less

Outlook: Creating a Distribution List from an email

Scenario: You have received an email from a committee you’ve just joined. The rest of the committee members are listed in the CC box. You want to create a distribution list containing these people – but you don’t want to add them one at a time (and so you shouldn’t!)

 

Full tip: Outlook tip

Categories: Outlook

Read Less

PowerPoint: Two Shows for the Price of One

Scenario: You are about to give a PowerPoint presentation – but you’d like to have a few introductory slides looping over and over again as the audience files in. Then…when you’re ready…tap a key and the main presentation starts.

 

Solution: Have a welcome/intro show loop (while people are taking their seats) – equipped with a button that enables you to start the actual presentation when you’re ready to begin.

 

Full tip: PowerPoint tip

Categories: PowerPoint

Read Less

Excel: End-of-Month Date Calculation

Since not all months contain the same number of days – here is a handy Excel formula to calculate the last day of a month.

 

Full tip: Excel tip

Categories: Excel

Read Less

Excel: Sorry, this tip is missing.

Categories: None

Read Less

Word: Inserting One Document into Another

You have two Word documents that need to be combined into one. What to do? You have a few choices, depending on how you want the combine documents to behave.

 

If you just want the two documents combined as one – and you have no desire to “link” to the inserted document (so that any changes made to it are updated in the combined document)….always try a standard copy/paste first.

 

But you have three options available.

 

Full tip: Word tip

Categories: Word

Read Less

Excel: Dynamic Row Numbering

Scenario: You have a list (employees, items, whatever) of records that you would like to number (1, 2, 3….). HOWEVER, you want to ensure that if you insert or delete a row within the body of the list…the numbers automatically compensate.

 

Full tip: Excel tip

Categories: Excel

Read Less

Web Browsing: Two Page Tips

Scenario: You’re searching the web for a topic. You find many potentially good links. You click on one – but the page it takes you to is disappointing. Sometimes the BACK button is faded (unavailable). Grr…

 

Full tip: Web Browsing tip

Categories: Excel

Read Less

OUTLOOK: Using a Built-In Promotional Tool

This is a long one! (But worth it)

 

Scenario: When someone receives an email from you and decides they want to add you to the Outlook Contacts list they will often open the message and right-click your name/address displayed in the FROM box and choose ADD TO OUTLOOK CONTACTS.

 

What information (about you) gets added to your Contact List when they do that? Just your name and email address. Why just that information? Because that’s all email clients (Outlook, Hotmail, Gmail, etc) are programmed to give them – even if you have a signature block at the end of your emails that also contains your web address, cellphone number etc.

 

In today’s competitive marketplace, the more of your (contact) information your prospective clients and colleagues have…the easier (and more likely) it will be for them to reach out to you (versus your competitor) should the nice arise.

 

So…what can you do about this? Create a VCard – that’s what. And include it in all your outgoing emails. When someone right-clicks your VCard (in the email they’ve received from you) and choose ADD TO OUTLOOK CONTACTS…your contact record will be automatically populated with whatever information (about yourself) YOU want them to have.

 

Full tip: Outlook tip

Categories: Outlook

Read Less