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, ...

While Excel was designed for numbers, it also involves text in cells. So, for example, if you want to transfer your data and limit the characters for each cell, you may want to know how to count ...

If you are trying to write a number in Excel or Google Sheets that starts with zero (0), you may not do that due to the default settings. In that case, you should follow this tutorial to enter zero ...

If you are using Microsoft Excel to manage numerical data, at some point you're inevitably going to display percentages. Doing so can give you a new insight, or make summarizing heaps of data a bit ...

In addition to its basic spreadsheet functions, Microsoft Excel also allows writing formulas to perform functions on existing data. Using a quick equation, you can convert an existing set of time data ...

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 ...

Product IDs, serial numbers and other reference numbers require a unique identifier to avoid confusion when referencing a product or specific data point. Although you can manually enter unique numbers ...

How to generate random numbers with no duplicates in Excel Your email has been sent Over the last few months, I’ve written about several of Excel’s new dynamic array functions. They’re powerful and ...