Εξαιρετικά εργαλεία Excel

 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

(you need to activate Developer's tab) 

ADD DROP-DOWN MENUS 

 

SCENARIO MANAGER

Use MACROS

Use VBA

 

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