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