Microsoft Excel 2010 Training Classes in Houston

Microsoft Word Training Classes in Houton Microsoft Excel 2010 Course Outlines

Contact us at 713-777-7664 for pricing.

• Hands-on, instructor-led training classes
• Step-by-step training manual with exercise link
• Certificate of completion

• Onsite Training available
• Class can be customized to suit your needs
• Private one-on-one classes are available

Listed below are our standard Course Outlines.

Each course is instructor led hands-on classroom-training using step-by-step student manual and exercises.

Microsoft Excel 2010 - Training Classes in Houston, Texas


Microsoft Excel 2010: Level 1


Training Course Content

Lesson 1: Getting Started with Excel

Topic 1A: Identify the Elements of the Excel Interface
Topic 1B: Navigate and Select Cells in Worksheets
Topic 1C: Customize the Excel Interface
Topic 1D: Create a Basic Worksheet

Lesson 2: Performing Calculations in an Excel Worksheet

Topic 2A: Create Formulas in a Worksheet
Topic 2B: Insert Functions in a Worksheet
Topic 2C: Reuse Formulas

Lesson 3: Modifying a Worksheet

Topic 3A: Edit Worksheet Data
Topic 3B: Find and Replace Data
Topic 3C: Manipulate Worksheet Elements

Lesson 4: Modifying the Appearance of a Worksheet

Topic 4A: Apply Font Properties
Topic 4B: Add Borders and Colors to Cells
Topic 4C: Align Content in a Cell
Topic 4D: Apply Number Formatting
Topic 4E: Apply Cell Styles

Lesson 5: Managing an Excel Workbook

Topic 5A: Manage Worksheets
Topic 5B: View Worksheets and Workbooks

Lesson 6: Printing Excel Workbooks

Topic 6A: Define the Page Layout
Topic 6B: Print a Workbook

Appendix A: Microsoft Office Excel 2010 Exam 77–882


Microsoft Excel 2010: Level 2


Training Course Content

Lesson 1: Calculating Data with Advanced Formulas

Topic 1A: Apply 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 Data
Topic 2D: Use Functions to Calculate Data

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, Slicers, and PivotCharts

Topic 4A: Create a PivotTable Report
Topic 4B: Filter Data Using Slicers
Topic 4C: 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 the Excel Environment

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


Microsoft Excel 2010: Level 3


Training Course Content

Lesson 1: Streamlining Workflow

Topic 1A: Update Workbook Properties
Topic 1B: Create a Macro
Topic 1C: Edit a Macro
Topic 1D: Apply Conditional Formatting
Topic 1E: Add Data Validation Criteria

Lesson 2: Collaborating with Other Users

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 Invalid Data and Formula Errors
Topic 3C: Watch and Evaluate Formulas
Topic 3D: Create a Data List Outline

Lesson 4: Analyzing Data

Topic 4A: Create a Trendline
Topic 4B: Create Sparklines
Topic 4C: Create Scenarios
Topic 4D: Perform a What-If Analysis
Topic 4E: Perform a 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: Integrating Excel Data 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


Microsoft Excel 2010: Level 4


Training Course Content

Lesson 1: Manipulating Data Using Statistical and Lookup Functions

Topic 1A: Forecast GDP Using Statistical Functions
Topic 1B: Evaluate Sales Data Using Statistical Functions
Topic 1C: Analyze Stock Data Using Statistical Functions
Topic 1D: Mine Data Using the Lookup and Reference Functions

Lesson 2: Analyzing Data Using Data Analysis Tools

Topic 2A: Analyze Sales Data Using Descriptive Statistics
Topic 2B: Analyze Time Series Data Using Exponential Smoothing
Topic 2C: Analyze Data Using Regression
Topic 2D: Identify the Beta Value of a Security
Topic 2E: Analyze Sector Data Using Correlation and Covariance Matrices
Topic 2F: Optimize a Stock Portfolio Using Solver

Lesson 3: Working with Data Using Financial Functions

Topic 3A: Develop an Investment Schedule Using Financial Functions
Topic 3B: Make Investment Decisions Using Financial Functions

Lesson 4: Examining Data Using Math Functions

Topic 4A: Analyze Sales Data Using Math Functions
Topic 4B: Calculate Stock Returns Using Math Functions
Topic 4C: Aggregate GDP Data Using Math Functions

Lesson 5: Manipulating Data Using Text and Information Functions

Topic 5A: Manipulate Data Using Text Functions
Topic 5B: Validate Data Using Information Functions

Lesson 6: Working with Templates and Charts

Topic 6A: Create Advanced Templates
Topic 6B: Create Advanced Charts

Lesson 7: Managing Data in Workbooks

Topic 7A: Retrieve and Paste Data
Topic 7B: Clean Data in Workbooks

Appendix A: Commonly Used Excel Functions
Appendix B: Microsoft Office Excel 2010 Exam 77–882
Appendix C: Microsoft Office Excel Expert 2010 Exam 77–888

See Current Schedule

Register for Class

Microsoft Excel Computer Class in Houston

Microsoft Excel 2010 Training in Houston

Microsoft Excel 2007 Training in Houston 

Microsoft Excel 2003 Training in Houston