While Microsoft Excel offers a built-in tool for sorting your data, you may prefer the flexibility of a function and formula. We’ll show you how to use the Excel SORT function with helpful examples.

Obtaining subtotals for groups of related items is easy in Microsoft Excel. In fact, you have two ways to do this. You can either use the SUBTOTAL function or the Subtotal feature, whichever works best. We’ll show you how….

Do you see something unusual in your Excel spreadsheet? Wondering how the change may have happened? Whether you’re working with others or alone on an Excel sheet, there’s a simple way to see the changes that take place….

Microsoft Excel is often synonymous with company financials, household budgets, and other numeric data. But Excel can be a terrific tool for planning events like weddings, showers, parties, and more, too. Keep reading for tem…

Have you ever tried to sort data in Excel, only to receive an error about merged cells? It can be a pain to try and locate all of those merged cells manually. Luckily, there’s a simple way to find them….

If you organize a spreadsheet by columns, you may only want to work with specific columns at one time. In Microsoft Excel, you can group columns and expand and collapse them as you work. We’ll show you how to do just that….

A scatter plot, sometimes referred to as a scatter chart or XY chart, compares the relationship between two different data sets. This makes it easier to visualize two sets of values in your Excel spreadsheet. Here’s how it wo…

Whether you’re grading exams or simply trying to make sense of a spreadsheet full of data, Microsoft Excel’s IF function can help. You can also use an IF function inside of another IF function to run deeper tests, too. We’l…

Microsoft Excel is known for being an excellent tool for tracking things like a budget, inventory, or sales and revenue. But there are so many templates available you might not realize exist that can help you track just about…

Do you have an Excel sheet where you want the columns and rows at fixed sizes? You can lock the column width and row height for your entire spreadsheet in a few steps to prevent accidental resizing.

Microsoft Excel offers multiple ways to sum the values of a specific column. You can use the status bar, AutoSum, and the SUM function to add up the values in your column. Here’s how to use them.

Like jotting down notes when you’re composing a document, you can use notes in Excel for a spreadsheet. You might use a note as a reminder, to add a reference, or include a detail that should stay outside of the cell data….

Just like linking to another place in a Word document, you can link to another sheet in an Excel workbook. This is a handy way to quickly jump to a spreadsheet related to your current sheet or cell.

Creating a family tree is a fun and interesting activity to do on your own or with your family. It may even be homework for your child. Luckily, if you have Excel, you can make a family tree easily.

If you have data from a physical source that you want to add to Excel, you have the option to snap a photo of it, save it to your computer, and upload the data into your sheet to save time.

Freezing a single row is easy, but what if you want to freeze multiple rows at the top of your Microsoft Excel spreadsheet? Luckily, there’s an option to do that, too, and we’ll show you how to use it….

Have you ever been working on an Excel spreadsheet when dotted lines suddenly appeared? While fine to some, those dotted lines may be distracting to others. We’ll show you when and why these dotted lines appear and how to rem…

With Microsoft Excel’s NETWORKDAYS function, you can count the number of workdays that fall between two specified dates. This function excludes Saturdays, Sundays, and optionally the specified holidays. We’ll show you how to …

If you find yourself working on-the-go in the Excel mobile app, you might struggle when it comes to tables. That tiny screen isn’t always sufficient for viewing table data, much less editing it. Luckily, there’s a feature tha…

A circular reference in Excel happens when a cell containing a formula is dependent on its own result in some way, creating a loop that can’t be resolved. If you want to stop this error, you’ll need to find and remove these …