Category: Excel

In Excel, no matter what I do, I can’t get a page to both fit on one sheet and be readable. What can I do?

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.

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

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

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.

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.

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?

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?