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

This is the demonstration file to accompany the article, How to use wildcards with the XLOOKUP() function in Excel, by Susan Harkins. From the intro of this Microsoft Excel tutorial: Lookup functions are great for finding values that match another value. Thanks to XLOOKUP() this task is easier than ever, and it even supports wildcards! …

The post Sample file: How to use wildcards with the XLOOKUP() function in Excel appeared first on TechRepublic.

Sample file: How to quickly make Excel subtotals stand out from the data

This is the demonstration file to accompany the article, How to quickly make Excel subtotals stand out from the data, by Susan Harkins. From the intro of this Microsoft Excel tutorial: Microsoft Excel’s Subtotal feature calculates subtotals and a grand total for columnar data, but that’s not all. This Excel feature supports 11 calculating processes: …

The post Sample file: How to quickly make Excel subtotals stand out from the data appeared first on TechRepublic.