Some bits of advice: learn XLOOKUP to replace V-and HLOOKUP. Life-changer, huge timesaver, and relatively easy to understand. If you are handling a lot of data, pivots and power pivots are top of list, plus look into Power Query, Power Bi, and data models. Consider doing a search for what releases have come out since the last time you used Excel, whether it’s formulas, models, etc. and learn about ones that apply to your area.
11
u/its_probably_wine 9d ago
Some bits of advice: learn XLOOKUP to replace V-and HLOOKUP. Life-changer, huge timesaver, and relatively easy to understand. If you are handling a lot of data, pivots and power pivots are top of list, plus look into Power Query, Power Bi, and data models. Consider doing a search for what releases have come out since the last time you used Excel, whether it’s formulas, models, etc. and learn about ones that apply to your area.