What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format, and ...

Have you ever struggled to sort data in Excel in a way that truly fits your needs? Imagine trying to organize a list of regions not alphabetically, but in a specific order like “North, South, East, ...

In Microsoft Excel, you can permanently hide columns containing data you don't need to have on show. However, grouping columns is often a better way to achieve the same outcome, especially if you're ...

How to create a sorted unique list in an Excel spreadsheet Your email has been sent Microsoft 365's UNIQUE() function is a great reason to upgrade. Combine UNIQUE ...

A Column Chart can be used to create the most common form of a timeline in Excel, which consists of a horizontal layout with a time-based X-axis and events or milestones plotted along it. To create a ...

Have you ever grouped data in Excel only to find your months sorted alphabetically instead of chronologically? It’s a frustrating quirk of the GROUPBY function, one that can turn a clean dataset into ...

Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.

You can split cells into columns in Excel using the "Text to Columns" tool. Excel gives you two ways to split cells into columns: using delimiters, or using a manual fixed width. Splitting cells into ...

Sometimes hiding certain columns in an Excel spreadsheet can be helpful: Doing so can make spreadsheets easier to read or you may have other reasons to hide them. In any case, hiding columns in ...

How to create a YOY comparison chart using a PivotChart in Excel Your email has been sent Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in ...

An icon in the shape of a lightning bolt. Impact Link You can easily hide columns when working within an Excel spreadsheet — and just as easily unhide them. Excel is great for sorting large amounts of ...