Excel Introduction

How to launch MS Excel?

Now you are going to learn what spreadsheets are and what they can do. In this tutorial you will learn about cell coordinates, rows and columns, and how to enter data into a cell

What a Spreadsheet is?

A spreadsheet is a piece of software for handling and manipulating numbers. You can write numbers down on a piece of paper and add them up. The best part about a spreadsheet is the program will add the numbers up for you.
We can do simple arithmetic, financial calculations, statistical information, complex trigonometry etc. We can also create stunning graphs
The software will save a lot of time and effort

Why we need Spreadsheet?

  • Automatic calculations
  • Save time
  • Share Information with Customers and Partners
  • Manage Information More Effectively
  • Calculate financial data

If you want to keep track of things like stock and profit margins, then spreadsheets are very useful indeed. In fact, spreadsheets are useful in a wide range of situations, both business and non-business.

How to open Microsoft Excel 2007

Click your left mouse button once on the start button in the bottom left of your screen. The start button will look like following buttons


On the Start menu that appears, click your left mouse button on the All Programs item. On the All programs menu, look for Microsoft Office. You will see like following image:

micosoft-Excel-inroduction
micosoft-Excel-inroduction

Click Launch your Excel software. When the programme starts, you’ll see something like this in Excel 2007:

micosoft-Excel-inroduction
Microsoft-Excel-introduction

On the top of the spreadsheet you’ll notice that there are some letters, A to P. These letters are the columns. If you click on any of the letters with your left mouse button, you’ll highlight an entire column. In the picture below the letter E has been clicked on, thereby highlighting this entire column.

micosoft-Excel-inroduction
micosoft-Excel-inroduction

You can’t change these letters.
On the left side of spreadsheet are numbers. The numbers are rows. Click on any of the numbers to highlight an entire row. In the image below, the number 5 has been clicked on, thereby highlighting the entire Row.

micosoft-Excel-inroduction
micosoft-Excel-inroduction

Individual cell name

In a spreadsheet, you combine a Column letter with a Row number. This gives you an individual Cell in the spreadsheet. A Column plus row 5 will give you an individual cell of B5. Likewise the J column with plus row 10 will give you an individual cell of J10.

micosoft-Excel-inroduction
micosoft-Excel-inroduction
micosoft-Excel-inroduction
micosoft-Excel-inroduction

Notice two things: first that your mouse pointers turns into a white cross when it moves around the spreadsheet; second that the coordinates of the cell are displayed at the top left.
When we clicked inside cell A5 with the left mouse button we highlighted that cell. When we highlight a cell, it has the thicker black border around it. This means that it is the Active cell.When you enter text or numbers into a cell, you first have to make it the Active cell. In other words, you have to click on it to highlight the cell.
Get some practice by clicking on individual cells in the spreadsheet. Notice how the cell coordinates change whenever you click on a new cell
Make sure how grid coordinates work in spreadsheet.

Enter Data in Cells

To begin this lesson we will enter some text and numbers into some cells. When we are finished, our spreadsheet will look like the following image

micosoft-Excel-inroduction
micosoft-Excel-inroduction

Do the following steps to enter numbers and text into a cell:

  • Click on cell A1 with your left hand mouse button
  • Type the text “Numbers” (without the quotation marks)
  • Press the Return key on your keyboard
  • The darker border will jump down one cell to A2
  • Type a 3 and then press the Return Key on your keyboard
  • The darker border will jump down one cell to A3
  • Enter a 6 and a 9 in exactly the same way

When you’re finished, your spreadsheet will look like the one in the image above.

Edit data in cell

When we wanted to enter some data in a cell, we simply clicked on an individual cell and started typing.
If there is already something in a cell and you tried to type something else, the old contents would be entirely erased

micosoft-Excel-inroduction
micosoft-Excel-inroduction
micosoft-Excel-inroduction
micosoft-Excel-inroduction

Ribbon

The first thing to notice is the Ribbon running right across the top

micosoft-Excel-inroduction
micosoft-Excel-inroduction