Advanced Spreadsheet Skills

Catalog description

This course covers in-depth the advanced features of spreadsheet programs. Emphasis is placed on using spreadsheets to solve problems. Topics include: good spreadsheet design, graphing, working with financial tools and analytical functions, automating spreadsheets with macros, exploring what-if alternatives with pivot tables and charts, data tables, Goal Seek, Solver and Scenarios, using database functions, and developing an Excel application.