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.
Fall 2019, Spring 2019, Fall 2018, Spring 2018, Fall 2017