Continue to build your expertise in Excel. Work with advanced formatting features, use lookup functions and explore array formulas to make your work more efficient. Create 1- and 2-variable tables. Import and export data as text files, use Goal Seek and Scenarios to analyze data, and run macros. In addition, start working with database functions and VBA code. Prerequisite: Excel: Advanced.