November 3, 2022 Categorized in: Excel

Are VLOOKUPS passé? … Why do I get #N/As on my VLOOKUPS even when the lookup information is there?
Three Excel tools to ease your workload.

Excel: Versioning in the Cloud

June 2, 2022 Categorized in: Excel

Q. I’ve inherited a workbook from a colleague who is no longer at the company. She was really good at Excel. The problem is, I can’t quite figure out what this file is connected to. Is there a “one-stop shop” for that in Excel?

Excel: Wrangling rogue dates

March 2, 2022 Categorized in: Excel

Q. In a spreadsheet with a date column, some dates look fine, but others are left-justified for some reason. What might be causing this and how do I fix it?
You may know the annoyance of typing (c) and getting ©. Whether this happens in Word, Excel, PowerPoint or Outlook, you can fix this in one place and have it work everywhere.

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.

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?

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?
Whether or not it should work this way, it does.

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!

Instead of copy/paste in Excel, try this

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.