Registration for Fall 2026 programs and courses is now open. Learn more about the academic programs we are delivering in Fall 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.
Ancillary fees will be added at checkout and will vary based on the number of courses selected. For details on how the fees are calculated, please refer to ancillary fees for part-time studies.