Excel Functions — English / French

Data Description | Reference

Modified

October 6, 2026

This page lists every Excel function used in the course with its French-language equivalent. Functions are grouped by the module where they are first introduced.

Note on locales: If your Excel uses a French locale, function names and list separators differ (e.g., AVERAGE → MOYENNE; , → ;). The formulas in this course use English function names and comma separators. Use the table below to translate.

Module 1 — First steps

English	Français	Purpose
`SUM`	`SOMME`	Add a range of numbers
`COUNT`	`NB`	Count numeric cells
`COUNTA`	`NBVAL`	Count non-empty cells
`IF`	`SI`	Conditional logic
`AND`	`ET`	Logical AND
`OR`	`OU`	Logical OR
`MIN`	`MIN`	Smallest value
`MAX`	`MAX`	Largest value
`LARGE`	`GRANDE.VALEUR`	k-th largest value
`TODAY`	`AUJOURDHUI`	Current date
`MONTH`	`MOIS`	Month number from a date

Module 2 — Frequency tables & charts

English	Français	Purpose
`COUNTIF`	`NB.SI`	Count cells matching one criterion
`COUNTIFS`	`NB.SI.ENS`	Count cells matching multiple criteria
`SUMIF`	`SOMME.SI`	Sum cells matching one criterion

Module 3 — Histograms & cumulative curves

English	Français	Purpose
`COUNTIFS`	`NB.SI.ENS`	Class counts with range criteria (`>=lower`, `<upper`)
PivotTable grouping	Regroupement TCD	Right-click a numeric field → Group to bin automatically

Module 4 — Central tendency

English	Français	Purpose
`AVERAGE`	`MOYENNE`	Arithmetic mean
`MEDIAN`	`MEDIANE`	Median (50th percentile)
`MODE.SNGL`	`MODE.SIMPLE`	Single most frequent value
`SUMPRODUCT`	`SOMMEPROD`	Weighted mean (`=SUMPRODUCT(values, weights)/SUM(weights)`)

Module 5 — Position & boxplot

English	Français	Purpose
`QUARTILE.EXC`	`QUARTILE.EXCLURE`	Exclusive quartiles (position `(n+1)q`) — course standard*
`PERCENTILE.EXC`	`CENTILE.EXCLURE`	Exclusive percentiles — course standard
`MIN`	`MIN`	Minimum (for five-number summary)
`MAX`	`MAX`	Maximum (for five-number summary)
Box & Whisker chart	Graphique Boîte à moustaches	Insert → Charts → Statistical → Box and Whisker

Why QUARTILE.EXC? The course follows the (n+1)*q position formula (OpenStax §2.2), which matches Excel’s exclusive method. QUARTILE.INC (inclusive) gives different values on small samples — do not mix them.

Module 6 — Dispersion

English	Français	Purpose
`VAR.S`	`VAR.S`	Sample variance (denominator `n-1`) — course standard
`STDEV.S`	`ECARTYPE.STANDARD`	Sample standard deviation — course standard
`VAR.P`	`VAR.P.N`	Population variance (denominator `n`)
`STDEV.P`	`ECARTYPE.PEARSON`	Population standard deviation
`SUMSQ`	`SOMME.CARRES`	Sum of squares (for variance shortcut)

Sample vs population: This is a descriptive statistics course. We use the sample formulas (.S) by default because real business data are almost always samples. The population variants (.P) are shown for completeness.

Module 7 — Shape

English	Français	Purpose
`SKEW`	`COEFFICIENT.ASYMETRIE`	Adjusted Fisher–Pearson skewness (sample)

Kurtosis: No Excel function is used — kurtosis is treated conceptually only (names and pictures).

Module 8 — Bivariate I

English	Français	Purpose
`COUNTIFS`	`NB.SI.ENS`	Two-way contingency table counts
PivotTable (two fields)	TCD (deux champs)	Rows = one variable, Columns = another, Values = Count
XY Scatter chart	Nuage de points	Insert → Charts → Scatter

Module 9 — Bivariate II

English	Français	Purpose
`COVARIANCE.S`	`COVARIANCE.STANDARD`	Sample covariance
`COVARIANCE.P`	`COVARIANCE.PEARSON`	Population covariance
`CORREL`	`COEFFICIENT.CORRELATION`	Pearson correlation coefficient r
`SLOPE`	`PENTE`	Least-squares slope b
`INTERCEPT`	`ORDONNEE.ORIGINE`	Least-squares intercept a
`RSQ`	`COEFFICIENT.DETERMINATION`	Coefficient of determination R²
Data Analysis → Regression	Données → Analyse → Régression	Full regression output table (Analysis ToolPak)

Module 10 — Synthesis

All functions from Modules 1–9.

Quick reference: English → French (alphabetical)

English	Français
`AND`	`ET`
`AVERAGE`	`MOYENNE`
`CORREL`	`COEFFICIENT.CORRELATION`
`COUNT`	`NB`
`COUNTA`	`NBVAL`
`COUNTIF`	`NB.SI`
`COUNTIFS`	`NB.SI.ENS`
`COVARIANCE.P`	`COVARIANCE.PEARSON`
`COVARIANCE.S`	`COVARIANCE.STANDARD`
`IF`	`SI`
`INTERCEPT`	`ORDONNEE.ORIGINE`
`LARGE`	`GRANDE.VALEUR`
`MAX`	`MAX`
`MEDIAN`	`MEDIANE`
`MIN`	`MIN`
`MODE.SNGL`	`MODE.SIMPLE`
`OR`	`OU`
`PERCENTILE.EXC`	`CENTILE.EXCLURE`
`QUARTILE.EXC`	`QUARTILE.EXCLURE`
`QUARTILE.INC`	`QUARTILE.INCLURE`
`RSQ`	`COEFFICIENT.DETERMINATION`
`SKEW`	`COEFFICIENT.ASYMETRIE`
`SLOPE`	`PENTE`
`STDEV.P`	`ECARTYPE.PEARSON`
`STDEV.S`	`ECARTYPE.STANDARD`
`SUM`	`SOMME`
`SUMIF`	`SOMME.SI`
`SUMPRODUCT`	`SOMMEPROD`
`SUMSQ`	`SOMME.CARRES`
`TODAY`	`AUJOURDHUI`
`VAR.P`	`VAR.P.N`
`VAR.S`	`VAR.S`

French locale tips

List separator: French Excel uses ; instead of , between arguments.
- English: =AVERAGE(A1:A10) → French: =MOYENNE(A1:A10) (same here)
- English: =IF(A1>0, "pos", "neg") → French: =SI(A1>0; "pos"; "neg")
Decimal separator: French uses , (comma) for decimals; English uses . (point).
- The CSV files in this course use . as decimal separator.
Function names: The table above gives the exact French names. If a function is not listed, it may not have a localised name (rare).

Unverified French names

The following French names are inferred from Microsoft documentation and have not been tested in a live French Excel. Please verify before relying on them in an exam setting:

QUARTILE.EXC → QUARTILE.EXCLURE
PERCENTILE.EXC → CENTILE.EXCLURE
VAR.S → VAR.S (may be VAR.S in both locales)
STDEV.S → ECARTYPE.STANDARD
COVARIANCE.S → COVARIANCE.STANDARD
COVARIANCE.P → COVARIANCE.PEARSON
SKEW → COEFFICIENT.ASYMETRIE
RSQ → COEFFICIENT.DETERMINATION