Over a Decade of Serious Learning
for Ambitious Minds.
* 9.3 of 10 (over 13 k student survey results - 2015)
Request a quote

Find A
Class in Your City:

Microsoft Excel 2007 Intermediate / Advanced
Email this page | Print this page


Microsoft Excel 2007 Intermediate & Advanced

To View Class Dates:
Please use the pull down options on the upper left of this page to select your course and city. You can then navigate to other classes in that same city, view class descriptions and register for the class or you call us and register now, 877-760-0078.

  • Our Excel Introduction course is held before this course. It is a one-day class.
  • Training at your company site (group or 1on1) -- click here.
  • We have taught thousands of business professionals throughout the years. Read what our students say
  • Free repeats! You are allowed to repeat your class for free within 6 months for any reason whatsoever! Classes are 9am to 4pm and come with courseware and CD to practice afterward.
  • Are you signing up for more MS Office classes? See our package discounts page



Intermediate Course Description (scroll down for day two, Advanced outline)

In Microsoft Office Excel: Introduction, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Course Objective: You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Target Student: The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web.

Prerequisites: Before starting this course, students are recommended to take the following or possess equivalent knowledge: Microsoft Office Excel: Introduction.

Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Performance-Based Objectives
Upon successful completion of this 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 Microsoft® Office Excel® environment.

Course Content

Lesson 1: Calculating Data with Advanced Formulas

Topic 1A: Manage Cell and Range Names
Topic 1B: Calculate Data Across Worksheets
Topic 1C: Use Specialized Functions
Topic 1D: Analyze Data with Logical and Lookup Functions

Lesson 2: Organizing Worksheet and Table Data

Topic 2A: Create and Modify Tables
Topic 2B: Format Tables
Topic 2C: Sort or Filter Worksheet or Table Data
Topic 2D: Calculate Data in a Table or Worksheet

Lesson 3: Presenting Data Using Charts

Topic 3A: Create a Chart
Topic 3B: Modify Charts
Topic 3C: Format Charts

Lesson 4: Analyzing Data Using PivotTables and PivotCharts

Topic 4A: Create a PivotTable Report
Topic 4B: Analyze Data Using PivotCharts

Lesson 5: Inserting Graphic Objects

Topic 5A: Insert and Modify Pictures and ClipArt
Topic 5B: Draw and Modify Shapes
Topic 5C: Illustrate Workflow Using SmartArt Graphics
Topic 5D: Layer and Group Graphic Objects

Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment

Topic 6A: Customize the Excel Environment
Topic 6B: Customize Workbooks
Topic 6C: Manage Themes
Topic 6D: Create and Use Templates

DAY 2 -- Microsoft Excel 2007 Intermediate & Advanced

Course Description
Your training in and use of Microsoft® Office Excel® has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft® Office Excel. You have used Microsoft® Office Excel to perform tasks such as running calculations on data and sorting and filtering numeric data. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.

Course Objective:
You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Target Student: This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

Delivery Method:
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Performance-Based Objectives

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

·         increase productivity and improve efficiency by streamlining your workflow.

·         collaborate with others using workbooks.

·         audit worksheets.

·         analyze data.

·         work with multiple workbooks.

·         import and export data.

·         use Excel with the web.

·         structure workbooks with XML.

Course Content

Lesson 1: Streamlining Workflow

Topic 1A: Create a Macro
Topic 1B: Edit a Macro
Topic 1C: Apply Conditional Formatting
Topic 1D: Add Data Validation Criteria
Topic 1E: Update a Workbook's Properties
Topic 1F: Modify Excel's Default Settings

Lesson 2: Collaborating with Others

Topic 2A: Protect Files
Topic 2B: Share a Workbook
Topic 2C: Set Revision Tracking
Topic 2D: Review Tracked Revisions
Topic 2E: Merge Workbooks
Topic 2F: Adjust Macro Settings
Topic 2G: Administer Digital Signatures
Topic 2H: Restrict Document Access

Lesson 3: Auditing Worksheets

Topic 3A: Trace Cell Precedents
Topic 3B: Trace Cell Dependents
Topic 3C: Troubleshoot Errors in Formulas
Topic 3D: Troubleshoot Invalid Data and Formulas
Topic 3E: Watch and Evaluate Formulas
Topic 3F: Create a Data List Outline

Lesson 4: Analyzing Data

Topic 4A: Create a Trendline
Topic 4B: Create Scenarios
Topic 4C: Perform What-If Analysis
Topic 4D: Perform Statistical Analysis with the Analysis ToolPak

Lesson 5: Working with Multiple Workbooks

Topic 5A: Create a Workspace
Topic 5B: Consolidate Data
Topic 5C: Link Cells in Different Workbooks
Topic 5D: Edit Links

Lesson 6: Importing and Exporting Data

Topic 6A: Export Excel Data
Topic 6B: Import a Word Table
Topic 6C: Import a Delimited Text File

Lesson 7: Using Excel with the Web

Topic 7A: Publish a Worksheet to the Web
Topic 7B: Import Data from the Web
Topic 7C: Create a Web Query

Lesson 8: Structuring Workbooks with XML

Topic 8A: Develop XML Maps
Topic 8B: Import and Export XML Data
Topic 8C: Manage XML Workbooks

Appendix A: Microsoft Office Specialist Program