Excel 2010: Level 4: Statistical Analysis

Learning Outcomes:

• Exhibit skill in manipulating data using lookup functions as indicated in the classroom.
• Successfully work with the data analysis tools in Microsoft Excel 2010 as directed in the Lesson Lab.
• Identify the Beta Value of a Security to the 100% satisfaction of the instructor.
• Correctly validate Data using information functions.

This course is one of a series of titles that addresses Microsoft Office Specialist certification and is extremely useful for those who need to manipulate data using statistical and lookup functions.

• Manipulating Data
• Analyzing Data
• Using Financial Functions
• Using Math Functions
• Using Text and Information Functions
• Working with Templates and charts
• Managing Data in Workbooks

Excel 2010: Level 4: Statistical Analysis

Forecast GDP using statistical functions. Evaluate sales data and stock data using statistical functions. Mine data using the lookup and reference functions. Analyze Sales data using descriptive statistics. Analyze time series data using exponential smoothing. Analyze data using regression. Analyze sector data using correlation and covariance matrices. Optimize a stock portfolio using solver. Develop an investment schedule using financial functions. Make investment decisions using financial functions. Analyze sales data, calculate stock returns and aggregate GDP data using math functions. Manipulate data using text functions. Validate data using information functions. Create advanced templates and charts. Manage date in workbooks.

Class targeted to:

This course is designed for the 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.

Prerequisites: The first three levels of Excel 2010 or equivalent knowledge