Category: Excel

Executive assistants either cringe or get excited when working in Excel. Some view it as a powerful tool, while others find it complex and frustrating. The following features can help simplify tasks, minimize errors and increase productivity.

Finding blank columns and rows, constant and formulas, and specific formats.

Q. I have a spreadsheet with multiple #N/A and #DIV/0 errors. They don’t necessarily indicate a real error for me, but they are distracting. Is there any way to make them “invisible”?

Workbook relationship, cell relationship and workbook analysis.

My VLookUps keep breaking because people keep adding rows and columns to the worksheets. How can I keep them from breaking?

Troubleshooting, auditing cell links and comparing workbooks.

Make formulas more understandable for a “layman” … Why are tables better than a plain worksheet?

Merge mistakes, column format mystery and color coding crashes.

I have a list of names in Excel that are first name and last name all in one column. How do I easily change that to the last-name, first-name format?