Excel Classes in Houston - Instructor-led, Hands-on in our classroom Hands-on, instructor-led training classes Step-by-step training manual with exercise link Certificate of completion Training is also available at your location Course can be customized Private one-on-one classes are available 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