Office Technology

Excel: Try conditional formatting

June 1, 2020 Categorized in: Excel

Conditional formatting can be useful with out-of-range conditions, allowing an alert as data entry is happening.
Can I save an arrangement of windows to open multiple calendars in Outlook? … What is the multiple desktops feature used for in Windows 10? … Any ideas for quick desktop clean-up?

Windows 10 tricks for small screens

May 4, 2020 Categorized in: Internet

Working with small screens is made so much easier with a few Windows 10 tricks.
From your Outlook 365 calendar, click the New Teams Meetings button in the Ribbon or toggle the Teams meeting switch to the right to schedule an online teleconference or videoconference.

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