Do you wish to train your computer lab students to learn how to use Microsoft Excel 2007? Do you also want those students who have never experimented with using a spreadsheet program to feel really comfortable using Microsoft Excel 2007?
Your wish has been granted. Use this relatively easy 16-page worksheet to walk your students through the process of learning to accomplish both goals. This activity is probably most appropriate for advanced third graders through eighth graders. This activity will also be helpful for adults wanting to learn how to use Microsoft Excel 2007.
You might want to have your students work in pairs. That way, they can help and encourage each other as they work their way through the worksheet examples.
Page 1: Students learn what an Excel worksheet looks like. They also learn to navigate between worksheet one, two, and three. Additionally, they learn how to add a fourth worksheet to the Excel workbook.
Page 2: Students learn how to save the Excel workbook. They will create a new folder in the My Documents folder.
Page 3: Students will learn how to save their new folder giving it a memorable name such as their first and last name plus the words Excel documents.
Page 4: Students will learn to save their Excel workbook in this newly-created folder. In this case, the workbook will be titled ‘Lesson 1’.
Page 5: Students will learn how to identify and click on an individual cell within the Excel worksheet. They will also learn to type their first name in an assigned cell. Then, they will learn how to undo the last move and delete this name.
Page 6: Students will try the exercise of typing ‘one’ in cell ‘A1’, ‘two’ in cell ‘A2’, and three in cell ‘A3’. Students will type ‘1’ in cell ‘B1’, ‘2’ in cell ‘B2’, and ‘3’ in cell ‘B3’. They will learn how to drag down the box from cell ‘B1’ to cell ‘B3’ to automatically populate cells ‘B4’ through ‘B6’ with the numbers ‘4’, ‘5’, and ‘6’.
Page 7: Students will type ‘100’ in cell ‘C1’, ‘125’ in cell ‘C2’, and ‘150’ in cell ‘C3’. Once again, they will drag down the box from cell ‘C1’ to cell ‘C3’ to automatically populate cells ‘C4’ through ‘C6’ with the numbers ‘175’, ‘200’, and ‘225’. Students will also learn to copy cells ‘C1’ to ‘C6’ and paste the contents in cells ‘D1’ to ‘D6’.
Page 8: Students will learn how to copy the contents of cells ‘C1’ through ‘C6’ and automatically paste these contents into cells ‘E1’ to ‘E6’ and also into cells ‘F1’ to ‘F6’. They will also learn two different methods of saving their work.
Page 9 to 11: Students will learn how to use the Format cells button. They will transform Column D into currency (i.e., a dollar amount). They will learn how to transform Column E into decimals. Then, they will learn how to bold in the contents of cell ‘F1’.
Page 12: Students will learn to transform ‘F2” into italics. They will also learn to underline the number in cell ‘F3’.
Page 13: Students will learn to change the color of the font of cell ‘F4’. Students will also learn how to use the paint bucket as they highlight cell ‘F5’.
Page 14: Students will highlight cell ‘F6’ to dark purple and change the font to white so the contents are more readable. They will also learn two ways to delete or undo their last two moves. Please note that the students are guided to frequently save their work so that it is not lost.
Page 15: The students learn how to take the color away from a cell that they have previously filled. They also learn how to use the ‘More colors’ button so they have a wider range of colors to utilize. They are then set free to try changing the color of any cell they choose, changing the font of any cell they choose, and making some of the numbers bold.
Page 16: The last thing your students learn is to change the name of Worksheet 1. They will rename the worksheet to ‘Excel experiments’.
That is the end of Lesson 1. There will be more lessons to come.
To get your free computer lab lesson 1 Excel tutorial – Learning how to use Microsoft Excel 2007, click the link below:
- Lesson 1 Excel Tutorial – Learning how to use Microsoft Excel 2007
See Debbie Dunn’s articles on | K-8 Classroom Activities | School Conflict Resolution | Women’s Health | Storytelling Website
Subscribe to: | K-8 Classroom Activities | School Conflict Resolution | Women’s Health |
Follow on: | Twitter |
For comments or questions, e-mail: email@example.com