Registration for Summer 2026 programs and courses is now open. Learn more about the academic programs we are delivering in Summer 2026. 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.