EXCEL

Home
Home EXCEL

Funções

SUM | SUMIF
MAX | MIN
AVERAGE
IF
COUNTIF
VLOOKUP
MATCH
INDEX

AutoFilter


Exemplos

Simples
Vlookup Match
Index Match
PivotTable


VBA

Simples


Exemplos




Ex 1 - +,-,/,*
Ex 2 - +,-,/,* $
Ex 3 - SUM MAX MIN AVERAGE
Ex 4 - Gráficos
Ex 5 - VLOOKUP
Ex 6 - VLOOKUP
Ex 7 - SUMPRODUCT SUMIF
Ex 8 - IF SUM AVERAGE
Ex 9 - SUMIF LOOKUP SUM
Ex 10 - VLOOKUP
Ex 11 - VLOOKUP