Excel-Function (Fx)

Today / Month / Year :

1)=TODAY() 

2)=MONTH(TODAY())

3)=year(TODAY())

Excel-Data-Validation Data (List)

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 

 

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 

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

Excel-PivotTable

Excel-Select Data

Excel-WordArt

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:

Salary and Expense

Compu21 Contacts