Wk 1 Excel Presentation23

7/28/2019 Wk 1 Excel Presentation23

1/34

Microsoft ExcelAn Introduction to Excel


2/34

Excelspreadsheet

Workbook Parts of aworkbook

Shortcut keys Data types


3/34

What is an ExcelSpreadsheet?


4/34

An excel spreadsheet isbasically a table in a row-by-column layout which haspowerful mathematical

applications, including theability to produce charts andextremely complicateddatabases.


5/34

Uses of Excel

Accounting Purposes

Charts

Storing and handling of information

(e.g. inventories)


6/34

Tip:

When you open up a spreadsheet make sure

that you save your file first by clicking File, then

Save As, and type your file name, ensuring thelocation of the saved file is correct..


7/34

What is a Workbook?


8/34

A workbook is excel Excels term for a file, e.g.where you enter your data..


9/34

It is like a notebook that contains multiple

pages, which are called worksheets.Whenever you open a new workbook, the

default number of worksheet is three.

These worksheets are labeled as Sheet1,Sheet2 & Sheet3


10/34

An Original Workbook

>each worksheets divided into 256 columns and

65,536 rows.

>each cell can contain 32,000 characters.

Right click to worksheet tab to:

Add extra sheets

Delete sheetsRename sheetsMove sheetsCopy sheets


11/34

Parts of a Workbook Window


12/34

1.Title Bar

-Display the program name and the name of theactive workbook.

2.Menu Bar

-Horizontal bar near the top of the screencontaining commands to perform actions on yourworkbook


13/34

3. Standard Toolbar

Collections of buttons which perform

related commands to perform actions on

your book.

Tool Bar Button

A button or a graphic image that performs aparticular command. Buttons are also called

icons or tools


14/34

4. Name Box

Display the active cells address (D8 is theintersection column D, row 8) or selected

area(s) name.

5. Formula Bar

Display the true content of the active cell(=,)MATHEMATICAL OPERATORS

+ - Addition

- - Subtraction* - Multiplication

/ - Division


15/34

6. Column

A vertical collections of cells, identified by a

letter.7. Row

A horizontal collections of cells, identified by anumber.

8. Active cell

is the one your typing is about to into,identified by a heavy border or reverse color

scheme. The active cells address is shown inthe name box.


16/34

9. Worksheet tabEach worksheet is named. The name appears

on the tab. Defaults names are sheet1, sheet2,

sheet3. Tabs can be renamed.

10 Mouse Pointer


17/34

10. Mouse Pointer

The shape of the mouse as you

move it around the screen. The

shape changes according to

where you point.

Resize Normal Select

Fill Handle Cell Select

Text Select


18/34

11. Status Bar

The Status bar is always displayed at the base

of the screen,keyboard or program.12. Cells

The intersection of a column and a row,

identified by its column C and row 5) each cellcan hold up 32,000 characters cells.


19/34


20/34

Selecting and Filling in a Cell

Selecting cells -Mouse techniqueKeyboard Technique - Shift Arrow keys

- Ctrl Click

Auto fill - Applicable forDays, Months, and Consecutive

numbers


21/34

13. Scroll Bars

Bars allow you to view other parts of theworksheet.

Horizontal Scroll bar

allows you to move left and right

Vertical Scroll bar

allows you to move up and down

M B St d d T lb


22/34

Menu Bar Standard Toolbar

FormattingToolbar


23/34

Page upPage down

Ctrl Home - Returning the cell pointer

to A1Alt Page down - Moving one full screen

to the right

Alt Page upCtrl Moves to cell IV1


24/34

Ctrl - Moves to cell IV65536

Ctrl - Moves to cell A65536

Ctrl Home - Moves to cell A1

F5 - quick moving to a certain cell

Alt F4 - Exit

Ctrl N - New

Ctrl S - Save

Ctrl C -Copy


25/34

Drag - Copy a Formula

Ctrl V - Paste

Ctrl X - Cut

Delete - Delete the content of the

cell

F2 - Edit formula


26/34


27/34

Types of Data in Excel


28/34

Types of data in Excel There are three different types ofdata in Excel:

labels values dates/times A label is an entry that is usually used for headings,

names, and for identifying columns of data. Labels can

contain letters and numbers. By default, labels are leftaligned in a cell. A value contains numbers and can be used in calculations.

By default, values are right aligned in a cell. Date/time data is just that, a date or the time entered into a

cell. By default, date/time data is right aligned in a cell.

Sometimes dates are combined with numbers andconsidered to be values instead of a separate type of data.
http://spreadsheets.about.com/od/l/g/label_defined.htmhttp://spreadsheets.about.com/od/uvw/g/value_def.htmhttp://spreadsheets.about.com/od/uvw/g/value_def.htmhttp://spreadsheets.about.com/od/l/g/label_defined.htm


29/34

How to Enter Data into a Spreadsheet

Entering yourdata into a spreadsheet is always athree step process. These steps are:

Click on the cell where you want the data to go. Type your data into the cell.

Press the ENTER key on the keyboard or click onanother cell with the mouse.
http://spreadsheets.about.com/od/d/g/data_definition.htmhttp://spreadsheets.about.com/od/s/g/spreadsheet_def.htmhttp://spreadsheets.about.com/od/c/g/cell_definition.htmhttp://spreadsheets.about.com/od/c/g/cell_definition.htmhttp://spreadsheets.about.com/od/s/g/spreadsheet_def.htmhttp://spreadsheets.about.com/od/d/g/data_definition.htm


30/34

Speeding up data entry Many people use the mouse when moving around their

spreadsheet. Using the mouse, though, is the slow way ofdoing anything on a computer. It's fine if you have only a

small amount of data to enter or if you're not in a hurry. To speed up your data entry use the keyboard. Below is a

list of keys that you can use when you want to quicklyenter your data.

Enter key: enters the data and moves the active cellhighlight down to the next cell in the current column.

Tab key: enters the data and moves the active cellhighlight to the next cell in the current row.

Arrow keys: enters the data and moves the active cellhighlight to the next cell in the direction of the specificarrow key pressed. For example, if the up arrow is

pressed, the active cell highlight moves up to the next cellin the current column. Esc key: cancels the current data entry.
http://spreadsheets.about.com/od/a/g/active_cell.htmhttp://spreadsheets.about.com/od/a/g/active_cell.htm


31/34


32/34

Using AutoComplete to Enter Data

Excels AutoComplete feature is intended to simplify the task ofdata entry.

When entering labels down a column, if you begin typing text

that has previously been entered, Excel will display a black boxcontaining the previous entry in the cell you are entering datainto.

If you want to reenter the same text, press the Enterkey andExcel enters the text for you.

If you are entering a different label, continue typing and theAutoComplete box will go away.
http://spreadsheets.about.com/od/d/g/data_definition.htmhttp://spreadsheets.about.com/od/l/g/label_defined.htmhttp://spreadsheets.about.com/od/l/g/label_defined.htmhttp://spreadsheets.about.com/od/d/g/data_definition.htm


33/34


34/34

Change Part of the Cell Contents Method 1

Click on the cell to make it the active cell. Click on the data in the formula bar. Delete the part to be changed and type in the new data. Press the ENTER key.

Method 2

Double click on the cell. Edit the part of the cell you want to change. Press the ENTER key.

In the example above, the highlighted numbers 5 and 6 inthe formula barcan be removed by hitting the DELETEkey on the keyboard and replaced with different numbers.
http://spreadsheets.about.com/od/a/g/active_cell.htmhttp://spreadsheets.about.com/od/f/g/Formula_bar_def.htmhttp://spreadsheets.about.com/od/f/g/Formula_bar_def.htmhttp://spreadsheets.about.com/od/a/g/active_cell.htm

Documents

Wk 1 Excel Presentation23