Lesson 1: Manipulating Data Using Statistical and Lookup Functions

Topic 1A: Forecast GDP Using Statistical Functions

Topic 1B: Evaluate Sales Data Using Statistical Functions

Topic 1C: Analyze Stock Data Using Statistical Functions

Topic 1D: Mine Data Using the Lookup and Reference Functions

Lesson 2: Analyzing Data Using Data Analysis Tools

Topic 2A: Analyze Sales Data Using Descriptive Statistics

Topic 2B: Analyze Time Series Data Using Exponential Smoothing

Topic 2C: Analyze Data Using Regression

Topic 2D: Identify Beta Value of a Security

Topic 2E: Analyze Sector Data Using Correlation and Covariance Matrix

Topic 2F: Optimize Stock Portfolio Using Solver

Lesson 3: Working with Data Using Financial Functions

Topic 3A: Develop an Investment Schedule Using Financial Functions

Topic 3B: Make Investment Decisions Using Financial Functions

Lesson 4: Examining Data Using Math Functions

Topic 4A: Analyze Sales Data Using Math Functions

Topic 4B: Calculate Stock Returns Using Math Functions

Topic 4C: Aggregate GDP Data Using Math Functions

Lesson 5: Manipulating Data Using Text and Information Functions

Topic 5A: Manipulate Data Using Text Functions

Topic 5B: Validate Data Using Information Functions

Lesson 6: Working with Templates and Charts

Topic 6A: Create Advanced Templates

Topic 6B: Create Advanced Charts

Lesson 7: Managing Data in Workbooks

Topic 7A: Retrieve and Paste Data

Topic 7B: Determine the Conditional Sum

Topic 7C: Identify Specific Data Using the Lookup Wizard