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
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 2
Microsoft Excel Class in Houston, Texas
MS Excel Training Houston, TX
Microsoft 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
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.
http://www.compusoftusa.com/index.php?option=com_philaform&Itemid=35&form_id=5
http://www.compusoftusa.com/index.php?option=com_philaform&Itemid=35&form_id=5
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.
| 
Be the first to comment on this listing!