I've written many times about the many benefits of formatting your data as a structured table in Microsoft Excel. However, despite this, there's one major issue that continues to throw a spanner in ...

Although getting into the habit of naming tables in Excel can take some time if it's not something you usually do, here's why today's the day to start. First, if you're working with a large workbook ...

Learn the secrets of Excel structured tables to save time, eliminate errors, and create smarter, more dynamic spreadsheets.

Q. Is there a quick way to format tables in Excel? A. An AutoFormat option in Excel will format your table and allow you to choose from several options. Let’s use the completely unformatted table in ...

Have you ever carefully crafted a formula in Excel, only to watch it unravel into chaos the moment you copy it across columns? It’s a maddening quirk of Excel tables—structured references that seem to ...

How to combine data ranges with Microsoft Power Query in Excel Your email has been sent Microsoft Power Query showed up in Excel 2016, though earlier versions can ...

Pivot tables in Microsoft Excel are a great way to organize and analyze data, and the more you know about the feature, the more you’ll get out of it. For instance, filtering a pivot table is a great ...

Here's how to build smarter checklists in Excel using checkboxes, conditional formatting and task dependencies to help with multi-step processes. In my previous article in this series, I walked you ...