Date / Month / Year

Word: Insert / Date & Time / Check "Update automatically"

Excel-Function (Fx)

Today / Month / Year :

1)=TODAY() 

2)=MONTH(TODAY())

3)=year(TODAY())

Repair Chrome

1) Settings / History / Clear browsing data

2) Settings / History  /Extensions

3)Settings/ Show advanced settings / Reset browser

4) Re- install Chrome

Excel-Data-Validation Data (List)

Photoshop

文字倒影

Snipping Tools

1) Open item / click on scissor (snipping tool) / new /  select the item / file /save as /to your picture.
2) Whenever you use..just insert the picture from your file. .

Special Task in Microsoft

1) Starting from 0 : use ' type.

2) Office Button / Excel Options / Formulas / Uncheck “Numbers formatted as text …”

              

     

                                                         

More Format Numbers / Custom / "7187621900"@ or (718) ###-####

 

Excel-look for duplicates

Original File

1, Home / Conditional Formatting / Highlight Cells Rules / Duplicate values / OK

2, Highlight Cells / Data / Remove Duplicates / OK

Excel-Print Title

Page Layout / Print Titles / Sheet / Rows to repeat at top / Highlight Title /print Preview / Next Page

Excel-Chart

Chart

1, New Sheet / Insert / Column 

 

ADD TAB- Developer

Office Button / Excel Options / Popular / Show Developer tab in the Ribbon

Excel-Spin Button

Spin Button 

1)Add Tab-- Developer:Office Button / Excel Options / Popular / Show Developer tab in the Ribbon

2) Developer / Insert / Spin button / Draw / Right Click / Format Control 

Developer / Insert / Spin button / Draw / Right Click / Format Control 

TABLE--HTML CODE

<div>

<table border="1" bordercolor="#288822" cellpadding="0" cellspacing="0" style="width: 100%;"><tbody>
<tr valign="top"><td><div>
11</div>
</td><td><div>
12</div>
</td></tr>
</tbody></table>
</div>

11

12

Set Office Password

Office Button / Save as / Tools / General options

Excel-Form (Data List)

Quick Access Toolbar / More Commands / Commands Not in the Ribbon /Form / Add / OK

1, Highlight Menu / Form

Excel-Validation

Validation Date (2013)
Data/-highlight (select) data-data validation/-allow/-date






.2,Whole number: Item# And Inventory

Excel-Filter

1. Highlight / Data / Filter 
2. Symbol / Select " INTC" first..CIEN...MSFT (so on)
3. Highlight / Type (Investment Names) / Ctrl+enter
4. Symbol / Select All

Word-WaterMark

Page Layout / WaterMark

1. Custom Watermark
1. No Watermark
2. Picture Watemark
1. Use Powerpoint-layout-(blank) insert WordArt
3. Text Watermark

Excel-PivotTable

Health Information

避免洗腎偏方:
新鮮荔枝的種子七粒、打碎後用紗布包紮，放在碗內， 加上第二次洗米水兩婉，一 起放在電鍋中蒸， 大約蒸半小時，然後一次把湯喝完，就能奏效

Word-Two lines in one

Two Lines in One - Word

Excel-Select Data

Excel-WordArt

Word--Mail Merge

Excel- Lock / Protect Sheet

1) select cell -- right click--format cell
2) review--protect sheet-- no ck marked for select locked cells


                                                                                   

Excel- arrange

Excel-Sort

Data-->Sort

Excel -Transpose

Excel- Data consolidated

1 & 2)= Data-->Consolidate

3) combined total:

Word-Page Layout (Landscape, Columns,Margins,Break)