Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

 
2. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!


 

Excel functions in French

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