Compusoft Excel Level 2 Class is on 1/18/13 - Class starts at 9am Microsoft Excel 2010 Training Classes in Houston 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