Webucator went above and beyond my expectations for an online course. I would highly recommend them to anyone.
More Testimonials »
Intermediate Microsoft Excel 2007 Training
Delivery Options
- Customized Onsite Training (1 day): Request a Proposal
Class Description
Class Overview
This Microsoft Excel training course is designed for students with some experience working with Microsoft Excel 2007. Students will learn to will apply visual elements and advanced formulas to a worksheet to display data in various formats.
Class Goals
- Learn to calculate with advanced formulas.
- Learn to organize worksheet and table data using various techniques.
- Learn to create and modify charts.
- Learn to analyze data using PivotTables and PivotCharts.
- Learn to insert graphic objects.
- Learn to customize and enhance workbooks and the Microsoft Office Excel environment.
Class 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
Class Materials
Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.
Class Prerequisites
Experience in the following areas is required:
- Experience with Excel 2007 equivalent to that taught in Introduction to Microsoft Excel 2007 Training.
Technical Requirements
Our computer technical requirements and setup process is easy, with support just a click away.
- Onsite and Instructor-led Online course technical requirements and setup instructions.
- WebEx system requirements for Instructor-led Online delivery option.
Watch 3-minute Demo Video
of Live Online Training:
of Live Online Training:
Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.