Excel Combine, Analyse, Report

Discover posts that introduce the more advanced features of Excel that assist you in referencing and reporting on large data lists.

Become super confident preparing data, creating reports and charts using these fabulous tools.

Excel Combine, Analyse, Report

Excel – Using VLOOKUP to compare two lists

If you’re using Microsoft 365, XLOOKUP is now the better and more flexible option than VLOOKUP, and I highly recommend learning it…

Read More Excel – Using VLOOKUP to compare two lists
Excel Combine, Analyse, Report

Excel – How do I merge cells within a range that is formatted as a Table?

Question: When I use Excel “Format as Table” to format a range, the Merge & Center button is greyed out and becomes…

Read More Excel – How do I merge cells within a range that is formatted as a Table?