Office Technology

Get contacts from a group … Mail merge and multiple email addresses … End recurring meeting series
When creating a custom Slide Master, it’s good to keep an eye on the future.

Track Word changes with Compare/Combine

February 3, 2020 Categorized in: Word

Using Compare/Combine on the Review tab to detect what specific changes others made to your content will help you identify what you may need to cut and paste.

Outlook: 2 tips for clearing the clutter

February 3, 2020 Categorized in: Outlook

One way to clear inbox clutter is to put email messages that are tasks or calls to action in a better place.

Admins’ favorite keyboard shortcuts

February 3, 2020 Categorized in: ExcelWord

Whether it’s a speedy way to create a bar chart or a trick for switching from one window to the next, keyboard shortcuts can help even the experienced admin knock out work faster. Here are a few of our readers’ faves:

3 questions about time and dates in Excel

January 6, 2020 Categorized in: Excel

Time zone math … Workday calculations … Time math overnight
Press the Windows button and just start typing the name of the file or app you want.
Quickly clean up your email with these three simple techniques.

Excel: 3 ways to get formulas copied down

January 6, 2020 Categorized in: Excel

There are three ways to get formulas copied down.

Microsoft Word: Get the picture?

January 6, 2020 Categorized in: Word

Diagrams, pictures, charts and graphs can clarify your message, support your case and help visual learners to understand the information. Here is how to get them in there, make them look crisp and clear, and get them to stay put.

PowerPoint: Clean up layouts in a template

December 3, 2019 Categorized in: PowerPoint

If you’re working with a “template” that seems to have every type of layout under the sun, but you only use a handful of them, click on the View tab in the Master Views group and choose Slide Master.

Turn text into speech in Word

December 3, 2019 Categorized in: Word

Sometimes, it’s just easier to catch an error when you read aloud. If that’s not practical where you work, put on a pair of headphones, and click the Read Aloud button.

Compare two spreadsheets in Excel

December 3, 2019 Categorized in: Excel

Have two spreadsheets that should be identical, but you want to make sure? Use the Inquire add-in in Excel.