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