Learn more about the academic programs we are delivering in Fall 2025. If you have any questions about part-time studies, please contact us.
In this course, participants will master XLOOKUP from basic to advanced levels. Learn to extract records, apply advanced filters, and use the SUMIFS function. Create dependent drop lists, utilize XMATCH, and explore TEXT functions like TEXTJOIN, TEXTSPLIT, TEXTBEFORE, and TEXTAFTER. Name cells and ranges, document functions with FORMULATEXT, and print a list of all named ranges. Compare lists, use controls with functions, and discover time-saving shortcuts.