Crunching the numbers. Excel does the math and shows you the data in cool charts!

What is Excel? Excel is a spreadsheet program developed by Microsoft. It organizes data in columns and rows, applies formulas, sorts data in a variety of ways, creates charts and graphs, and prints reports defined by the user.

In more simple is a program that lets you do calculations and show the results in several ways. It can seem complicated...and more advanced features are challenging, but the basics are pretty straight forward and give you the power to crunch numbers and make cool looking charts and graphs...that just might dazzle your science teacher!

Excel Vocabulary

Just like other units we have covered, there are a few terms that you need to understand and be able to use effectively. They are:

Workbook Worksheet Column Row
Cell Name Box Formula Bar AutoSum Button
AutoFormat Button Formula = begins formulas Chart

Learning the basics of Excel

With an understanding of basic vocab, we can learn how the program works. We will do that by playing with some basic features together. Follow along as the teacher demonstrates. Copy what you see on the screen.

We will go over the following features of Excel together:

Applying what we learned - Creating a worksheet with charts: Assignment # 1.

Now that we know how to use the basic features of the program, we will create a worksheet together. You all like money, but most people don't control their money, they let emotions control it. We will help Bob take control of his money by creating a simple budget worksheet.

  1. Step 1 - Open a new Excel document and save it in your Computer Skills - Office - Excel folder as:
  2. Step 2 - Rename the worksheet "Bob's Budget"
  3. Step 3 - Follow the teacher instructions for creating the document with proper formatting
  4. Turn in your completed workbook on Coursework - "Excel#1" folder

Striking out on your own - Assignment # 2

Want more Excel Practice?

Contact the teacher for some advanced practice opportunities. There are lots of ways to use this software, and you are encouraged to explore some advanced features when you have finished the assignments for class.

Congratulations! You now should have a basic working knowledge of Excel..a tool used by many companies across the world. This knowledge may well give you an advantage over other job applicants.