Columns, rows, and cells

Columns, rows, and cells

Worksheets are divided into “columns” “rows” and “cells”.

That’s the grid you see when you open up a workbook.

Columns, rows, and cells

1. “Columns” go from top to bottom on the worksheet, vertically. Each “column” has an alphabetical heading at the top.
2. “Rows” go across the worksheet, horizontally. Each row also has a heading. “Row “headings are numbers, from 1 through 1,048,576.

The alphabetical headings on the columns and the numerical headings on the rows tell you where you are in a “worksheet” when you click a “cell”.

The headings combine to form the cell address. For example, the cell at the intersection of column A and row 3 is called “cell” A3. This is also called the cell reference.

Workbooks and worksheets

Workbooks and worksheets

When you start Excel, you open a file that’s called a "workbook".

Each new workbook comes with three "worksheets" into which you enter data.

Shown here is a blank worksheet in a new workbook

1. The first "workbook" you’ll open is called Book1. This title appears in the bar at the top of the window until you save the workbook with your own title.

2. Sheet tabs appear at the bottom of the window. It’s a good plan to rename the "sheet" tabs to make the information on each sheet easier to identify. 

Calculate Age MSExcel

 Calculate Age with Excel

calculate age on MSExcel for a many applications by combining an undocumented function and the date format for cells. Microsoft Excel inside stores dates as serial numbers, which is the number of days a date is from Jan. 1, 1900. Please remember  as you set up your age calculation formula in MsExcel.

1-Open New Workbook Excel save with the name of calculate Age.

2- calculation by creating labels in the row of cells from A1 over to C1.

·                   

          Cell A1 should include a label pertaining to the opening date or start date. This may be the date an invoice was created or the birthday of a person.

     Cell B1 should include the label, "Today."

            Cell C1 should be labeled "Age."

3- Enter the variables for your age calculation in cells A2 and B2.

The invoice or birth date should be mention in cell A2.

          In cell B2, create the "Now" function by typing "=Now()" without the quotation marks. Press the "Enter" key to complete the entry.

·                                 If you like  more than one  person for which you want to know calculating age in days or years, you may b  mention  those variables in the rows down.

4-use the  "DATEDIF" function in cell .

Enter the Formula in the cell.

Type "=DATEDIF(" in the Formula Bar, without the quotation marks, and then click cell A2. =DATEDIF(birthday date cell,today date cell,"y")  example for year =DATEDIF(A2,B2,"y") and for month  =DATEDIF(A2,B2,"M") and for days =DATEDIF(A2,B2,"D")

      Click the cell B2 and press the comma key again.

          Enter the definition of your date interval, this time with quotation marks, and then press the "close parenthesis" key, ")".

5-Copy the formula in cell C2 and paste it into the cells in the C column for any other entries you have made.

         The formula will retain "relative references" to the cells in the A and B columns and will preserve the date interval definition from the original formula.

Goals

Goals

•Create a new workbook.

•Enter text and numbers.

•Edit text and numbers.

•Insert and delete columns and rows.

Where to begin

Where to begin

You’ve been asked to enter data in 

Excel 2007", but you’ve never worked with Excel. Where You’ve been asked to enter data in "Excel 2007", but you’ve never worked with Excel. Where do you begin?

Or perhaps you have worked in "Excel" but still wonder how to do some of the basics like entering and editing text and numbers, or adding and deleting columns and rows.

Here you’ll learn the skills you need to work in "Excel", quickly and with little fuss.do you begin?

Home

 3 basic components in the Ribbon

3 Basic Components

Tabs There are 7 of them crossways the top. Each represents core tasks you do in office Excel .

Groups In Each tab like a  groups  show related items buttons.

Commands A command is a button, over the mouse you can see detail about button action.

Home

Home Tab

How do we get started? In start at the beginning, with the first tab.

The principal orders in Excel are gathered on the first tab, the Home tab. The commands on this tab are those that Microsoft has identified as the most commonly used when people do basic tasks with worksheets.

Clipboard 
The Paste, Cut, and Copy commands are arranged first on the Home tab, in the  group.

Font
Font formatting commands are next, in the group.

Alignment

The  Commands to center text or align text to the left or right are in the group,

Cells 

The commands to insert and delete cells, rows, columns, and worksheets are in the group.

In all the Groups pull together all the commands to need for a particular  different tasks, and throughout the task they stay behind on display and readily accessible, instead of being hidden in menus.

 If  we want text displayed on various lines in a cell, you do not  have to click a command on a menu, click a tab in a dialog box, and then click an option in the dialog box. We just click on the Wrap Text  button in the Alignment group

Ribbon 2007

What's New and change after office2003

The "Ribbon" is a new control center,

It’s a big change and  most obvious at the peak of the window.

But it's excellent change. What you need is now more clearly noticeable and more readily available. Instead of having 30 or so underplayed toolbars, and commands buried on menus, you have one control center — the "Ribbon", which brings together the basics and makes them very visual aid.

When you try the new drawing, you'll discover that the commands you already know how to use are grouped together in ways that make sense to you.

Learn more about the new design, and prepare to get to work with your excite new version of Excel.

Microsoft Excel 2007

How to use Microsoft Excel 2007

Getting Started

“Microsoft Office Excel” is a powerful tool used to create and format spreadsheets. Spreadsheets allow information to be organized in rows and tables and analyzed with usual mathematics. Spreadsheets are commonly be used to perform many diffirent types of calculation.