Excel Basics :: Sam Burns
Excel Basics
Computing Resources >> Tutorials >> Office Suite >> Excel Basics  

Overview

Basics

Navigating in Excel

Data Types

Sorting Data

Alignment & Formatting

Importing & Printing

Functions

Charts & Graphs

Evaluate this tutorial

 

Basics

Basics

screen shot

  1. Opening a File

    Excel files have a .xls extension as opposed to a .doc extension for MS Word Documents and a .mdb for MS Access. Excel files are also referred to as Worksheets and Workbooks. [download tutorial2.xls to work along with the tutorial]

  2. screen shot

  3. Activating a Cell

    When you are working with an Excel worksheet, you can activate a particular cell simply by left clicking on it. Active cells are outlined and the corresponding row and column are highlighted.

  4. screen shot

  5. Cell Coordinates

    Cell coordinates refer to the row and column intersection in which the cell is found. In this case the intersection occurs at Row 4, Column C.

  6. screen shot

  7. Formula Bar

    The formula bar in Excel is where all the information entered for that cell will appear. Depending on what is entered in the cell, you may see text, numbers or formulas/functions here.

  8. screen shot

  9. Worksheets

    In Excel, one Workbook you may have many different worksheets. These tabs located at the bottom of the window enable you to control which worksheet you are working on at a given time and allow you to navigate through all of your available worksheets.

  10. screen shot

  11. Scroll Bars

    Excel worksheets often have many columns and rows. You can use the vertical and horizontal scroll bars to move around within your worksheet.

  12. screen shot

next section >

 

Watch the video
screenshot
choose format/speed
real media dial-up | broadband

html transcript

© 2004 Sam Burns| iSchool | UT Austin | webmaster