Excel 2007

Excel 2007 - Level 1

Course length: 6 hours

Prerequisites: Windows – Level 1 or equivalent knowledge

What’s in Excel 2007 – Level 1?
You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will learn to: create a basic worksheet, modify a worksheet, perform calculations, format a worksheet, develop a workbook and print the contents of a workbook.

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

  • Explore Excel 2007 environment and create a basic worksheet.
  • Perform calculations.
  • Modify a worksheet.
  • Format a worksheet.
  • Print workbook contents.
  • Manage large workbooks.


Course Content

Lesson 1: Creating a Basic Worksheet

  • Topic 1A: Explore the User Interface and the Ribbon
  • Topic 1B: Navigate and Select in Excel
  • Topic 1C: Obtain Help
  • Topic 1D: Enter Data and Save a Workbook
  • Topic 1E: Customize the Quick Access Toolbar


Lesson 2: Performing Calculations

  • Topic 2A: Create Basic Formulas
  • Topic 2B: Calculate with Functions
  • Topic 2C: Copy Formulas and Functions


Lesson 3: Modifying a Worksheet

  • Topic 3A: Manipulate Data
  • Topic 3B: Insert and Delete Cells, Columns, and Rows
  • Topic 3C: Search for Data in a Worksheet
  • Topic 3D: Spell Check a Worksheet


Lesson 4: Formatting a Worksheet

  • Topic 4A: Modify Fonts
  • Topic 4B: Add Borders and Color to Cells
  • Topic 4C: Change Column Width and Row Height
  • Topic 4D: Apply Number Formats
  • Topic 4E: Position Cell Contents
  • Topic 4F: Apply Cell Styles


Lesson 5: Printing Workbook Contents

  • Topic 5A: Print Workbook Contents Using Default Print Options
  • Topic 5B: Set Print Options
  • Topic 5C: Set Page Breaks


Lesson 6: Managing Large Workbooks

  • Topic 6A: Format Worksheet Tabs
  • Topic 6B: Manage Worksheets in a Workbook
  • Topic 6C: Manage the View of Large Worksheets

Excel 2007 - Level 2

Course length: 6 hours

Prerequisites: Excel 2007 – Level 1 or equivalent knowledge

What’s in Excel 2007 – Level 2?
In Excel 2007 - Level 1, 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 learn how to: enhance your spreadsheets with templates, charts, graphics, and formulas.

Objectives
Upon successful completion of this course, you 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.

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

Excel 2007 - Level 3

Course length: 6 hours

Prerequisites: Excel 2007 – Level 2 or equivalent knowledge

What’s in Excel 2007 – Level 3?
You have used 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.

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.

Objectives
Upon successful completion of this course, you 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: Administer Digital Signatures
  • Topic 2G: Restrict Document Access


Lesson 3: Auditing Worksheets

  • Topic 3A: Trace Cells
  • Topic 3B: Troubleshoot Errors in Formulas
  • Topic 3C: Troubleshoot Invalid Data and Formulas
  • Topic 3D: Watch and Evaluate Formulas
  • Topic 3E: 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 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