Students work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX.  In addition, students learn about data validation and database functions such as DSUM.  They import and export data, and query external databases. Finally, students learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, SmartArt graphics, and conditional formatting with graphics.