Course Description
This course includes a Blended Learning  Bonus Pack.  In addition to the instructor-led course and book, participants will also receive the following bonus on-line materials for 12 months at no additional charge: 
- Microsoft Office Excel 2010 Crash Course Knowledge Assessment 
- Microsoft Office Excel 2010 Crash Course Self-Paced Learning Tutorial 
- Microsoft Office Excel 2010 Crash Course e-Book Student 
- Finance Essentials Interactive Resources 
- Managing Information Effectively (Includes Simulation) Interactive Resources 
CEU:16 CPE hours            
Agenda
Course Description:  The first day of this course, you will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks. On the second day, you will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.
Course Objectives: 
- create a basic worksheet by using Microsoft Excel 2010. 
- perform calculations in an Excel worksheet. 
- modify an Excel worksheet. 
- modify the appearance of data within a worksheet. 
- manage Excel workbooks. 
- print the content of an Excel worksheet. 
- 
use advanced formulas.  
- 
organize worksheet and table data using various techniques.  
- 
create and modify charts.  
- 
analyze data using PivotTables, Slicers, and PivotCharts.  
- 
insert and modify graphic objects in a worksheet.  
- 
customize and enhance workbooks and the Microsoft Office Excel environment 
Comments
Course Content Day 1:
 
Lesson 1: Getting Started with Excel
Identify the Elements of the Excel Interface 
Navigate and Select Cells in Worksheets 
Customize the Excel Interface 
Create a Basic Worksheet 
 
Lesson 2: Performing Calculations in an Excel Worksheet
Create Formulas in a Worksheet 
Insert Functions in a Worksheet 
Reuse Formulas 
 
Lesson 3: Modifying a Worksheet
Edit Worksheet Data 
Find and Replace Data 
Manipulate Worksheet Elements 
 
Lesson 4: Modifying the Appearance of a Worksheet
Apply Font Properties 
Add Borders and Colors to Cells 
Align Content in a Cell 
Apply Number Formatting 
Apply Cell Styles 
 
Lesson 5: Managing an Excel Workbook
Manage Worksheets 
View Worksheets and Workbooks 
 
Lesson 6: Printing Excel Workbooks
Define the Page Layout 
Print a Workbook 
 
Course Content Day 2:
 
Lesson 1: Calculating Data with Advanced Formulas
Apply Cell and Range Names 
Calculate Data Across Worksheets 
Use Specialized Functions 
Analyze Data with Logical and Lookup Functions 
 
Lesson 2: Organizing Worksheet and Table Data 
Create and Modify Tables 
Format Tables 
Sort or Filter Data 
Use Functions to Calculate Data 
 
Lesson 3: Presenting Data Using Charts
Create a Chart 
Modify Charts 
Format Charts 
 
Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts
Create a PivotTable Report 
Filter Data Using Slicers 
Analyze Data Using PivotCharts 
 
Lesson 5: Inserting Graphic Objects
Insert and Modify Pictures and ClipArt 
Draw and Modify Shapes 
Illustrate Workflow Using SmartArt Graphics 
Layer and Group Graphic Objects 
 
Lesson 6: Customizing and Enhancing the Excel Environment 
Customize the Excel Environment 
Customize Workbooks 
Manage Themes 
Create and Use Templates