(Excel Advanced and VBA)
Computer knowledge required: You should be familiar with Excel and be able to calculate formulas and use functions – including the Sum, Max and Min functions.
You should also be familiar with Page Set-ups, including Headers and Footers.
This course is a combination of the Excel Advanced and Excel with VBA courses. Included from the Excel Advanced course is customizing the working environment, protecting the worksheet, advanced formulas, Goal Seek, Solver, and Scenarios. Almost all the Excel with VBA chapters is covered. This course is strongly recommended for people who want to use Excel mostly for technical calculations, engineering, and modelling.