Recent Posts

In 2020, Public Health England lost nearly 16,000 COVID cases due to an Excel file hitting its row limit. Here's exactly what happened and why.

Macros let Excel perform actions automatically, but how do they actually work? Here's a plain-English explanation.

Yes, but not directly. Here's the easiest way to open an Apple Numbers file in Excel without losing your data.

Yes, Excel can solve for x. Learn how to use Goal Seek to back-solve any formula for an unknown variable in just a few clicks.

Excel and Google Sheets look similar and share many features, but they are not the same. Here's what actually sets them apart.

Most Excel formulas ignore case entirely. Here's what that means for your data, and what to do when case actually matters.

Excel and Google Sheets share most common formulas, but there are real differences. Here's what you need to know before switching between the two.

Excel sheets are large, but they're not infinite. Here's exactly how many rows and columns you get, and what to do when that's not enough.

Yes, Excel can calculate standard deviation using built-in functions. Learn which formula to use and when, with examples.

Excel files and CSV files are not the same thing, though Excel can open and save both. Here's the difference and when it matters.

Excel formulas and functions are powerful tools for performing calculations and data analysis. Formulas are custom calculations you...

Unwanted spaces can break formulas, formatting, and be the source of hard to track down errors. Here are a couple ways to remove them....

Changing cell color can highlight specific areas on your worksheet that may otherwise go unnoticed. Specific problems, important...

Formulas are an integral part of Excel, and are the defining feature that elevates a workbook far above a simple calculator. Contents: 1....

Often times you'll want to create copies of existing worksheets to tweak or use as a template elsewhere in your workbook. There are a few...

Changing text color can highlight specific areas on your worksheet that may otherwise go unnoticed. Specific problems, important...

The Format Painter tool will help you quickly copy the formatting from anywhere in your workbook, saving you the time and hassle of...

Often times when scrolling through data in Excel, you want to keep the top few rows visible so you can easily see the column headers...

Often, you won't want every worksheet in your workbook to be able to easily be viewed by everyone. Hiding and unhiding sheets will let you p

When working in Excel, it can sometimes be difficult to get an overview of an entire worksheet, especially if you're working on a smaller...