Office Technology

Creating bookmarks in Word

March 2, 2020 Categorized in: Word

Microsoft Word has the ability to create bookmarks (essentially metatags) with any selection of text or objects.

Excel dates: Just add 1

March 2, 2020 Categorized in: Excel

If you need the day number within the year for a particular date, subtract 1/1/2020 or the first day of the current year with which you’re concerned. Then add 1.
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.