Excel dates: Just add 1
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.
Category: Office Technology
3 Outlook conundrums: Contacts, mail merge and recurring meetings
Get contacts from a group … Mail merge and multiple email addresses … End recurring meeting series
Keep your PowerPoint Slide Masters consistent
When creating a custom Slide Master, it’s good to keep an eye on the future.
Track Word changes with Compare/Combine
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
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
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
Time zone math … Workday calculations … Time math overnight
Stop searching for files and applications on Windows 10
Press the Windows button and just start typing the name of the file or app you want.
3 techniques to clean up your email in Outlook
Quickly clean up your email with these three simple techniques.
Excel: 3 ways to get formulas copied down
There are three ways to get formulas copied down.