Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.

Formula Method The most obvious way to increment a number in Excel is to add a value to it. Start with any value in cell A1, and enter "=A1+1" in cell A2 to increment the starting value by one.

Learn how to use the TEXTJOIN function in Excel. The TEXTJOIN function can be used to combine data from a range of cells using one or more delimiters.

When you need to format text in multiple ways in a single cell in Microsoft Excel, then this guide shows you how to do it the easy way.

Every Excel expert knows how to navigate without a mouse and how to format data using keyboard shortcuts. But do you know how to insert a sum without typing the formula?

Don't endure boring, drab data. Learn these techniques to make your data pop, even in tables. Excel makes it easy.