With our upcoming Excel courses in the DRC, we have needed to make sure we know what the equivalent Excel functions are in French. With that in mind we have prepared this translation sheet which shows the English name for the Excel Function and the equivalent French Name for the main functions we teach in the beginner and the Intermediate to Advanced Courses. The hyperlinks take you to where you can learn about the function.
For the full list look at this site
| Function | Fonction |
| IF | SI |
| AND | ET |
| OR | OU |
| CLEAN | EPURAGE |
| CONCATENATE | CONCATENER |
| DOLLAR | EURO |
| TEXT | TEXTE |
| LEFT, LEFTB | GAUCHE, GAUCHEB |
| LEN, LENB | NBCAR, LENB |
| MID, MIDB | STXT, STXTB |
| RIGHT, RIGHTB | DROITE, DROITEB |
| FIND, FINDB | TROUVE, TROUVERB |
| SEARCH, SEARCHB | CHERCHE, CHERCHERB |
| VALUE | CNUM |
| SUBSTITUTE | SUBSTITUE |
| LOWER | MINUSCULE |
| PROPER | NOMPROPRE |
| REPT | REPT |
| TRIM | SUPPRESPACE |
| UPPER | MAJUSCULE |
| HLOOKUP | RECHERCHEH |
| VLOOKUP | RECHERCHEV |
| RANK | RANG |
| IFERROR | SIERREUR |
| ISERROR | ESTERREUR |
| AVERAGEIF | MOYENNE.SI |
| AVERAGEIFS | MOYENNE.SI |
| COUNTIF | NB.SI |
| COUNTIFS | NB.SI.ENS |
| LARGE | GRANDE.VALEUR |
| MAX | MAX |
| MIN | MIN |
| SUM | SOMME |
| SUMIF | SOMME.SI |
| SUMIFS | SOMME.SI.ENS |
| SUMPRODUCT | SOMMEPROD |
| CHOOSE | CHOISIR |
| TRANSPOSE | TRANSPOSE |
| DATE | DATE |
| DAY | JOUR |
| MONTH | MOIS |
| YEAR | ANNEE |
| EOMONTH | FIN.MOIS |
| WEEKDAY | JOURSEM |
| WEEKNUM | NO.SEMAINE |
| WORKDAY | SERIE.JOUR.OUVRE |
| NETWORKDAYS | NB.JOURS.OUVRES |
| DATEVALUE | DATEVAL |
| DAYS360 | JOURS360 |
| YEARFRAC | FRACTION.ANNEE |