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.