Office Technology

When too many collaborators create a disorganized report, get it back under control using styles.

Word conundrums: Dynamic content

August 3, 2022 Categorized in: Word

Q. When I use wrap text features for pictures in my Word doc and people view it in Word Online, it doesn’t look the same. What can I do to get pictures to look right in Word Online?
When you’re creating a presentation that is meant to be directed by the viewer, as opposed to a presenter in front of the room, you can include polls and surveys using Microsoft Forms.

Where are my emails going?

July 6, 2022 Categorized in: OutlookThe Office Tech Pro

Q. I see an email when I search, but it doesn’t appear in my inbox. How can I tell where these are going?
Three Excel tools to ease your workload.

Excel: Versioning in the Cloud

June 2, 2022 Categorized in: Excel

Q. I’ve inherited a workbook from a colleague who is no longer at the company. She was really good at Excel. The problem is, I can’t quite figure out what this file is connected to. Is there a “one-stop shop” for that in Excel?

Word: Saving tables as Quick Parts

May 4, 2022 Categorized in: Word

If you’ve spent a great deal of time crafting a table in Word to look exactly the way you want it and plan to use that table again, you can easily recreate it in any document with Quick Parts.
Can you have a video of the speaker on a slide? … I want to use a video in my presentation but record my own audio. Is that possible?

Managing change dynamically in Word

April 6, 2022 Categorized in: Word

Q. Inevitably, I end up with pages with too much white space at the bottom or diagrams separated from their text. Is there an easy way to get things to fit on pages without using hard page breaks?
Exporting Google Calendar data, and your own and others’ Outlook calendar data.

Excel: Wrangling rogue dates

March 2, 2022 Categorized in: Excel

Q. In a spreadsheet with a date column, some dates look fine, but others are left-justified for some reason. What might be causing this and how do I fix it?
Q. Other than marking particular senders with Block Sender in the junk mail settings, is there an easy way to get rid of a lot of junk mail all at once from anyone using that domain?

PowerPoint: No more font conversions

January 5, 2022 Categorized in: PowerPoint

Do you use specific fonts for branding? After others contribute to the presentation, do you notice that your custom fonts have been converted back to standard ones? Here’s how to solve this problem.