Microsoft Excel Classes in Houston on Sale Call 713-777-7664 – Houston

Microsoft Excel Would you like to Learn Microsoft Excel the Right way? Hands-on & Step-by-Step With an Experienced Instructor Guiding you through every step! For Groups, Onsite (at your location) in our class-rooms or One-on-One Classes Call 713-777-7664 Microsoft Excel Class in Houston, TexasMS Excel Training Houston, TXMicrosoft Excel Training Classes in Houston, Texas Call 713-777-7664 See Current Schedule See Current Specials Register for Class Microsoft® Office Excel 2003: Level 1 Training Course Content Lesson 1: Getting Started with Excel Topic 1A: An Overview of Excel Topic 1B: Navigate in Excel Topic 1C: Select Data Topic 1D: Enter Data Topic 1E: Save a Workbook Topic 1F: Obtain Help Lesson 2: Modifying a Worksheet Topic 2A: Move and Copy Data Between Cells Topic 2B: Fill Cells with Series of Data Topic 2C: Edit Cell Data Topic 2D: Insert and Delete Cells, Columns, and Rows Topic 2E: Find, Replace, and Go To Cell Data Topic 2F: Spell Check a Worksheet Lesson 3: Performing Calculations Topic 3A: Create Basic Formulas Topic 3B: Calculate with Functions Topic 3C: Copy Formulas and Functions Topic 3D: Create an Absolute Reference Lesson 4: Formatting a Worksheet Topic 4A: Change Font Size and Type Topic 4B: Add Borders and Color to Cells Topic 4C: Change Column Width and Row Height Topic 4D: Merge Cells Topic 4E: Apply Number Formats Topic 4F: Create a Custom Number Format Topic 4G: Align Cell Contents Topic 4H: Find and Replace Formats Topic 4I: Apply an AutoFormat Topic 4J: Apply Styles esson 5: Developing a Workbook Topic 5A: Format Worksheet Tabs Topic 5B: Reposition Worksheets in a Workbook Topic 5C: Insert and Delete Worksheets Topic 5D: Copy and Paste Worksheets Topic 5E: Copy a Workbook Lesson 6: Printing Workbook Contents Topic 6A: Set a Print Title Topic 6B: Create a Header and a Footer Topic 6C: Set Page Margins Topic 6D: Change Page Orientation Topic 6E: Insert and Remove Page Breaks Topic 6F: Print a Range Lesson 7: Customizing Layout Topic 7A: Split a Worksheet Topic 7B: Arrange Worksheets Topic 7C: Freeze and Unfreeze Rows and Columns Topic 7D: Hide and Unhide Worksheets Appendix A: Microsoft Office Specialist Program Level 1 Course Summary: Students will create and edit basic Excel worksheets and workbooks, use basic formulas, and apply common formatting and printing techniques. Level 1 Prerequisites: To ensure your success, each student should have a general knowledge of Microsoft Windows and Microsoft Office concepts. Contact us to discuss if this level is right for you. Delivery Method: Instructor led, group-paced, hands-on classroom-training with activities. Additionally, manuals are provided for each student for after-class reference. Microsoft® Office Excel 2003: Level 2Microsoft Excel Class in Houston, TexasMS Excel Training Houston, TXMicrosoft Excel Training Classes in Houston, Texas See Current Schedule See Current Specials Register for Class Training Course Content Lesson 1: Creating and Applying Templates Topic 1A: Create a Workbook from a Template Topic 1B: Create a Custom Template Topic 1C: Working with Comments Topic 1D: Create a Hyperlink Topic 1E: Use Web-based Research Tools Lesson 2: Creating and Modifying Charts Topic 2A: Create a Chart Topic 2B: Format Chart Items Topic 2C: Change the Chart Type Topic 2D: Create a Diagram Lesson 3: Working with Graphic Objects Topic 3A: Insert Graphics Topic 3B: Create AutoShapes Topic 3C: Format Graphic Objects Topic 3D: Change the Order of Graphic Objects Topic 3E: Group Graphic Objects Topic 3F: Move, Copy, and Resize Graphic Objects Lesson 4: Calculating with Advanced Formulas Topic 4A: Create and Apply a Name for a Range of Cells Topic 4B: Calculate Across Worksheets Topic 4C: Calculate with Date and Time Functions Topic 4D: Calculate with Financial Functions Topic 4E: Calculate with Statistical Functions Topic 4F: Calculate with Lookup and Reference Functions Topic 4G: Calculate with Logical Functions Lesson 5: Sorting and Filtering Data Topic 5A: Sort Data Lists Topic 5B: Filter Data Lists Topic 5C: Create and Apply Advanced Filters Topic 5D: Calculate with Database Functions Topic 5E: Add Subtotals to a Worksheet Lesson 6: Using Excel with the Web Topic 6A: Export Excel Data Topic 6B: Publish a Worksheet to the Web Topic 6C: Import Data from the Web Topic 6D: Create a Web Query Appendix A: Microsoft Office Specialist Program Level 2 Course Summary: Students will learn to create templates, sort and filter data, import and export data, analyze data, and work with Excel web tools. Level 2 Prerequisites: To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Excel. Knowledge of basic formulas is also recommended. Students can obtain this level of skill through our Level 1 course. Contact us to discuss if this level is right for you. Delivery Method: Instructor led, group-paced, hands-on classroom-training with activities. Additionally, manuals are provided for each student for after-class reference. Microsoft® Office Excel 2003: Level 3 Microsoft Excel Class in Houston, Texas MS Excel Training Houston, TX Microsoft Excel Training Classes in Houston, Texas Call 713-777-7664 See Current Schedule See Current Specials Register for Class Training Course Content Lesson 1: Streamlining Workflow Topic 1A: Create a Macro Topic 1B: Run a Macro Topic 1C: Customize Access to Excel Commands Topic 1D: Update a Workbook's Settings Topic 1E: Modify Excel's Default Settings Topic 1F: Adjust Macro Settings Lesson 2: Collaborating with Others Topic 2A: Protect Workbooks, Sheets, Cells Topic 2B: Share a Workbook Topic 2C: Set Revision Tracking Topic 2D: Review Tracked Revisions Topic 2E: Merge Workbooks Topic 2F: Additional Protection Items Topic 2G: Add Data Validation Criteria Lesson 3: Auditing Worksheets Topic 3A: Trace Cell Precedents Topic 3B: Trace Cell Dependents Topic 3C: Locate Errors in Formulas Topic 3D: Locate Invalid Data and Formulas Topic 3E: Watch and Evaluate Formulas Lesson 4: Analyzing Data Topic 4A: Create a Trendline Topic 4B: Create Scenarios Topic 4C: Perform What-If Analysis Topic 4D: Develop a PivotTable Report Topic 4E: Develop a PivotChart Report Topic 4F: Review Analysis ToolPak Topic 4G: Group and Outline Data 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 to Microsoft Word Topic 6B: Import a Word Table Topic 6C: Import Text Files Lesson 7: Additional Features Topic 7A: Formulas, Shortcuts, Tips and more.

• Neighborhood: Houston
•  
• Provided by