Build on the skills introduced in Intermediate Excel and help prepare for the Microsoft Excel certification examination. Learn and work with advanced formulas, lookup functions. Learn to import data, export data and query external databases. You will also learn about some of the analytical features of Excel, such as Goal Seek and Solver and learn to create, and run macros to automate redundant tasks in spreadsheets. Books included in price.
Excel Intermediate