Home > Courses Certifications > Microsoft Office > Excel 2007 Level 4 synopsis

Microsoft Excel 2007 - Level 4

Prerequisites: Excel 2007 - Level 1, Excel 2007 - Level 2 and Excel 2007 - Level 3

Duration: 1 day

Lesson 1: Manipulating Data Using Statistical and Lookup Functions

• Forecast GDP Using Statistical Functions
• Evaluate Sales Data Using Statistical Functions
• Analyze Stock Data Using Statistical Functions
• Mine Data Using the Lookup and Reference Functions

Lesson 2: Analyzing Data Using Data Analysis Tools

• Analyze Sales Data Using Descriptive Statistics
• Analyze Time Series Data Using Exponential Smoothing
• Analyze Data Using Regression
• Identify Beta Value of a Security
• Analyze Sector Data Using Correlation and Covariance Matrix
• Optimize Stock Portfolio Using Solver

Lesson 3: Working with Data Using Financial Functions

• Develop an Investment Schedule Using Financial Functions
• Develop an Investment Schedule Using Financial Functions

Lesson 4: Examining Data Using Math Functions

• Analyze Sales Data Using Math Functions
• Calculate Stock Returns Using Math Functions
• Aggregate GDP Data Using Math Functions

Lesson 5: Manipulating Data Using Text and Information Functions

• Manipulate Data Using Text Functions
• Validate Data Using Information Functions

Lesson 6: Working with Templates and Charts

• Create Advanced Templates
• Create Advanced Charts

Lesson 7: Managing Data in Workbooks

• Retrieve and Paste Data
• Determine the Conditional Sum
• Identify Specific Data Using the Lookup Wizard
• Clean Data in Workbooks