“The Complete Excel Dictionary: English and Portuguese Function Reference” is a comprehensive reference guide designed to bridge the gap between English and Portuguese versions of Microsoft Excel. Because Microsoft Excel localizes its formula names (unlike many programming languages), users working across different language installations often struggle to write or convert formulas. This reference resource solves that exact problem. Core Features & Contents
Two-Way Translations: Maps functions from English to Portuguese (e.g., VLOOKUP to PROCV) and Portuguese to English (e.g., SE to IF).
Function Descriptions: Provides brief contextual definitions explaining what each formula does in both languages.
Categorized Layout: Organizes formulas into their native Excel categories (Logical, Statistical, Financial, Math, Lookup, etc.).
Syntax Adjustments: Highlights crucial regional formatting differences, such as swapping commas (,) for semicolons (;) when using the Portuguese version. Common Function Examples
The reference maps out hundreds of formulas. Some of the most frequently used cross-language translations include: English Function Portuguese Function SUM SOMA Math & Trigonometry AVERAGE MÉDIA Statistical IF SE VLOOKUP PROCV Lookup & Reference COUNT CONTAR Statistical SUMIF SOMASE Math / Conditional MATCH CORRESP Lookup & Reference Who Needs This Reference?
Multinational Professionals: Expatriates, remote workers, or analysts working in global companies that use mixed-language operating systems.
Students & Educators: Individuals transitioning from studying Excel via English tutorials to working in a Portuguese localized corporate setting.
Macro & VBA Developers: Developers writing scripts that interact directly with localized spreadsheet cells and formulas.
If you are trying to find a specific formula translation right now, tell me the English or Portuguese function name and I will translate its syntax for you!
Excel 2007 function name translations | MrExcel Message Board
Leave a Reply