The Essential Excel Dictionary English Portuguese Reference Guide

An Excel Dictionary for English and Portuguese typically refers to a resource or tool used to cross-reference Excel formula names and syntax, which completely change depending on whether you are using the English or Portuguese version of Microsoft Excel. While Excel automatically converts formulas behind the scenes when opening files across different language versions, users often need a manual translation dictionary when building spreadsheets or following tutorials in a second language. Essential Excel Function Translations

Below is a reference guide for the most common Excel functions translated between English and Portuguese: English Function Portuguese Function SUM SOMA Math & Trigonometry AVERAGE MÉDIA Statistical IF SE VLOOKUP PROCV Lookup & Reference HLOOKUP PROCH Lookup & Reference COUNT CONTAR Statistical COUNTA CONT.VALORES Statistical COUNTIF CONT.SE Statistical CONCATENATE CONCATENAR / CONCAT TODAY HOJE Date & Time MATCH CORRESP Lookup & Reference INDEX ÍNDICE Lookup & Reference Critical Syntax Differences

Aside from function names, the localized versions of Excel change foundational syntax rules:

Argument Separators: The English version of Excel separates formula arguments using a comma (e.g., =SUM(A1, B1)). The Portuguese version uses a semicolon (e.g., =SOMA(A1; B1)).

Decimal Separators: English defaults to a period (.) for decimals and commas (,) for thousands. Portuguese defaults to a comma (,) for decimals and periods (.) for thousands. Built-in & Web Translation Tools

If you need to translate complex strings or entire workbooks, you have several options:

Excel function translations Portuguese to English – PerfectXL