Tech Help—Broken VLookUps
My VLookUps keep breaking because people keep adding rows and columns to the worksheets. How can I keep them from breaking?
Category: Office Technology
Tech Help—Outlook Calendar Options
How do I put in a start time in one time zone and an end time in another? … How do I get Outlook to stop adding Teams meeting verbiage to my meeting invites?
Tips for mail merges in Word and Outlook
Word mail-merge filter, Outlook mail-merge accidents and fixing formats in mail merge.
PowerPoint hacks for your next presentation
The next time you or one of your staff members has to work on a presentation, wow your bosses and audience with the following PowerPoint hacks.
Tech Help—Outlook groups and cluttered inboxes
What’s the difference between a group and a contact group? … What are your best tips for cleaning up a horribly cluttered inbox?
Tech Help—PowerPoint challenges
Questions about zooming in and the outline view.
Excel workbook connections
Troubleshooting, auditing cell links and comparing workbooks.
Tech Help—From Microsoft to Google
Features in Google Workspace that replace what you used in PowerPoint and Word.
3 Outlook tips: Reminders, polls and Quick Parts
Reminders for recipients, sending polls in an email and Quick Parts for reusable text.
Excel: Make your data do what you want
Make formulas more understandable for a “layman” … Why are tables better than a plain worksheet?