Excel Basics
Technology Training
Microsoft Excel The Basics
• • • • Around the Spreadsheet Window Entering and Working with Data Visualizing Data: Creating Charts Using Excel as a Data Base
Valerie T. Low Region II Technology Coordinator
1
Microsoft Excel Tutorial
Valerie T. Low, RII RTC
Excel Tutorial
I. Basics-Around the spreadsheet window Columns/labels o Column headings like fields in data base Rows/labels o rows are records Scroll bars
Formula Bar Name Box Column Headings Up Scroll Bar
Row Numbers
Worksheet Names Scroll to Worksheets
Down Scroll Bar Left & Right Scroll Bars
Tool bar:
Zoom Control Selecting rows or columns
Inserting and deleting Expanding Columns
2
Microsoft Excel Tutorial
Valerie T. Low, RII RTC
Saving Documents Select File>Save As The following window is displayed: The default (typical) folder to save documents in is the My Documents. To change this folder, click on the down-pointing (to the right). Select a different location, e.g. 3 ½ floppy, if you want to save on a disk.
Note: If you plan to bring the information from an Excel spreadsheet into another program, e.g. an address book, Select File>Save As (a second time) Type a new file name. Click the arrow next to the Save as type box. Select Text (Tab delimited) Click Save. This file will be able to be imported into different programs.
3
Microsoft Excel Tutorial
Valerie T. Low, RII RTC
II. Entering data Use tab, return or enter, arrow keys to move about spreadsheet To change an entry, double click in cell, tap delete or backspace; re-type the data. Formatting cells Format menu Tool bar options Auto format Format painter Edit menu Cut, copy, paste Copying data from other sources Multiple cut and paste (View> Toolbars> Clipboard Auto calculate -Right click the area on the status bar Choose one of the available functions e.g. sum) result is displayed in Auto calculate area Expanding rows & using text wrap Fill Select Edit>Fill (and...
View Full Essay