How-To Geek on MSN

How to use the FORMULATEXT function in Excel

The simplest use of the FORMULATEXT function is straightforward formula auditing.

How to grey out unused cells in Excel

This guide describes how to grey out unused cells in Excel in Windows 11/10, apply a solid fill color, use Conditional Formatting, or hide unused rows/columns.

Excel’s Advanced Filter Features Made Easy : From Criteria Ranges to Copying Results

Learn advanced filtering in Excel with a criteria area, OR and AND logic, and copy results to isolate the right rows fast.
TechRepublic

How to use wildcards with the XLOOKUP() function in Excel

How to use wildcards with the XLOOKUP() function in Excel Your email has been sent Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible. Lookup functions are great ...
How-To Geek on MSN

I made a dynamic Excel timeline in 10 minutes (and you can too)

In Microsoft Excel, you can convert your data into many types of charts. However, frustratingly, there's no option for a ...
TechRepublic

How to combine values from a column into a single cell using Microsoft Excel’s Power Query

How to combine values from a column into a single cell using Microsoft Excel’s Power Query Your email has been sent The article How to concatenate values in a single Excel column to a single row shows ...