In this video, you'll learn three methods to SUM and COUNT cells in Excel based on cell color, as Excel does not have a built ...

In this video, learn how to create fully clickable tabs inside a single Excel sheet that change colors when selected, automatically updating the corresponding data. This technique consolidates ...

Within three years, no embedded software developer is going to be writing code. I know it sounds like another one of my controversial statements. But I recently used Claude Code to write the best ...

Have you ever been overwhelmed by messy spreadsheets or struggled to collect data in an organized way? Imagine a scenario where instead of juggling multiple tabs and rows, you could guide users ...

I discovered artificial intelligence tool GPT Excel in my quest to cut down on all the busywork it takes to create and update spreadsheets. Carly Quellman, aka Carly Que, is a multimedia strategist ...

While Microsoft Excel is one of the most powerful spreadsheet applications, it’s also the most intimidating tool in the Microsoft Office suite. If you’ve never used Excel before or are just a bit ...

Creating custom keyboard shortcuts in Excel can significantly enhance productivity by allowing users to perform tasks more quickly. By creating custom keyboard shortcuts tailored to your specific ...

Q. I often use watermarks in Microsoft Word to indicate that the document is a “Draft” or “Confidential.” However, the options to create a watermark are not in Microsoft Excel. I want to indicate that ...

If you want to learn how to take a screenshot in Excel, we’ve got you covered. Taking screenshots of your Excel worksheet is a great way to use your data, graphs, or analysis for presentations or ...