Office Technology

Why are some Excel features greyed out in Office 365? … I miss my desktop apps … Is there a way to keep people from turning off Track Changes?

Import a list of holidays into Excel

May 6, 2019 Categorized in: Excel

If you use NETWORKDAYS or the WORKDAY function, it’s useful to import a list of holidays from TimeandDate.com.

Word: Keep your numbering in order

May 6, 2019 Categorized in: Word

If you write technical documents requiring a specific numbering scheme, it can be frustrating to keep them intact. Here’s help.
3 tips for adding sections and pages.

PowerPoint’s newest features

May 2, 2019 Categorized in: PowerPoint

Unless you keep up on the latest and greatest on each of your Office apps, you might be surprised that features we’ve wanted (or wanted to be easier) are now part of the version you’re already using!
How can I “sharpen up” a PowerPoint template? … Is there any way to animate a spinning globe precisely? … How can I apply a precise color to an object?

Keyboard Shortcuts: Excel

April 1, 2019 Categorized in: Excel

3 shortcuts for dates and times.
One of the things that great project management apps do is calculate project and task start and due dates based on a project start date and task durations. You can also do this in good old Excel or Google Sheets.
Save time and tweaking by creating slide masters that adjust to whatever projection situation you encounter.
How much time do you waste clicking, dragging and squinting to do everyday actions in Outlook? There are two buttons to add to the Quick Access tool bar to save time and eye strain!

Excel web queries have changed

March 4, 2019 Categorized in: Excel

Data stored in defined web page tables is now more accessible directly.

Navigation, graphics and styles in Word

February 5, 2019 Categorized in: Word

What is the point of the Navigation pane? … Is there an easier method than copying and pasting to use PowerPoint graphics in Word? … How do I get a style change to stick?

Cleaning up dates in Excel

February 5, 2019 Categorized in: Excel

It might take some maneuvering, but you can probably disassemble a file with funky dates, then reassemble it with text functions.