Microsoft excel far windows, uses the 1900 date system in which serial numbers correspond to the       numbers correspond to the dates January 1, 1900 through December 31, 9999.

*   To insert the current time shortcutis ctri+:(colon)

*   To insert the current date shortcut is ctrl+;(semicolon)

   DATE (YEAR, MANTH, DAY):-

       Returns the serial number of a particular date. Year ia a number from 1900 to 9999. Month is a        number representing the month of the year. If month is greater then 12, then month adds that               number of month to the first month in the year specified.

          E.g = Date (2010,14,2) returns the serial number representing February 2, 2011.

*   Day is a number representing the day is a greaterthan the number of days in the month specified,       then days adds that number of days to the first day in the month. For example, Date(2011,1,35)        returns Febuary 4,2011.

  =Date(99,1,1)equals 36161,the serial number corresponding to January 1, 1999.

   NOW() :- 

Returns the serial number of the current date and time value returned by Now() function will change each time when worksheet is calculated.

DATE VALUE() :-

This function converts a date in text from to a date serial number.

                    Sy = Date value("date")

DAY() :- 

This function return the day of a date.

                        =Day("date") 

MONTH() :-

This function return the month of a date.

                               =Month("date")

  YEAR() :-

This function return the year of a date.

                          =Year("date")

WEEKDAY() :- 

This function returns an integer from 1 faor sunday to 7 fao saturday.

                                  =Weekday("date")

DAYS360() :- 

This function calculates the number of days beteen two dates.

                                =Days360("date1","date2")

*       SHOOTCUT KEYS 

          Time =ctrl+shift+:

           Date =ctrl+;

                           Ms Excel 

. Start ms-excel 

. Identify different parts of worksheet . 

. Create save open and close a workbook . 

. Work with formulas and functions .

. Exit from ms-Excel . 

. Click on start button on the taskbar . select programs > ms-office > ms-excel . 

. From windows explorer double click on any excel icon will be present in 

microsoft office folder will start and the will be opened . 

. Select start > Run Type excel and click on ok excel . EXE is the executable file name of 

ms-excel present in microsoft office folder . 

 Double click on the excel shortcut icon on windows desktop . (If any ) . 

                    FINISH

                   REVIEW 

Proofing 

                                        COMMENT

                                  TRACKING

(Ctrl + Sift + E)

                    CHANGES

                              COMPARE

                              VIEW

Document view

                            SHOW / HIDE

                             ZOOM

                   MACROS

           (Alt + f8) 

                             PARAGRAPH 

                           REFERENCES 

 Table Of Contents

                       ( Alt + ctrl + f )

                      ( Alt + ctrl + D )

              CITATIONS AND BIBLIOGRAPHY

Insert citations :-
Cite a book journ al article or other periodical as the source for a risce of information in the document . Choose from the list of sources you have created or enter information for a new source . Word formats the citation according to the style you have selected .

Manage Source :-
View the list of all the sources cited in the document .

Bibliography Style :-
Choose the style of citation to use in the document . Popular choices include APA stlye chicago stlye
and MLA style .

Bibliography :-
Add a bibliography which list all the source cited in the document .

                        

              CAPTIONS

Insert Caption :-
Add a caption to a picture or other image . A caption is a line of text that appears below on object to describe it .

Insert Table Of Figures :-
Insert a table of figure into the document . A table of figures includes a equation in the document .

Update Tables :-
Update the table of figures to include all of the entries in the document .

Cross Reference :-
Refer to items such as heading : figures and table by inserting a cross - reference such as "see table 6 below "or "turn to page 8" . Cross references are automatically update if the content is moved to another location by default , Cross - reference are inserted as hyperlink .

                             INDEX

Mark Entry :-
Include the selected text in the index of the document .
                       ( Alt + shift + x )

Insert Index :-
Insert an Index into the document . An index is a list of keywords found in the document along with the
page number the word upper on .

Update Index :-
Update the index so that all the entries refer to the correct page number .

                             

                            TABLE OF AUTHORITES

Mark citation :-
Add the selected text as an entry in the table of authorities .
                          ( Alt + shift + I )

Insert Table Of Authorities :-
Insert a table of authorities into the document . A table of authorities lists the cases , statutes and other authorities cited in the document .

Update Table Of Authorities :-
Update the table of authorities to include all of the citations in the document .

                              MAILINGS

Create Envelopes :-
Create and [print envelopes .

Levels :-
Create and print labels you can select from a number of popular paper labels
styles and shapes .

                          

                         START MAIL MERGE

Start Mail Merge :-
Start mail merge to create a from letter which you intedent to print or e-mail multiple times , sending each copy to a different recipient . You can insert field such as home or address which word will replace automatically with information from a database or contact list for each copy of letter .

Select Recipient :-
Choose the list of people you intend to send the letter to . You can type your own list use your outlook contacts or connect to a database .

Edit Recipient List :-
Make changes to the list of recipient and decide which of them should receive your letter . You can also sort , filter , find and remove duplicates , or validate address from the list .

                       

                  WRITE AND INSERT FIELDS

Highlight Marge Fields :-
Highlight the fields you have insert in to the document . This makes it easy to use which part of our from letter will b e replaced by information from the recipient list you have chosen .

Address Block :-
Add on address to your letter you specify the formatting and location and word will replace it with actual address from your recipient list when you finish the mail merge .

Greeting Line :-
Add a greeting line such as "Dear" << first name >> to your document .

Insert Merge Fields :-
Add any fields from your recipient list to the document such as "Last name"  "Home phone other fields . When you finish the mail merge word will replace these fields with the actual information from the recipient list .

Rule :-
Specify rules to add decision making ability to the mail merge .

Match Fields :-
Match fields allows you to tell word the meaning of different fields in your recipient list for example . You can indicate that your custom field "home" is eqivalent to normal built in field "home phone" .

Update Labels :-
If you are creating labels , update all the label in the document to use information from the recipient list for a mail merge to a printed letter or e-mail this command is not necessary .

                          PREVIEW RESULTS

Preview Results :-
Replaced the merge fields in your document with actual data from your recipient list so you can see what it looks like .

Find Recipient :-
Find and preview a specific record in the recipient list by searching for text .

Auto Check For Errors :-
Specify how to handle errors that occur when completing the mail merge . You
also have the option of simulating the mail merge to see if any errors would
occur .

The occur when completing tha mail merge. you also have the option of simulatirythe mailmerge to sei if any Errors would occur .