????? ??????? ?????? ?? ???? ??? Excel ?????? ?????? ????? ?? Word

• ??????? ??????? ????? ??? ???? ??????? ?? ????? ?? ???? ????????? ???????. ?? ????? ??? ????? ??????? ????? ? ????????? ???????? ?? "???? ?????" ?????? ???? (??? ????? ????????? ? ??????) ???? ????? ?? ????? ????? ???? ??? ???.
• ????? ????????? ????? ??????-??? ???? ??????? Microsoft ??? ????? ?????? access 2002 ?? ???? Excel-???? ????? ??? ???????? ???????? ???? ????????? ???????. ????? ???????? ??? ???? ????? ??????? ????????? ?????? ??????.
• ????????? ??????? ?? ????? ?????? ??? ?????????. ????? ???? ?? ???? ???? ?? ????? ????? ????? ?? ???? ????????? ???????? ???? ????? ????? ??????? ??? ????????? ???????.

?????? 1: ????? ??? ?????? Excel

• ??? ?? ????? ???? ????? ??? ????? ?????? ??? ????. ??? ???? ??????? ???????? ??????? ????? ????? ????? ?????? "????? ??????"? Address1? ?????? 2.
• ??? ?? ???? ?? ??? ??? ????.
• ??? ????? ?? ?? ??? ??????? ??? ???? ????. ?? ????? ?????????? ??? ???? ??????? ?? ?? ?? ????? ??????? ??? ????? ????.
• ??? ?? ????? ?????? ???? ?????.

1. ????? ??? ?????? Excel ?????? ?? ???????? ???????? ?????? ???? ???? ????????? ?????? ???????? ??? ?? ???? ?? ????? ?????? ??? ????????:
   
   

   Last Name	First Name	Title	Address	City	Postal Code	Country
   Davolio	Nancy	Sales Representative	1234 Main St. Apt. 2A	Seattle	14222	USA
   Fuller	Andrew	Vice President, Sales	1235 Main St.	Tacoma	14222	USA
   Leverling	Janet	Sales Representative	1235 Elm St.	Kirkland	14222	USA
   Peacock	Margaret	Sales Representative	1236 Main St.	Redmond	14222	USA
   Buchanan	Steven	Sales Manager	1237 Main St	London	SW2 8MR	UK
   Suyama	Michael	Sales Representative	1238 Elm St.	London	EC3 7HR	UK
   King	Robert	Sales Representative	1239 Main St.	London	RK2 9NP	UK
   Callahan	Laura	Inside Sales Coordinator	1230 Elm St.	Seattle	14222	USA
   Dodsworth	Anne	Sales Representative	1231 Elm St.	London	WG2 7LT	UK

   
   
   
2. ??? ????? ??? ?????? Excel ?????? ??? ?? ????? ???? ??? ????? ??? ????????.

?????? 2: ????? ??????? ???????

1. ??? ????? Microsoft Office Word 2003 ?? ????? ???? ?? Word? ??? ??? ????? ? ??????? ??? ????? ???????? ??? ?? ???? ??? ????? ??? ?????????.
   
   ??? ????? Microsoft Office Word 2007 ? Microsoft Word 2010? ???? ?????????? ? ???? ?????? ??? ????????? ?? ??? ??? ??????????????? ??? ?? ???? ??? ????? ??? ????????? ???? ?????.
2. ??? ????? ??? ???????? ???? ??? ??????.
   
   ???? ??????? ????? ?? ??????? ??????? ( ??????? ???? ????? ??? ???? ????????? ????????? ?? ?? ???? ?? ??????? ???????? ?????? ????? ?????? ?? ?????? ?? ????? ???).
3. ???? ??? ??????: ????? ???????.
   
   ??????: ??? ??? ??? ????? ???????? ???? ??? ????????? ?? ??? ???? ????? ???? ??????? ???????? ????? ??????? ???? ????? ??? ?????????.
4. ?? ???? ????????? ???????:
   • ????? ???? ?????? ????? ?????:
     1. ???? ??? ????? ????? ?????.
     2. ???? ??? ?????? ???????.
     3. ?? ?????? ??????? ??????? ??? ???????? ???? ??????? ??? ??????? ??? ???? ??? ???? ??? ?????.
        
        ?????? ??? ??????? ??? ??? ????????? ???? ??? ????? ?????????? ? ?? ???? ??? ??????.
   • ????? ???????? ???? ?????? ???????:
     1. ???? ??? ????? ?? ??????? ???????.
     2. ?? ????? ?? ??????? ????? ??? ??????? ???? ?????? ?? ???? ??? ???.
     3. ??? ?? ????? ???????? ???? ??? ?????? ?? ???????? ?? ???? ??? ???. ?? ??? ??????? ??? ???? ??????? ???? ?????? ?? ???? ??? ???.
        
        ???? Word ??????? ?? ????? ???????. ??? ??? ???? ??????? ????? ?????? ????? ?????? ????? ?? ???? ???? ??? ??? ????? ?? ??????? ???????? ??? ?? ??? ??????? ???. ??? ??? ???? ????? ???????? ???? ??? ????? ????? ???????? ??? ?? ???? ??? ?????? ???????.
5. ???? ??? ??????: ????? ?????????.

?????? 3: ????? ???? ?????? Excel

1. ??? ????? ?????????? ???? ?????????? ????? ??????.
2. ???? ??? ???????.
3. ?? ????? ???? ?????? ???? ?????? ??? ???? ????? ??? ???? ??? Excel ???? ???? ?????????.
   
   ?? ???? ???????? ???? Word ?????? My Data Sources.
4. ???? ??? ???.
5. ??? ??? ???? ???? ??? Excel ??????? ??? ??? ???????? ????? ??? ????? ??????? ???? ????? ??? ????????? ???? ??????? ? ?? ???? ??? ?????. ???? ???? ????????? ???????? ?? ???? ???????? ?????? ??? ????????? ???? ??????? ??? ????? ????? ??????? ????? ??? ????? ????????? ???? ??????? ?? ?????.

?????? 4: ????? ?????????

1. ?? ?????? ??? ????????? ??????? ??? ????????? ????? ???? ???????. ?????? ???? ?? ??? ??? ???:
   • ?????? ????? ???????? ?????? ?????????.
     
     ??? ??????? ????? ???? ??? ???? ??????? ?????. ??? ????? ???????? ?????? ??? ????????? ????? ???? ???????? ??? ?????? ????? ????? ????????? ????? ???? ????????.
     
     ??????: ??? ??? ???? ??? ???? ????? ???? ??????? ?? ????? ?? ???? ?? ???? ??? ????? ???? ?? ?? ?????? ????? ????? ?????. ????? ?????? ??? ??? ???? ?? ????? ??? ??????? ??? ?? ???????? ???? ??? ?? ?????? ????? ????? ?? ??? ??????? ???? ??????.
   • ??? ??????? ?? ???????.
     
     ???? ???? ??? ????? ??? ?????? ??????? ?????? ????? ?? ????. ???? ??? ?????? ????? ?????? ???? ???? ????? ????. ??? ???? ??????? ??? ??? ???? ?? ??? ??????? ??????? ??? ??? ???????? ???? ??? ??? ??????? ????? ??????.
   • ????? ??????? ???????? ?? ???????.
     
     ???? ???? ??? ????? ??????? ??? ????? ???? ???? ?? ???? ?? ????? ?? ??????? ?? ????? ?????. ??? ????? ???????? ????? ??????? ????? ???????? ????? ??????? ?? ????????? ??? ?? ???? ?? ?????? ??????. ?????? ? ???? ??????? ???????:
     1. ???? ??? ????? ??????? ????? ????? ?????? ?????? ???? ???? ???????.
     2. ???? ??? ?? ??? ???:
        • (??????) ??? ???? ??????? ???? ???? ???? ????? ??????? ????.
        • (??? ??????) ??? ???? ??????? ??? ????? ??????? ????? ??? ???????.
        • ??? ??? ???? ???????? ????? ??? ????? ?????? ????????? ?????? ???? ????? ???? ?? ??? ?? ??????? ????? ????? ????? ??? ??????? ?????. ??? ???? ??????? ??? ??? ???? ??? ?????? ???? ???????? ??? ???? ?????/???????? ????? ????? ??????? ??? ????????.
   • ???? ???? ?????? "?????? ??? ?????????" ??? ??????? ???? ?? ???????. ???? ???? ??????? ?????? ???? ??? (????).
   ???????:
   • ???????? ????? ????????? ???? ??? ????? ???? ??? ??? ??????? ?? ???? ??? (?????). ??????? ????? ??????? ????? ??????? ? ??? ??????? ????? ????? ?????? ????? ?? ??????? ????????? ???? ?????.
   • ??? ??? ?????? ?????? ?????? ?? ??? ????????? ????? ????? ????? ??? ?????? ?? ??? ?? ?????? ??? ????????? ???? ?????? ?????? ?? ??? ???????? ?????? ??????????.
2. : ???? ??? ????? ?????? ??? "????? ??? ?????????".
   
   ??????? Word ????????? ????? ??? ???????? ?????.
3. : ???? ??? ??????: ????? ????????.

???? 5: ????? ????? ?????? ???????

????? ???? ?????

1. ?? ??????? ???????? ???? ??? ?????? ???? ???? ????? ???.
2. ????? ?? ??? ???:
   • ???? ????? ?? ????? ???????? ???? ???????
     1. ???? ??? ???? ?????.
     2. ?? ????? ???? ????? ??????? ??? ????? ??????? ???? ???? ??????? ?????????? ???? ??????? ?? ???? ??? ?????. ?????? ??? ??????? ??? ??? ????????? ???? ??? ????? ?????????? ??? ?? ???? ??? ??????.
        
        
     3. ?????? ??? ??????? ??? ??? ????????? ???? ??? ????? ????????? ??? ?? ???? ??? ??????.??? ??? ????? ?????? ???? ???? ??????? Word ?? ??? ?????? ??? ?????? ??? ??? ????????? ???? ????? ????? ????? ???????. ???? ??? ????? ??????? ????? (??? ?????)? ?? ??? ????? ?? ???????? ?????? ?? ???? ???? ?????? ?? ????? ?????? ?????? ??? ?????????.
   • ??? ???????
     1. ???? ??? ??? ???????.
     2. ??? ????? ??? ???????? ???? ????? ?????? ???? ??????? ??????? ??????? ???????.
     3. ??? ???? ???? ????? ?? ???? ?? ??????? ??? ?? ???? ????? ?????? ??????? ?????? ??? ???? ??????? ??? ???????? ???? ????? ??? ?? ??? ???? ?? ??? ?????? ???? ???? ??? ???.
     4. ???? ??? ?????.
     5. ??? ??? ????? ?????? ???? ???? ??????? Word ?? ??? ?????? ??? ?????? ??? ??? ????????? ???????? ???? ???????. ???? ??? ????? ??????? ????? (??? ?????)? ?? ??? ????? ?? ???? ???????? ???? ?????? ?? ????? ?????? ?????? ??? ?????????.
   • ???? ??????? ????
     1. ???? ??? ???? ?? ???????.
     2. ?? ???? ????????? ???????:
        • ??????? ?? ???? ???????? ???? ???? ????? ???????? ??? ?????? ???????? ?? ???? ????????? ??? ??? ???? ???????? ?????? ????? ???? ???? ?? ??? ??? ????? ?????? ?????? ??? ???? ??? "???? ???????".
        • ??????? ?? ???? ???? ???????? ?????? ?????? ?? ???? ?? ????? ??????? ???? ??? ???? ????? ????????.
     3. ?? ?????? ? ???? ??? ????? ???? ?????.
     4. ???? ??? ?????? ?? ???? ??? ?????.
     5. ??? ??? ????? ?????? ???? ???? ??????? Word ?? ??? ?????? ??? ?????? ??? ??? ????????? ???????? ?????? ?????. ???? ??? ????? ??????? ????? (??? ?????)? ?? ??? ????? ?? ???????? ?????? ?? ???? ???? ?????? ?? ????? ?????? ?????? ??? ?????????.
        
        ??????: ??? ??? ?????? ??? ?? ???? ????? ???????? ???????? ??? ???????? ?????? ??? ???? ?????? ?? ????? ???? ???? ?????? Word ?? ???? ?????? ??? ????? ??? ????? ????????? ?? ??????? ??????.
   • ???? ????????
     
     ?????? ???? ????????? ??? ???? ????? ????? ??? ????? ??????? ?????????? ??? ???? ??? ????? ?? ???? ??? ???? ??? ????????. ???????? ??????? ???????????? ???? ??? ??????? ???????:
     1. ???? ??? ???? ????????.
        
        ??? ?? ??? ???? ?????? ???? ?????????? ????? Word ???????? ?????? ??? ????? ??????? ???? Microsoft ??????:
        Microsoft Office ??? ???

        (http://office.microsoft.com/en-us/marketplace/)
     2. ????? ???? ???? ???????? ???????.
   • ?????? ???? ????????? ??? ????? ????? ?????? ?????? ??????????? ??? ???? ??? ??????? ?? ???? ??? ???? ??? ????????.
     
     ??? ????? ??? ????? ????? ?? ???? ???? ???? POSTNET ????????? ????????. ???????? ???? ?????? ????????? ???? ??????? ???????:
     1. ???? ??? ???? ???? ?????.
     2. ?? ????? ???? ?????? ???????? ??????? ??? ???? ??????? ????????.
        
        ??????: ???? ???? ????? ???? ?????? ??? ??? ??? ?????? ????? ????? ???????? ??????? ??????.
     3. ??? ??????? ?? ? b ??????? ????? ?????? ???? ???? ??????.
        
        ???????:
        • ?? Word 2003 ?????????? ??????? ?? Word? ????? ?? ???? ????? ???? ???? ????? ("") ?? ??????? ???????? ???????? ??? ????? ???????.
          
          ?? Word 2007 ? Word 2010? ?? ????? ????? ???? ???? ????? ("") ?? ??????? ??????????? ?? ???? ????? ???????? ?? ????? ???????.
        • ??? ???? ???? ????? ??? ????? ?????? ??? ? {MERGEFIELD City}? ??? Word ???? ???? ?????? ????? ?? ??? ???????. ???? ?? ???? ??? ?????, ??? ??? ??? ???? ??? ??????? ????? ?? ???? ???? ????? ??????? ??? ??? ?????? ??? ???? ??? ????? ???? ?????? ?? ??????? ????????.
   ?????? ?? Word 2003 ?????????? ??????? ?? Word? ????? ????? ???? ??????? ???? ????? ??? ????????? ????? ???? ?????? ?????? ???????? ?????? ????? ?? ??? ??????? ???????? ?? ?????? ??? ?????????. ???? ???? ??????? ??? ?????????? ??? ??? ????? ???????? ??? ????? ???????? ??? ?? ???? ??? ????? ???? ????? ??? ?????????. ???? ???? ????? ??? ????????? ????? ?????? ??? ????? ?? ???? ?????? ????? ??? ?????????. ??? ???? ??????? ????? ??????? Word ????? ??? ??????? ???????? ??? ???? ????? ??? ????????? ????? ???? Word ?????? ?? ????? ??? (??? ???? ??????? ??? IF ???? ???? ?????? ?? ??? ??? ??? ??? ??? ??? ???? ?????). ??? ????? ????? ??? ?????? ?? ???? ????? ???? Word ????? ??? ????????? ???????? ?? ??? ????? ??????? ?? ??????? ???????.

????? ????? ???????? ???????

1. ?? ??????? ???????? ??? ????? ???? ????? ??? ????????? ???? ???? ???????? ??? ?? ??? ???? ???? ????? ("" "") ???? ????????.
2. ?? Word 2003 ??? ????????? ??????? ?? Word? ???? ??? ???? ??? ????? ????? ???????? ??? ?????? ???????? ???? ??????.
   
   ?? ?????? word 2007? ??? ?????? ???????? ? ???? ??? ???? ?????? ???????? ???? ???? ???? ??????? ? ?? ??? ???????? ???? ??????.

????? ???????? ???? ??????

1. ???? ????? "34987.89" ? "$ 34,987.89"? ?? ?????? ??? ????? ????? ???? (\#).
2. ?????? ????? ??????? ????? ?????? ??? ??????? ?? ???????? (\*).
3. ?????? ?? ?? ????????? ??????? ?? ??? ???? ???? ?????? ??? ??? ???? ?????\* ????? Charformat.

?????? ???????: ??? ???????

1. ?? Word 2003 ??? ????????? ??????? ?? Word? ???? ?????? ???? ??? ??? ???????.
   
   ?? ?????? word 2007? ???? ??? ?? Microsoft Office? ?? ???? ??? ??? ???.
   
   ?? 2010 Word? ???? ??? ??? ??? ?? ???? ??? ??? ????.
   
2. ????? ???????? ??? ?? ???? ??? ???.
3. ???? ??? ??????: ?????? ?????? ???????.

???? 7: ?????? ?????? ??????? ???? ????? ?????????

Vice President, Sales Andrew Fuller     Sales Representative Anne Dodsworth
1235 Main St                            1231 Elm St.
Tacoma                                  London
	
	
Sales Representative Janet Leverling     Inside Sales Coordinator Laura Callahan
1235 Elm St.                             1230 Elm St.
Kirkland                                 Seattle
				

• ??????? ??????? ????????? ???? ??? ?????? ?? ?????? ????? ??????.
  
  ??? ?????? ?? ??? ?? ????? ??????? ?????? ??? ????.
• ?????? ???? ???? ???? ????????? ???? ??? ????? ?? ???????? ?? ?? ?????? ?????? ????? ?? ???? ?? ??????? ???? ??????.

1. ???? ??? ????? ????? ?????????? ?? ?? ?????? ????????? ?? ?????? ??? ????????? ???? ??????.
2. ???? ??? ??????: ????? ?????.

???? 8: ????? ?????

????? ?????? ????? ?????

1. ???? ??? ????? ?????? ?????.
2. ?? ??? ??? ????? ???? ??????? ??? ??????? ???? ???? ?????.
3. ???? ??? ?????.
   
   ???? Word ???? ????? ???? ????. ??????? ????? ?? ??? ???? ??????? ???????? ?????? ??????? ???? ??? ??? ???? ????? ????? ???? ???????.
4. ?? ???????? ??? ????????? ???? ???? ???????? ????? ????????? ?????? ??.
5. ????? ?? ??? ??????? ????? ??? ???? ?? ?? ???? ???????.

????? ???? ?????? ?????

• ??? ??? ?????? ??????? ???? ??????? ?????? ??????:
  1. ?? Word 2003 ??? ????????? ??????? ?? Word? ???? ??? ????? ??? ????? ??? ???????.
     
     ?? ?????? word 2007? ???? ??? ?? Microsoft Office? ??? ??? ?????, ??? ?? ???? ??? ?????.
     
     ?? 2010 Word? ???? ??? ???? ???? ??? ????? ??? ?? ???? ??? ?????,
     
  2. ??? ???????? ???? ??????.
• ??? ??? ???? ?? ????? ?????? ?? "????? ??? ?????????":
  1. ?? ?????? ??? 6 (????? ??? ?????????????? ?????)? ???? ??? ?????.
  2. ?? ????? ????? ??? ??????? ???? ??????? ?? ??? ????????? ???????? ?? ???? ??? ?????:
     • ?????? ???? ?????????? ???? ??? ????.
     • ?????? ??????? ???? ???? ?? ??????? ????? ???? ??? ????? ??????.
     • ?????? ???? ?? ?????????? ???? ??? ??? ?? ???? ????? ??????? ?? ?? ? ??? ??????.
  3. ?? ????? ??????? ??? ???????? ???? ??????.

??? ???? ?????? ????? ????????? ??????

1. ???? ??? ????? ?????? ?????.
2. ?? ??? ??? ????? ???? ???? ??????? ?? ???? ????????? ???????? ??? ?? ???? ??? ?????:
   • ???? ???? ?????????? ???? ??? ????.
   • ???? ??????? ???? ???? ?? ??????? ????? ???? ??? ????? ??????.
   • ???? ???? ?? ?????????? ???? ??? ??? ?? ???? ????? ??????? ?? ?? ? ??? ??????.
3. ???? Word ??????? ?????? ???? ????? ??? ???? ?????? ????? ?????. ????? ?? ??? ??????? ????????? ??????? ??? ?? ??? ??????? ??????.

?????

???? ??? ?????? | ????? ???????