Excel Training | Chicago

Fast Facts

Duration
1 day

Class Size
Max 10 students

Times
9.00am to 4.30pm

Computer
One per student

Training Manual
Included

Price
295.00

Excel 2007 - Level 2

Upcoming Classes
Course Outline
Instructors

Course Description

Excel Level 2 is the second of 3 levels of Excel training we offer. This is a hands-on class where participants will learn to enhance spreadsheets using templates, charts, graphics, and advanced formulas. You will also learn to sort and filter data and analyze data using PivotTables and PivotCharts.

Target Audience

The target audience for this course is anyone who needs to enhance there existing Excel skills beyond that of a basic user. Participants are recommended to have completed Excel Level 1 or have the equivalent experience prior to completing this course.

Leaning Objectives

Upon successful completion of this Excel training course students will be able to:

Calculate with Advanced Formulas.
Organize Worksheet and Table Data using various Techniques.
Create and Modify Charts.
Analyze data using PivotTables and PivotCharts.
Insert Graphic Objects.
Customize and Enhance Workbooks and the Excel environment.

Upcoming Classes

Chicago	Aug, 2008	Sep, 2008	Oct, 2008	Nov, 2008
Excel 2007 - Level 2		Sep 30	Oct 23	Nov 18

Click here for directions

Course Outline

Calculating Data with Advanced Formulas

Manage 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 Worksheet or Table Data
Calculate Data in a Table or Worksheet

Presenting Data Using Charts

Create a Chart
Modify Charts
Format Charts

Analyzing Data Using PivotTables and PivotCharts

Create a PivotTable Report
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 Workbooks and the Excel Environment

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

Meet the Instructors

Rich

Rich has been creating custom software programs, and delivering tailored training classes for the past 13 years. His passion for instruction and his pursuit of all things technical, combine with his outgoing personality to provide an engaging and enthusiastic exchange of knowledge and ideas with his trainees. Software training for Rich is a labor of love. As he puts it, "When you love what you do, it's really not work after all!"

CLOSE BIO

"Rich is a great instructor - full of energy and he made it exciting. I HIGHLY recommend this class for small business owners, employees of small businesses...EVERYONE! Everyone can benefit from this knowledge. Thanks!"

Shannon O'Brien - Rise Group

"Thank you so much the class was great! I would come back for more... Thanks again."

Amy Raymond - Grubb & Ellis

"Rich was very knowledgeable and PATIENT! I appreciate his willingness to repeat steps and share real life examples. He is motivated and encourages students to do their best. He gave positive reinforcement throughout the course. I learned a lot! Thank you, Rich, for making this course and the entire day meaningful."

Erica B. Davis - City of Chicago

... view bioRich

Adobe Training

Web Development

Microsoft Office

Business Skills

QuickBooks