Microsoft Excel 2007 Level 2 12/04/09 - Hurry - Discounts - Call 713-777-7664

Microsoft Excel 2007 Level 1 12/04/09 - Hurry - Discounts - Call 713-777-7664

Call 713-777-7664 or visit http://compusoftusa.com

Microsoft Excel Level 1 Class in Houston - 12/16/09
Microsoft Excel Level 2 Class in Houston - 12/23/09
Microsoft Excel Level 3 Class in Houston - 12/30/09

Microsoft Excel 2007 Level 1 Class in Houston - 11/20/09
Microsoft Excel 2007 Level 2 Class in Houston - 12/04/09
Microsoft Excel 2007 Level 3 Class in Houston - 12/18/09
Microsoft Excel 2007 Level 4 Class in Houston - Call 713-777-7664
Microsoft Excel VBA Class in Houston - Call 713-777-7664

Learn the changes between Microsoft Excel 2003 and Microsoft Excel 2007 New Features Class in Houston- Call 713-777-7664

Microsoft Excel 2007 Training in Houston - Hands on Microsoft Excel 2007 Classes in Houston, Texas
Hands on Microsoft Excel 2007 Training in Houston, Texas
Microsoft Excel 2007 Classes in Houston, Texas




Call 713-777-7664



The best way to learn Microsoft Excel 2007 is hands-on and step-by-step!

This is a Hands-on, Instructor-led Microsoft Excel 2007 Training Class.

You will receive a step-by-step manual with exercise CD.

You will also receive a Certificate of successful completion .



Have a group of staff members that needs this training?

We offer training classes both on-site (at your location) and in our computer labs - Inquire about our group-discount pricing.



Microsoft Excel 2007 - Training Classes in Houston, Texas

Call 713-777-7664







Microsoft® Office Excel ® 2007: Level 1


--------------------------------------------------------------------------------

Performance-Based Objectives

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


Training 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





--------------------------------------------------------------------------------







Microsoft® Office Excel ® 2007: Level 2


--------------------------------------------------------------------------------

Performance-Based Objectives

•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.


Training 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






--------------------------------------------------------------------------------






Microsoft® Office Excel ® 2007: Level 3


--------------------------------------------------------------------------------

Performance-Based Objectives

•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.


Training 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




See Current Schedule

See Current Specials

Register for Class

Microsoft Excel 2007 Training in Houston

Microsoft Excel 2003 Training in Houston

Microsoft Excel computer classes offerings in Houston