Courses + Certifications
Professional Development | | Desktop Applications | | Technical | |
|
Home > Desktop Applications > Microsoft Excel > Microsoft Excel 2007 > Excel 2007 - Level 4
Excel 2007 - Level 4
| Print Preview | Send to a friend |
| Learning Method: |
Instructor Led |
Overview: |
| In this course, students will use the advanced features of Microsoft® Office Excel® 2007 to attain a high degree of proficiency as an Excel power user. |
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 who wish to improve their skills in using Excel formulas and functions. |
Pre-requisites: |
| Before attending this course, students must have: |
|
At Course Completion: |
| Upon successful completion of 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.
|
| Module 1: Manipulating Data Using Statistical and Lookup Functions |
- Evaluate Sales Data Using Statistical Functions
- Analyze Stock Data Using Statistical Functions
- Mine Data Using the Lookup and Reference Functions
|
| Module 2: Working with Data Using Financial Functions |
- Develop an Investment Schedule Using Financial Functions
- Make Investment Decisions Using Financial Functions
|
| Module 3: Manipulating Data Using Text and Information Functions |
- Manipulate Data Using Text Functions
- Validate Data Using Information Functions
|
| Module 4: Working with Templates and Charts |
- Create Advanced Templates
- Create Advanced Charts
|
| Module 5: Managing Data in Workbooks |
- Retrieve and Paste Data
- Determine the Conditional Sum
- Identify Specific Data Using the Lookup Wizard
- Clean Data in Workbooks
|
|
 |
|
|
