Advanced Excel
CATALOG COURSE
DESCRIPTION:
This hands-on computer course is designed to provide an advanced
understanding of spreadsheets using Microsoft Excel. Data Tables, Scenario
Management, using Solver, importing and exporting data, enhancing with
Visual Basic for applications and modifying Excel default settings are
covered. This course prepares the learner for the expert level Microsoft
Excel Office Specialist certification exam.
COURSE OBJECTIVES:
Upon successful completion of the course, the student will be
able to:
- Manage scenarios
- Project values using analysis tools.
- Perform What-If Analysis.
- Use the Solver Ad-In.
- Structure workbooks using XML.
- Import and Export data
- Define and modify workbook properties.
- Customize toolbars and menus.
- Edit macros using the Visual Basic editor.
- Modify Excel default setting.
 |
