Office Technology

PowerPoint: Give animation a try

May 4, 2020 Categorized in: PowerPoint

Presenting online (without a webcam on you) can be daunting if you’ve only ever presented in person or in print.
Online v. in-person presentations … How does the morph transition actually work?

Change your Outlook reading pane

April 8, 2020 Categorized in: Outlook

Some people don’t like the reading pane on in Outlook. It is easier to cull messages viewed as lines of data. But sometimes the first few lines of the message can be helpful in making the delete/keep decision.
Whether columns are required or not, you can add them without navigating to SharePoint.

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: