Office Technology

Fixing combined data in Excel

April 8, 2020 Categorized in: Excel

While there are many ways to fix combined data like “Chicago, IL, 60660,” many are fragile and not suited to connected data sources in a workbook.

Loop your photos in PowerPoint

March 2, 2020 Categorized in: PowerPoint

To produce a photo loop to run in the background at a special event, presentation or exhibit booth, use the Photo Album feature in PowerPoint.

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.