1 – Know how to use Excel references – Table & cell refs
2 – Learn the basic formulas – SUMIFS, COUNTIFS, XLOOKUP, VLOOKUP, FILTER, IFERROR
3 – Break complex formulas to small steps
Helpful tutorial links:
=================
1) Using references in Excel
— Cell refs – https://chandoo.org/wp/relative-absolute-references-in-formulas/
— Table refs – https://chandoo.org/wp/introduction-to-structural-references/
2) Basic Excel functions
SUMIFS & COUNTIFS – https://youtu.be/YEt-aYbDTrs
IF – https://youtu.be/-yFpzIRifK4
XLOOKUP – https://youtu.be/gpwqUc3y7ZA
VLOOKUP – https://youtu.be/8rtvDQVQaA0
FILTER – https://youtu.be/ONaS7IMKJPM
IFERROR – https://chandoo.org/wp/iferror-formula/
Have a beautiful day 🌼🌞😀
#ExcelTips #Shorts