EXCEL TOOLS CHECK LIST

 AUTO FILL

SHORT

SUM function

AVERAGE function

IF function

VLOOKUP function

INDEX function

MATCH function

COUNTIF function (also COUNTA, COUNTBLANK,...)

PIVOT TABLES

FILTER Data

REMOVE duplicate data

TRANSPOSE rows to columns 

SPLIT TEXT - COMPOSE TEXT

CONDITIONAL FORMATING

FORMAT PAINTER

ADD CHECKBOXES

ADD DROP-DOWN MENUS 

SCENARIO MANAGER

Use MACROS

Use VBA

 

F5 / Go To / Special

Use ' to show in cell exact input (e.g.: 007)

Use $ to lock source cell

Add Comment 

Wrap text

Merge and Center

Header and Footer

PRINT : fit sheet on one page  (scale)

Freeze Panes

Protect

Share