Microsoft Excel 2007: Advanced (1 Day)

Product Description

After completing this course, you will know how to: Use names to assign descriptive labels to cells; use financial functions to calculate values based on conditions. Use data tables to view the effects of multiple input values on a formula. Use the Subtotal comm&, the Subtotal function & database functions to summarise list data; & use data forms & validation to facilitate data entry in lists; & use data tables to project values. Create & use Pivot Tables to analyse & compare large amounts of data. Import data from & export data to external databases. Use Goal Seek & Solver to perform what-if analysis; & use custom scenarios, advance custom views & pivot tables to manage large worksheets. Run & record macros to automate complex or repetitive tasks. Publish a worksheet as an interactive Web page. Apply financial formulas & array formulas in Data Tables to determine outcomes.

This training may be available onsite; please contact us if you are interested.