Skip to content
Contact USI

Two sessions will be dedicated to the experienced Excel user to learn advanced features such as database functions, text functions, import .txt files, create advanced functions including: match/index, vlookup, countif, countifs, sumif, sumifs, if, proper, concatenate, Dbase: advanced filter options, create and edit macros, sparklines, and use data analysis using goal seek with data tables.

Note: If you also take Excel Level II, and Level IV you will earn a Certificate in Advanced Excel from USI.