# Learn ms excel-2007 (theory)

## MS EXCEL - 2007(THEORY)

Microsoft Excel is a spreadsheet application program offered in the Microsoft office software package. This program allows you to perform calculations and use graphics tools, pivot tables and a macro programming language called VBA. In addition, Excel can also be used to create charts and graphs.

COLUMN
The vertical lines in a sheet are known as a column. There is a total column in a sheet is 16384. The default width of a column is 8.43 point.

ROW

The horizontal lines in a sheet are known as a row. There are total 148576 rows in a column. The height of a row by default is 15 point.

WORKSHEET

The sheet in a workbook from in combination with rows and columns to perform differently. Arithmetical and logical calculations are known as worksheet as it is electronic while opening excel 3 worksheet open by default.

WORKBOOK

While opening MS excel the application screen that appears with some tools and 3 sheets by default to perform different calculations.

CELL
Intersection of row and column is called the cell.
Cell = Column*Row

GRID LINES

The line which separate rows and columns are called grid lines. It is a nonprintable area by default.

GOAL SEEK

Goal seek is an option through which we can obtain any target value by changing other data.

SUBTOTAL

Subtotal is a system through which we can consolidate any subject wise value depending on the condition.

AUTO FILL

Autofill is an option which helps the user to automatically fill the above data underneath.

FILTER

A Filter is an option through which we can sort out the value depending on criteria given by the user.

RIBBON

The ribbon, a panel that houses the command buttons and icons, organizes commands as a set of tabs, each grouping relevant commands. Each application has a different set of tabs which expose the functionality that application offers.

AUTOSUM

The autosum button allows you to quickly insert the sum function.It is located in two places on the ribbon. On the right end of the "HOME" tab in the editing section, and on the far left of the "FORMULA" tab. Select the cell where you want to put the total and then click on the autosum button. Excel will insert the sum function and take a guess as to what cell range you'd like to sum by listing the first and last cell in the sum, separated by a colon.Check to make sure the cell range is correct, then press enter to accept the function.

AUTO CALCULATE

Excel will automatically perform the calculation on a set of cells that you select and display the results on the status bar in the bottom right of your window. The default calculation is the sum function, but you can change the calculation by right-clicking or control+clicking(MAC) on the auto calculate the result.

PIVOT TABLE

A pivot table is a great reporting tool that sorts and sums independently of the original data layout in the spreadsheet. It is an interactive representation of a data table. One can rearrange the data and choose what to display and what to hide.The best way to find out what a pivot table can do is to create one.

CHARTS

A full discussion of excel"s many charting options is beyond the scope of this handout. However, it is fairly straightforward to create a simple chart using the chart wizard. Just highlight the data you wish to base your chart on and click on the Insert tab and you will see the available charts there. When you click on a type of chart, you will be prompted to select a subtype of the chart. Once you have done so, the chart will appear on your spreadsheet. Three additional tabs will also appear on your ribbon, through which you can alter your chart by adding titles, changing data points and many other options.

NAME MANAGER

You can use name manager to name a group of cells, and therefore only type one name when you want to perform a calculation with that group. This can be useful when you are performing many different calculations on the same set of numbers, especially when you want to perform these calculations across multiple sheets. To do this, select the cells you would like to name and name them in the "name box" next to the formula bar. You can then perform any function on these cells by just typing the name you gave the cells instead of referencing the cell numbers. You can edit the names you gave the cells and change which cells they refer to by clicking on "name manager" on the "formula" tab.

FUNCTIONS

Excel has created hundreds of functions that prevent you from having to write out complex or repetitive formula yourself. Functions can be inserted by clicking on the function symbol to the left of the formula bar. Functions can also be inserted by clicking on the "insert function" button on the "formula" tab or jumping to any of the subcategories of functions on that tab. Yet another way to insert a function is to type the equals sign into a cell and begin to type the name of formula. A drop-down menu will appear, from which you can select the formula.

FORMULAS

Select the cell that the formula result is going to be displayed in. The formula can be constructed in the formula bar or typed directly into the cell in which you want the formula to begin. You must always put the = sign before a formula, as this is how excel recognizes what you are entering into a formula. Autofill helps you fill in formula quickly once you have constructed one in a cell. In order to autofill, select the cell with the formula.

CELL REFERENCES

There are two different types of cell references
relative cell references
Cell references that change when the formula is autofilled into different cells.

absolute cell references
If you don't want a certain part of your cell reference to change when you copy the formula to a new cell, you need to put a \$ in front of the row and /or column part of the reference.