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.
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?
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.
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.
July 7, 2021
Categorized in: Excel
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?
May 5, 2021
Categorized in: Excel
Whether or not it should work this way, it does.
March 3, 2021
Categorized in: Excel
Studying books and help text is one way to learn formulas. Another: Ask the formula!
March 3, 2021
Categorized in: Excel
Copying and pasting doesn’t always produce the results we need and can take a lot of clicking and dragging.
December 2, 2020
Categorized in: Excel
The error could be the result of a number of circumstances.
October 11, 2020
Categorized in: Excel
3 shortcuts for selecting cells, working in multiple workbooks and activating Quick Analysis options.