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 新彩网.