Recent Posts

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.

Worried that Excel macros are being phased out? Here's what Microsoft has actually said, and what it means for your VBA code.

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.

Turn any photo into an Excel portrait using Python and conditional formatting. Convert an image into a grayscale pixel grid made entirely from spreadsheet cells.

When working with dates, you'll sometimes find that you need to calculate the number of working (or business days) that have passed in...

An object in VBA is an Excel component such as a workbook, worksheet, or range, that you can interact with and manipulate. These are...

I've always admired the way GitHub presents your contribution activity with a slick, heatmap-styled tracker. Let's create our own version in Excel. Contents: 1. Data Setup 2. Formula 3. Formatting 3.1. Conditional Formatting 3.2. Cell Size 3.3. Hide Text Values 3.4. Cell Border 3.5. Adding Month/Day Names 4. Adjust for Different Start Days (Non-Monday) Habit Tracker & Calendar Heat Map There are a two main parts that we need to convey with our heatmap. First w