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