This course builds upon the skills and concepts taught in Excel Intermediate. You will learn to work with advanced formulas, as well as logical and lookup functions such as IF, SUMIF, IFERROR, VLOOKUP, MATCH, and INDEX; learn about data validation and database functions such as DSUM; import and export data; how to query external databases; learn about the analytical features of Excel such as Goal Seek and Solver; run and record macros; SmartArt graphics; and conditional formatting with graphics. All course materials included in price.