HomePage

1.  |
2. Cloud: Dropbox 
3. Photoshop: Change Sky
4. Music: Teresa Teng Music Performance |
5. Friend's Web: Lee |Classwu |Shirley |Iren | MeiYu |Kathy |
6. Computer:
1. how to remove auto hyperlinks from office 
2. Word Mail Merge with Excel
3. classwu Excel: Transpose in Excel
4. Excel- Filter | Excel - data Validation |Excel - add FORM on ribbon
7. Travel:
8. Video: 
9. Web: picturetrail |download youtube |

Excel - FORM - data information input

Quick access toolbar / more commands / commands not in the ribbon / form / add / ok

1. add data information on FORM

Excel - Data Validation

data/ data validation

1. Data (2013):

2. Whole Number: Item# and Inventory

1.  Highlight / Data / Filter
2.  Symbol / Select / "INTC"
3.  highlight/type/control + enter
4. symbol / select all

Excel - Transpose - classwu 031814

Exce data consolidate - classwu

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Word Mail Merge with Excel

Word Mail Merge

一、     Excel：Company information

二、     Word：

1.       Open Word 2007→office Button→New→輸入“Notice”→“Letter notifying customer of past due bill”→Download。

2.       填寫自己的信息。

3.       Mailings→Select Recipients→Use Existing List→Open製作好的“Company information”

4.       Highlight [Recipient Name]→Insert Merge Field→選擇Name→Preview Results。

5.       Highlight [Title]→Rules→If…Then…Else→

1)      Field name = Gender; Equal to M; Insert this text = Mr. ; Otherwise insert this text = Ms.

6.       Highlight [Company Name]→Insert Merge Field→Company。

7.       Highlight [Street Address]→Insert Merge Field→Street Address。

8.       Highlight [City, ST ZIP Code]→Insert Merge Field→City Zip Code。

9.       下面一行→Insert Merge Field→Tel.

10.  Highlight [Recipient Name]→Insert Merge Field→選擇Name。

11.  Finish & Merge→Edit individual Documents→All→OK

how to remove auto hyperlinks from office

Office Button ( left of top sign) / Excel Options/Proofing/ Auto correct options / Auto Format as you type/ uncheck "Interner and network path with hyperlinks" 

Photoshop - Change sky

My Photoshop  Class



Original

Change Sky

Teresa Teng Music Performance