Course Overview
This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, teaches advanced users of Excel more complex formulas, functions, and arrays, and covers more advanced editing and formatting options, such as using the Paste Special command to copy validations and link data. Students will learn about various analysis tools such as Wizards, problem models, and methods for correlating data. Finally, they will learn advanced customization techniques by changing default settings and automating selected features.
Course Outline
Unit 1 : Advanced formulas, functions, and arrays
- Text functions
- Date and time functions
- Information functions
- Array formulas
Unit 2 : Advanced editing and formatting
- The Paste Special command
- The Go To Special dialog box
- Merging styles
- Additional chart formatting
Unit 3 : Analyzing and sharing information
- Wizard add-ins
- Solver models and reports
- Statistical analysis tools
- Embedding and linking
Unit 4 : Advanced customization
- Popular and Save options
- Formulas options
- Automating Excel
- Advanced options
Target Audience
This course is designed for advanced Microsoft Office Excel professionals who may work or be interested in the domain of finance, statistics, project analysis, and market analysis including the fields of micro- and macro-economics.
Objectives
After completing this course, students will be able to:
- forecast data using functions.
- analyze data using the data analysis tools in Microsoft Office Excel 2007.
- make investment decisions using the financial functions in Microsoft Office Excel 2007.
- examine data using math functions in Microsoft Office Excel 2007.
- manipulate data using text and information functions in Microsoft Office Excel 2007.
- create templates and work with the advanced chart options.
- manage data in Excel workbooks.
Prerequisites
Excel 2007 knowledge, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data is required. You should also know how to write and edit simple formulas. To ensure your success, we recommend the following courses, or equivalent knowledge:
- Microsoft Office Exce2007: Level 1
- Microsoft Office Excel 2007: Level 2
- Microsoft Office Excel 2007: Level 3