Comprehensive Microsoft Excel 2007 Training (3 days)

Comprehensive Microsoft Excel 2007 Training Course Overview

On the first day of this comprehensive Microsoft Excel 2007 training course, students will learn to use Excel to create, modify and format Excel worksheets, perform calculations, and print and Excel workbooks. On the second day, they will learn to will apply visual elements and advanced formulas to a worksheet to display data in various formats. And on the third day, they 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.

Comprehensive Microsoft Excel 2007 Training Course Goals

• Explore the Microsoft Office Excel 2007 environment and create a basic worksheet.
• Learn to perform calculations.
• Learn to modify a worksheet.
• Learn to format a worksheet.
• Learn to print workbook contents.
• Learn to manage large workbooks.
• 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.
• Increase productivity and improve efficiency by streamlining your workflow.
• Learn to collaborate with others using workbooks.
• Learn to audit worksheets.
• Learn to analyze data.
• Learn to work with multiple workbooks.
• Learn to import and export data.
• Learn to use Excel with the web.
• Learn to structure workbooks with XML.

Comprehensive Microsoft Excel 2007 Training Course Outline

1. Creating a Basic Worksheet
   1. Explore the User Interface and the Ribbon
   2. Navigate and Select in Excel
   3. Obtain Help
   4. Enter Data and Save a Workbook
   5. Customize the Quick Access Toolbar
2. Performing Calculations
   1. Create Basic Formulas
   2. Calculate with Functions
   3. Copy Formulas and Functions
3. Modifying a Worksheet
   1. Manipulate Data
   2. Insert and Delete Cells, Columns, and Rows
   3. Search for Data in a Worksheet
   4. Spell Check a Worksheet
4. Formatting a Worksheet
   1. Modify Fonts
   2. Add Borders and Color to Cells
   3. Change Column Width and Row Height
   4. Apply Number Formats
   5. Position Cell Contents
   6. Apply Cell Styles
5. Printing Workbook Contents
   1. Print Workbook Contents Using Default Print Options
   2. Set Print Options
   3. Set Page Breaks
6. Managing Large Workbooks
   1. Format Worksheet Tabs
   2. Manage Worksheets in a Workbook
   3. Manage the View of Large Worksheets
7. Calculating Data with Advanced Formulas
   1. Manage Cell and Range Names
   2. Calculate Data Across Worksheets
   3. Use Specialized Functions
   4. Analyze Data with Logical and Lookup Functions
8. Organizing Worksheet and Table Data
   1. Create and Modify Tables
   2. Format Tables
   3. Sort or Filter Worksheet or Table Data
   4. Calculate Data in a Table or Worksheet
9. Presenting Data Using Charts
   1. Create a Chart
   2. Modify Charts
   3. Format Charts
10. Analyzing Data Using PivotTables and PivotCharts
    1. Create a PivotTable Report
    2. Analyze Data Using PivotCharts
11. Inserting Graphic Objects
    1. Insert and Modify Pictures and ClipArt
    2. Draw and Modify Shapes
    3. Illustrate Workflow Using SmartArt Graphics
    4. Layer and Group Graphic Objects
12. Customizing and Enhancing Workbooks and the Excel Environment
    1. Customize the Excel Environment
    2. Customize Workbooks
    3. Manage Themes
    4. Create and Use Templates
13. Streamlining Workflow
    1. Create a Macro
    2. Edit a Macro
    3. Apply Conditional Formatting
    4. Add Data Validation Criteria
    5. Update a Workbook's Properties
    6. Modify Excel's Default Settings
14. Collaborating with Others
    1. Protect Files
    2. Share a Workbook
    3. Set Revision Tracking
    4. Review Tracked Revisions
    5. Merge Workbooks
    6. Administer Digital Signatures
    7. Restrict Document Access
15. Auditing Worksheets
    1. Trace Cells
    2. Troubleshoot Errors in Formulas
    3. Troubleshoot Invalid Data and Formulas
    4. Watch and Evaluate Formulas
    5. Create a Data List Outline
16. Analyzing Data
    1. Create a Trendline
    2. Create Scenarios
    3. Perform What-If Analysis
    4. Perform Statistical Analysis with the Analysis ToolPak
17. Working with Multiple Workbooks
    1. Create a Workspace
    2. Consolidate Data
    3. Link Cells in Different Workbooks
    4. Edit Links
18. Importing and Exporting Data
    1. Export Excel Data
    2. Import a Delimited Text File
19. Using Excel with the Web
    1. Publish a Worksheet to the Web
    2. Import Data from the Web
    3. Create a Web Query
20. Structuring Workbooks with XML
    1. Develop XML Maps
    2. Import and Export XML Data

Comprehensive Microsoft Excel 2007 Training Course Materials

In addition to a comprehensive set of materials, including course notes and all the programming examples, each student will also receive a one-year subscription to Webucator's online reference library, which contains hundreds of the most current electronic technology books - a $149.95 per student value.

Comprehensive Microsoft Excel 2007 Training Course Technical Requirements and Setup Instructions

Click here for technical requirements and setup instructions