Microsoft Office Excel 2007

SAI INFOTECH COMPUTER INSTITUTE

In Front of Citykart Vijay Chowk Gorakhpur
Mob:- 9935268617,9819380856
 MS EXCEL 2007
Spread Sheet:-
A large sheet which is consisting on number of row and number of
column is known as spread sheet.

Electronic Spread Sheet:-

A spread sheet which is consists on what if analysis is known as
electronic spread sheet.

What if analysis:-
A single change applied in to whole spread sheet is known as what if
analysis.

Electronic Spread sheet software:-

M.S Excel, Visi calc, Lotus 123 etc.

M.S Excel 2007:-

It is the best spreadsheet software there are 65536 Row and 256
Column are present in Excel 2003 in excel 2007 there are 1048576 Row
and 16384 Column make a work sheet number of worksheet make a
workbook.

The Ribbon in Excel:-

Home:-
This contain commonly used excel formatting table.

Insert:-
As you might guess this one handle anything you might want to insert
in your spread sheet such as Chart, Pivot Table, Picture, Clipart, Word
Art etc.

Page Layout:-
This is where you will change the margin, page size and orientation
differ your print area set the background etc.

Formula:-
It organize all of excel formula into categories such as Financial, Logical,
Mathematical etc.

Data:-
What you need to do with data you will be find here. It is used for
import data from a wide variety of sources

Review:-
To check spelling and grammar use the thesaurus, Track Changes etc.

View:-
This one can change the view in any way including displayed a ruler,
grid lines, zooming in and out etc.
How to start M.S Excel:-
Step 1:- Press Win + R Button

Step 2:- Type EXCEL

Step 3:- Press Enter Button

OR

Step 1:- Click on Start Button

Step 2:- Select All Program Option

Step 3:- Select Microsoft Office

Step 4:-Select Microsoft Office Excel 2007

Insert tab
Table:- It is use for insert Combination of Row and Column in
spreadsheet.

Picture:- It is use for insert any type of picture in spreadsheet.

Shape:- For insert any type of shape in spreadsheet Like Rectangular,

Circle, Triangle etc.

Word Art:- For insert attractive text in spreadsheet.

Clipart:- For insert Drawing, Pity Picture etc.

Chart:- Graphical representation of data is known as chart.

Row:- For insert a separate Row at selected place.

Column:- For inset a separate Column at selected place.

Cell:- For insert a separate cell at selected place.

Function:- Function are predefine formula present in M.S. Excel there

are following types of function.

Mathematical Function
1. ABS Function:- Return the absolute value without any sign.
2. Ceiling Function:- Return the number round up away from zero to
the nearest multiple sign.
3. Even Function:- Return the number round up to the nearest even
integer.
4. Odd Function:- Return number round up to the nearest odd
integer.
5. Fact Function:- return the factorial of a number.
6. Fact Double:- Return the double factorial of a number.
7. Floor Function:- Round number down to word zero to the nearest
multiple of sign.
8. GCD Function:- Return the greatest common divisor of two or
more integers.
9. INT Function:- Round a number down to the nearest integer.
10. LCM Function:- Return the least common multiple of given
integer.
11. MMULT Function:- Return the matrix product of two arrays.
12. MOD Function:- Return the reminder after number is
divided by divisor.
13. Power Function:- Return the number that raised to a power.
14. Product Function:- Multiplies all the number given as
arguments and return the product.
15. Round Function:- Round an evenly distributed random real
number greater than or equal to zero and less than one.
16. Round Function:- Round a number to a specific number of
digit.
17. Round up Function:- Return the number round up of even
or odd integer.
18. Round down Function:- Return the number round down to
the even or odd integer.
19. SQRT Function:- Return a positive square root.
20. Sum Function:- Add all the number in given range of cell.
21. Sum if Function:- Add the specify cell by given criteria.
22. Sum Product Function:- Multiplies corresponding
component in the given arrays and return sum of those product.
23. Sum SQ Function:- Return the some of the arguments.

STATICAL FUNCTION
1. Average Function:- Return the average of the arguments.
2. Count Function:- Count the number of cells that contain number
or alphabet. Cannot count empty cell.
3. For cost function:-You can use this function to predict future sale
inventory requirement or consumer tender.
4. Frequency Function:- Calculate how often value occur within a
range of value.
5. Large Function:- Return the largest number in a dataset.
6. Max function:- Return the Maximum Value in a dataset.
7. Small Function:- Return the smallest value in a dataset.
8. Min Function:- Return the minimum number in a set of value.
 FINANCIAL FUNCTION
1. PMT Function:- Calculate the payment for a loan with an interest
rate based on constant payment.
2. SLN Function:- Return the Strait Line Depreciation of an asset for
the one period.
3. DB Function:- Return the depreciation of an asset for a specified
period using balance method.
4. PV Function:- return the present value of an investment.
5. Rate Function:- Return the interest rate per period for an annuity.
6. NPER Function:- Return the number of period for a loan and
investment based on constant interest rate.
7. FV Function:- Return the future value of an investment.
8. PPMT Function:- Return the payment on the principle for a given
period.
9. Compound Interest:- Return the internal rate for a schedule of
cash flow that is not necessary periodic.

DATE & TIME FUNCTION

1. Today Function:- Return the serial number of current date.
2. Now Function:- Return the serial number of current date and
time.
3. Date Function:- Return the sequential serial number that
represent a particular date.
4. Day Function:- Return the day of a date represent by a serial
number.
5. Month Function:- return the month of a date represent by a serial
number.
6. Year Function:- Return the year corresponding to a date.
7. Time Function:-Return the decimal number for a particular time.
8. Hour Function:- Return the hour of a time value represent by a
serial number.
9. Minute Function:- Return the minute of a time value.
10. Second Function:- Return the second of a time value
11. Week num Function:- Return a number that indicate where
the week falls numerically within a year.
12. Weekday Function:-Return the day of a week corresponding
to a date.

LOGICAL FUNCTION
1. If Function:- Return one value if a condition you specify.
2. And Function:-When all value true then result will be true.
3. Or Function:- If any one condition are true then result will be true.
4. Not Function:- If all condition are false then result will be false.

TEXT FUNCTION
1. LEN Function:- Return the number of character in a text string.
2. Left Function:- Return the first character of characters in a text
string.
3. Right Function:- Return the last character of characters in a text
string.
4. Mid Function:- Return the specified number of character in a text
string.
5. Upper Function:- Convert the text in to UPPER CASE (Capital
Letter).
6. Lower Function:- Convert the text into lower case (Small Letter).
7. Proper Function:- Capital the first letter in a text string.
 8. Rept Function:- Repeat the text in given number of time.
9. T Function:- Return the text refers buy value.
10. Char Function:- Return the character specified by a number.
11. Code Function:- Return a number code for the first
character in a text string.
12. Constant Function:- Join two or more text string into one
text string.

VLOOK UP & REFERENCE

1. VLOOKUP Function:- Search for a value in the first column of a

table array and return a value in the same row from another
column in the table array.
2. Goal Seek Function:- If you know the result that you want from a
formula but not in the input value the formula need to get that
result that time you can use the goal seek function.
SHORT & FILTER
Short:- Shorting means to arrange the data as you want such as A to Z
or Z to A.

Filter:- Filter means filter the data by your criteria. Filter put buttons in
cell for filter data sheet.