Informática Avançada 2
Do PROCV a outras fórmulas, como elas podem nos ajudar no trabalho?
Logical or conditional functions in Excel or spreadsheets: AND, OR and IF
Conditional functions: SUMIF or SUMIF and COUNTIF or COUNTIF
Conditional functions: COUNTUNIQUEIF and AVERAGEIF
Search functions: Filters, OFFSET and INDEX:INDEX
Search functions: RANK, INDEX + MATCH or INDEX + MATCH
Search functions: VLOOKUP or VLOOKUP and HLOOKUP or HLOOKUP
Search functions: the pivot table in Excel or spreadsheets
