microsoft excel tutorial. spreadsheet basics! the microsoft excel window when you open microsoft...

Microsoft Excel Microsoft Excel TutorialTutorial

Spreadsheet Spreadsheet Basics!Basics!

The Microsoft Excel WindowThe Microsoft Excel Window When you open Microsoft Excel, this screen will When you open Microsoft Excel, this screen will

appear. Then, if necessary, click on the in the appear. Then, if necessary, click on the in the upper right corner of the task pane to close the upper right corner of the task pane to close the task pane. task pane.

This is what you want This is what you want Excel to look like!Excel to look like!

Identify Spreadsheet Parts!Identify Spreadsheet Parts!

Software programs withSoftware programs with spreadsheetsspreadsheets help help you manage and store numbers and text. you manage and store numbers and text. Rows and columns are used to organize Rows and columns are used to organize information.information.

Each column is identified by a letter such as A, Each column is identified by a letter such as A, B or C. Each row is identified by a number B or C. Each row is identified by a number such as 1, 2 or 3. such as 1, 2 or 3.

When a column and a row form a rectangle, it When a column and a row form a rectangle, it is called ais called a cellcell..

Identifying Spreadsheet Parts!Identifying Spreadsheet Parts!

Column CRow 2

Cell A2 stands for column A,

row 2.

Identifying Spreadsheet Parts!Identifying Spreadsheet Parts! Whatever you Whatever you

type in a cell, type in a cell, appears in theappears in the formula barformula bar..

To move from cell To move from cell to cell (across to cell (across from left to right), from left to right), you can use theyou can use the TAB TAB button! button!

To move up and To move up and down, just use down, just use your arrow keys!your arrow keys!

Edit and Format Data!Edit and Format Data!

You can change You can change the way the way information is information is displayed in a cell displayed in a cell by formatting the by formatting the data (information.) data (information.) Information can be Information can be quickly and easily quickly and easily edited.edited.

You can center, You can center, boldbold, , italicizeitalicize,, changechange fontfont colorcolor, , or or change font change font sizesize in Excel! in Excel! It’s your choice!It’s your choice!

QUICK QUIZ!QUICK QUIZ!

What’s the difference What’s the difference between a row and a between a row and a column?column?

How can you move to How can you move to each cell?each cell?


A row is a line of cells that run from left to right A row is a line of cells that run from left to right on the spreadsheet. A column is a line of cells on the spreadsheet. A column is a line of cells that run up and down on the spreadsheet.that run up and down on the spreadsheet.

To move from cell to cell (across from left to To move from cell to cell (across from left to right), you can use the TAB button! To move up right), you can use the TAB button! To move up and down, just use your arrow keys!and down, just use your arrow keys!

MINI TASKMINI TASK

When you have a When you have a MINI TASKMINI TASK, you need , you need to minimize the PowerPoint window!!to minimize the PowerPoint window!!

You need to view the upcoming slide(s)You need to view the upcoming slide(s) AND AND toggle between an open Excel toggle between an open Excel programprogram AT THE SAME TIME AT THE SAME TIME so you so you can complete your can complete your MINI TASKMINI TASK!!

MINI TASKMINI TASK1.1. Open a new Open a new

spreadsheet in spreadsheet in Microsoft Excel.Microsoft Excel.

2.2. Format the data as Format the data as indicated so your indicated so your spreadsheet will look spreadsheet will look like the one like the one illustrated.illustrated.

Select the column headings. Align centerand format in bold.Change the font size to 12 point.

Select the names of the countries. Format initalic.

MINI TASKMINI TASK3. 3. SelectSelect cellcell B5B5, , and key the new dataand key the new data

14,87514,875..

4. 4. Edit the additional spreadsheet data as Edit the additional spreadsheet data as follows:follows:

a. Changea. Change D4D4 toto 33,01833,018..

b. Changeb. Change D7D7 toto 2,1962,196..

c. Changec. Change C3C3 toto 2,7422,742..

a. Changea. Change E6E6 toto 802,451802,451..

MINI TASKMINI TASK

5. 5. Save the changes as Excel Mini Task 1 Save the changes as Excel Mini Task 1 to My Documents.to My Documents.

6. 6. When you’ve done that, come back to When you’ve done that, come back to the PowerPoint!!the PowerPoint!!

Create and Edit a Create and Edit a SpreadsheetSpreadsheet

Change Column Width!Change Column Width!

When you create a new spreadsheet to When you create a new spreadsheet to enter data, you can easily adjust column enter data, you can easily adjust column widths to display the data.widths to display the data.

Click and drag the column boundary to

change the columnwidth so the cell

with the most datafits.

Insert and Delete Columns and Insert and Delete Columns and RowsRows

You can delete a row or a column to remove data you You can delete a row or a column to remove data you no longer want in your spreadsheet. You can also add no longer want in your spreadsheet. You can also add a row or column to insert additional data.a row or column to insert additional data.

To Delete a Row or ColumnTo Delete a Row or Column:: Highlight the row(s) or column(s) that you want to Highlight the row(s) or column(s) that you want to

delete.delete. Right click on your mouse and click delete. A box Right click on your mouse and click delete. A box

will ask you if you want to shift the cells or delete will ask you if you want to shift the cells or delete the entire row or column. Choose Entire Row or the entire row or column. Choose Entire Row or Column and click Delete.Column and click Delete.

Right click on your

mouse and click delete.

Choose Entire

Columnfrom the

DeleteBox and

click Delete.


Inserting ColumnsInserting Columns There will be times when you will need to There will be times when you will need to

insert a column or columns into your insert a column or columns into your spreadsheet. To insert a column:spreadsheet. To insert a column:Click on A to select column A. Click on A to select column A. Choose Insert > Columns from the Choose Insert > Columns from the

menu. A column is insertedmenu. A column is inserted to the rightto the right of of column A. column A.


Inserting RowsInserting Rows You can also insert rows into your You can also insert rows into your

spreadsheet:spreadsheet:Click on 2 to select row 2. Click on 2 to select row 2. Choose Insert > Rows from the Choose Insert > Rows from the

menu. A row is insertedmenu. A row is inserted aboveabove row 2.row 2.

Sort a List of Data!Sort a List of Data! You can sort your data in a spreadsheet either You can sort your data in a spreadsheet either

alphabetically or numerically. This is helpful when alphabetically or numerically. This is helpful when you want to organize your information!you want to organize your information!

To Sort DataTo Sort Data:: Choose the data that you want to sort and Choose the data that you want to sort and

highlight the columns/rows.highlight the columns/rows. Click Data from the Menu Bar and Click Sort Click Data from the Menu Bar and Click Sort

from the Data Menu.from the Data Menu. The Sort Box will ask you how you want to sort The Sort Box will ask you how you want to sort

your information. For example, do you want to your information. For example, do you want to sort Column A in ascending order or sort Column A in ascending order or descending order?descending order?


When you insert a column, does When you insert a column, does it appear to the right or left of it appear to the right or left of the original column?the original column?

Where can you find the Sort Where can you find the Sort Tool?Tool?


A newly inserted column is inserted A newly inserted column is inserted to the rightto the right of the original column. of the original column.

The Sort Tool is found in the Data The Sort Tool is found in the Data Menu Bar.Menu Bar.

MINI TASKMINI TASK

1.1. Open a new spreadsheet in Microsoft Excel.Open a new spreadsheet in Microsoft Excel.

2.2. Key and format the information shown below.Key and format the information shown below.

Align center

the headings,

format bold,and

changethe fontsize to12 pt.

Click and drag the column boundariesto change the column width so the cell

with the most data fits.

MINI TASKMINI TASK

3. Edit the spreadsheet as follows:3. Edit the spreadsheet as follows:

a. a. Insert one row above row 5 containing Insert one row above row 5 containing information about the country Germany.information about the country Germany.

b. b. Delete the row containing information about the Delete the row containing information about the country Czech Republic.country Czech Republic.

c. c. Insert a column before column C, “Population.”Insert a column before column C, “Population.”

MINI TASKMINI TASK

4. Add the data as indicated.4. Add the data as indicated.

Key the information about South Korea and Vietnam.

Key the title “Capital.” Format bold. Change the font size to

12 pt. Align center. Key theremaining data as shown.

MINI TASKMINI TASK

5. Edit the spreadsheet as follows:5. Edit the spreadsheet as follows:a. Insert 2 rows above “Country.” Key the title a. Insert 2 rows above “Country.” Key the title “COUNTRY INFORMATION” in cell A1. Format “COUNTRY INFORMATION” in cell A1. Format bold. Change the font size to 12 pt.bold. Change the font size to 12 pt.

b. Delete the column named “Area (sq. mi.).”b. Delete the column named “Area (sq. mi.).”

6. Use the Sort feature to alphabetize the “Country” 6. Use the Sort feature to alphabetize the “Country” column. (Remember! You must highlight cells A5 column. (Remember! You must highlight cells A5 to C10 to use the Sort Feature correctly!)to C10 to use the Sort Feature correctly!)

7. Save it as Excel Mini Task 2 to My Documents.7. Save it as Excel Mini Task 2 to My Documents.