MS Excel

Microsoft® Excel Course Description

Introduction to MS Excel includes:

Exploring Excel: Starting Excel; Working with Worksheets; Using Menu Commands; Displaying & Hiding Toolbars; Exiting Excel
Using the Office Assistant: Finding an answer; Selecting an Assistant; Changing Assistant Options; Hiding the Assistant
Using Basic Workbook Skills: Creating a New Workbook; Selecting a Cell; Entering Text into Cells; Saving a New Workbook; Opening an Existing Workbook; Using AutoComplete; Using Pick from List; Editing Cell Entries; Renaming an Existing Workbook
Creating Simple Formulas: Entering Formulas; Using the AutoSum Button; Using Functions; Using Formula AutoCorrect; Using Formula Palette; Using Paste Function; AutoCalculate; Using Range Finder
Printing Worksheets: Previewing a Worksheet, Selected Range or Page Range; Multiple Copies
Using Page Setup: Changing Page Margins & Page Orientation; Centering the Worksheet; Customizing Headers & Footers; Printing Without Gridlines; Repeating Row & Column Labels
Formatting Text & Numbers: Changing Text Appearance using Font List, Font Size List, Bold/Italic/Underline/Font Color Buttons; Wrapping/Rotating/Shrinking Text in a Cell; Merging Cells; Indenting Text; Using Currency, Percent, & Comma Styles; Increasing Decimal Places
Working With Columns & Rows: Changing Column Width & Row Height; Inserting & Deleting Columns & Rows; Hiding & Unhiding Columns
Formatting Cells: Using the Alignment, Center & Merge, Borders, Fill Color and Format Painter Buttons; Using Conditional Formatting; Copying to Non-Adjacent Cells
Using Charts: Chart Wizard; Moving & Resizing Charts; Identifying Chart Objects; Changing the Chart Type; Adding a Legend or Data Table; Changing the Chart Range; Formatting Chart Objects; Printing or Deleting a Chart
Using Online Help.

Intermediate MS Excel includes:

Using Large Worksheets: Increasing/Decreasing Magnification; Splitting Windows; Working with Panes
Working With Multiple Sheets & Workbooks: Navigating, Selecting, Inserting, Deleting & Printing using Multiple Worksheets & Workbooks
Managing Worksheets: Using Grouped Worksheets,
Moving & Copying Data Between Sheets, Creating 3-D Formulas, Using Functions in Worksheets
Using Paste Special: Copying Formats, Values & Formulas Between Sheets; Performing Mathematical Operations
Using Range Names: Assigning, Applying & Deleting Range Names; Jumping to Named Ranges; Using Range Names in Formulas; Naming & Referencing 3-D Ranges
Using Labels in Formulas: Using Labels to Define a Range; Using Multiple Stacked Headings; Identifying Individual Cells
Editing Charts: Changing the Chart Type/Sub-Type; Changing Chart Options & Data Sources; Titles & Legends; Printing a Chart Sheet
Working With Databases: Creating & Editing a Database; Adding, Inserting & Deleting Records; Inserting & Deleting Fields; Validating Data; Sorting Records
Sorting Data: Sorting by Multiple Fields; Creating, Editing & Deleting a Custom Sort Order; Sorting From Left to Right
Using Macros: Defining, recording & editing macros; Using Visual Basic Editor; Running Macros; Using Relative References; Defining & Using a Shortcut Key; Assigning to a Menu; Rudding From a Code Window;
Creating Macro Buttons
Debugging Macros: Stepping Through Macros;
Send mail to Webmaster with questions or comments about this web site.
Copyright © 2000 The Computer Tutor, Inc. All rights reserved.
Last modified: Wednesday, March 26, 2003
Setting Breakpoints; Correcting Statement Errors
Importing & Exporting Data andWorksheet Protection

Welcome to the on-line home of The Computer Tutor Inc. .....