Excel Training | Chicago & Los Angeles
Fast Facts
1 day
Max 8 students
9.00am to 4.30pm
One per student
Included
295.00
Excel 2007 - Level 2
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. View past student's video testimonials.
Target Audience
The target audience for this course is anyone who needs to enhance their 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.
Excel Training Deals
Register for more than one level of Excel training and save. Find out more about our Excel training deals and our 100% Money Back Guarantee.
Learning Objectives
Upon successful completion of this Microsoft Excel class 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 |
Mar, 2010 | Apr, 2010 | May, 2010 | Jun, 2010 |
| Excel 2007 - Level 2 | Mar 23 ! | Apr 13 ! | May 11 ! | Jun 22 |
Los Angeles |
Mar, 2010 | Apr, 2010 | May, 2010 | Jun, 2010 |
| Excel 2007 - Level 2 | Mar 16 * | Apr 20 | May 18 |
* Class almost full ! Class guaranteed to run † Class is full
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!"
