Excel beginners can start with SUM, IF, COUNTIF and XLOOKUP
SUM, IF, COUNTIF and XLOOKUP cover four common Excel tasks: totaling values, returning conditional results, counting matches and retrieving corresponding records. Reliable results still depend on correctly structured data, aligned ranges and a compatible Excel version.