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.

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?
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.

Word: Quick inserts with Quick Parts

February 5, 2019 Categorized in: Word

Do you need to keep inserting your company name in a certain font and color with its tagline in various places in documents?

3 solutions to Outlook quandaries

January 7, 2019 Categorized in: Outlook

Tracking actions … Email hoarding … Annoying pop-ups