Quick Source Learning | Quick Source Learning | Excel 2003 Basic Course

Excel 2003 Basic Course

Microsoft Excel

 


"


 

 

E03B

The Quick Source eLearning Series combines three levels of training: Learn It, Try It, and Evaluation. The Learn It section includes high quality video that shows you everything the instructor is teaching. The Try It section allows you to practice what you have learned right in our course. There is no need to switch between the course, and the software that you are learning. The Evaluation section gives you the ability to test your knowledge and receive immediate feedback.


Topics covered in this course:

Getting Started

  • Starting and Exiting Excel 2003
  • Identifying the Parts of the Excel 2003 Window
  • Using the Task Pane
  • Creating a New Workbook
  • Opening an Existing Workbook
  • Searching for a Workbook
  • Saving a Workbook
  • Closing Workbooks
  • Using the Standard Toolbar

Workbooks and Worksheets

  • Inserting Worksheets
  • Renaming a Worksheet
  • Moving, Copying, and Deleting a Worksheet
  • Color Coding a Worksheet Tab
  • Zooming In and Out on a Worksheet
  • Viewing Multiple Worksheets
  • Comparing Workbooks Side by Side

Cells, Rows, and Columns

  • Selecting Cells, Rows, or Columns
  • Inserting Cells, Rows, or Columns
  • Deleting Cells, Rows, or Columns
  • Adjusting Row Height and Column Width
  • Splitting Worksheet Panes
  • Freezing Rows and Columns
  • Changing the Color of Cell Gridlines
  • Hiding Cell Gridlines
  • Printing Cell Gridlines

Data

  • Entering Data
  • Using the AutoFill Feature
  • Using the AutoFormat Feature
  • Moving or Copying Data
  • Using the Office Clipboard
  • Using Repeat, Undo, and Redo
  • Sorting Data
  • Filtering Data
  • Using the Research Task Pane

Formatting Cells

  • Assigning a Number Format for a Cell
  • Changing the Font, Font Size, and Text Color
  • Applying Bold, Italics, or Underline to Text
  • Aligning Text
  • Displaying Multiple Lines of Text in a Cell
  • Merging Cells
  • Formatting Cell Borders
  • Applying Shading to Cells
  • Using the Format Painter
  • Clearing Cell Formats

Formulas

  • Understanding Formulas
  • Creating and Editing a Formula
  • Inserting Functions in Formulas
  • Using the AutoSum Tool
  • Moving or Copying a Formula
  • Working with Formulas
  • Naming a Cell or Range of Cells
  • Using the Watch Window

Output

  • Creating Headers and Footers
  • Previewing a Worksheet
  • Using Page Break Preview
  • Defining the Page Setup
  • Printing Worksheets and Selections
  • Setting Up the Print Area
  • E-Mailing a Workbook
  • Printing Row and Column Headings on Every Page

Getting Help

  • Using the Type a Question for Help Box
  • Using the Help Task Pane
  • Using the Office Assistant
  • Hiding or Turning Off the Assistant
  • Changing the Assistant
  • Getting Help in a Dialog Box
  • Getting Help from Office Online
  • Printing a Help Topic