Office Technology

Excel: Get rid of those green error triangles

January 5, 2022 Categorized in: Excel

Sometimes Excel tries to help, but it’s not helpful. For example, if you have numbers stored as text strings (preceded by an ‘), Excel will try to warn you about that. If the warning is unnecessary because you intended this, you can easily turn off those annoying green triangles.
Q. How can viewers of my PowerPoint presentation get to different places in the presentation and back to a main screen?
A new way to use Favorites … Quick Steps: Beyond Move to Folder … Give templates a try

Use OneNote for calls to action

November 3, 2021 Categorized in: Outlook

If you’ve got OneNote Windows 10 or OneNote Desktop (2016), you should see a OneNote icon in Outlook, on the Home tab, in the Move group in the ribbon. Click it to select the notebook, section and page on which you want it to appear.

Using different currencies in Excel

November 3, 2021 Categorized in: Excel

Q. My settings in Excel always give me $ signs for currency, but I often have to work in £ and €. Is there an easy one-click way to change the currency symbols?

Managing Outlook for an executive

October 6, 2021 Categorized in: Outlook

How can I keep people from scheduling directly on my executive’s calendar? … How can I keep my executive’s email messages pinned to the top of my list?

Pivot tables: count vs. sum

August 4, 2021 Categorized in: Excel

One frustrating problem with pivot tables comes when you add a field to the Values layout area expecting a sum, and it gives you a count instead.

Using Excel charts in PowerPoint

August 4, 2021 Categorized in: ExcelPowerPoint

There is no one right way to paste Excel charts into PowerPoint. It depends upon who has access and what they may need to do.
Can you collect information in a single worksheet, and collect all sheets to summarize and analyze without creating two files? … Can a whole worksheet row change font color if I change just one cell?
Before you show how to do a screen operation, click the Screen Recording button.
Whether or not it should work this way, it does.

Handling paste problems in Word

April 7, 2021 Categorized in: Word

Collaboration is great! But you may end up with 10 documents to combine into one, while everyone has approached formatting differently.

Learning formulas from formulas

March 3, 2021 Categorized in: Excel

Studying books and help text is one way to learn formulas. Another: Ask the formula!