Microsoft® Excel 2010 Beyond
COURSE OVERVIEW:
You will use the advanced features of Microsoft® Office Excel® 2010 to attain proficiency as an Excel power user.
COURSE COST & LENGTH:
1 day | $450 *Contact us TODAY for Special GROUP Rates!*
AUDIENCE PROFILE:
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.
AT COURSE COMPLETION:
After completing this course, students will be able to:
Manipulate data using statistical and lookup functions
Analyze data using the data analysis tools in Microsoft® Excel® 2010
Make investment decisions using the financial functions in Excel® 2010
Examine data using math functions in Excel® 2010
Manipulate data using text and information functions in Excel®.
Create templates and work with Excel's® advanced chart options
Manage data in Excel® workbooks
PREREQUISITES:
Excel® 2010 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 the successful completion of Microsoft® Office Excel® 2010: Beyond, the following courses or equivalent knowledge is recommended:
Microsoft® Office Excel® 2010: Intro
Microsoft® Office Excel® 2010: Intermediate
Microsoft® Office Excel® 2010: Advanced
RELATED CERTIFICATION EXAM(S):
MOS: Microsoft® Office Excel® 2010 Exam 77–882, MOS: Microsoft® Office Excel® 2010 Expert Exam 77–888
COURSE OUTLINE:
Module 1: Manipulating Data Using Statistical and Lookup Functions
Lessons
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
Module 2: Analyzing Data Using Data Analysis Tools
Lessons
Analyze Sales Data Using Descriptive Statistics
Analyze Time Series Data Using Exponential Smoothing
Analyze Data Using Regression
Identify the Beta Value of a Security
Analyze Sector Data Using Correlation and Covariance Matrices
Optimize a Stock Portfolio Using Solver
Module 3: Working with Data Using Financial Functions
Lessons
Develop an Investment Schedule Using Financial Functions
Make Investment Decisions Using Financial Functions
Module 4: Examining Data Using Math Functions
Lessons
Analyze Sales Data Using Math Functions
Calculate Stock Returns Using Math Functions
Aggregate GDP Data Using Math Functions
Module 5: Manipulating Data Using Text and Information Functions
Lessons
Manipulate Data Using Text Functions
Validate Data Using Information Functions
Module 6: Working with Templates and Charts
Lessons
Create Advanced Templates
Create Advanced Charts
Module 7: Managing Data in Workbooks
Lessons
Retrieve and Paste Data
Clean Data in Workbooks