Excel

Excel: Easy dates with smart chips

January 5, 2023 Categorized in: Excel

When the simple math of adding 7 to today’s date to figure out what next week’s same day date is becomes cloudy, try using the @date smart chip.

Is anything using this cell?

December 8, 2022 Categorized in: Excel

You’re about to get rid of a cell in an Excel worksheet because it appears superfluous. But is it?

Excel: Uncover hidden worksheets

December 8, 2022 Categorized in: Excel

You see the worksheet tabs at the bottom of the Excel window and assume that’s all of them. But it might not be.

Avoid copies to prevent ‘dirty data’

December 8, 2022 Categorized in: Excel

Let’s look at three approaches you can take in Excel, which provide just the needed data, so it is tied directly to the source data.

LOOKUP luck

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.