Excel 2 2010

Download PDF

Next Dates:

Thu, 31. May. 2012
Mon, 18. Jun. 2012
Tue, 31. Jul. 2012

Length:

1 Day

Location:

Ottawa

Language:

Max Attendees:

10 Students

Price:

$185

Target audience & Prerequisites:

This Course is designed for participants who know the basics of Excel

Learning objectives:

Upon completion of the course, you will be familiar with the following: Advanced formulas, using range names in formulas, managing worksheets within workbooks, using advance formatting techniques, creating and printing charts as well as sorting data in alphanumeric order.

Course Outline:

Calculating Data with Advanced Formulas

Apply Cell and Range Names
Calculate Data Across Worksheets
Use Specialized Functions
Analyze Data with Logical and Lookup Functions

Organizing Worksheet and Table Data

Create and Modify Tables
Format Tables
Sort or Filter Data
Use Functions to Calculate Data

Presenting Data Using Charts

Create a Chart
Modify Charts
Format Charts

Analyzing Data Using PivotTables, Slicers, and PivotCharts

Create a PivotTable Report
Filter Data Using Slicers
Analyze Data Using PivotCharts

Inserting Graphic Objects

Insert and Modify Pictures and ClipArt
Draw and Modify Shapes
Illustrate Workflow Using SmartArt Graphics
Layer and Group Graphic Objects

Customizing and Enhancing the Excel Environment

Customize the Excel Environment
Customize Workbooks
Manage Themes
Create and Use Templates

Remember that we build our schedule around your requests. Check out our Courses List, call us at (613) 235-6161 or email us at training@compuease.ca:

Calendar

Search

Course List