​Useful Formulas & Functions (50449) 
Cours disponible en français ou en anglais - Training available in French or in English

Durée: 1 jour 

Objectifs du cours : 
This 1 day course provides students with the knowledge and skills to the usage of useful formulas and functions in Microsoft Excel.
​
Compétences acquises : 
Les stagiaires seront à même d'effectuer les tâches suivantes :

• Understand and apply formula basics
• Using cell references
• Copying formula without changing cell reference
• Transpose formula using paste special
• Using nested functions
• Perform calculation using CountIf, SumIf, AverageA
• Using If function to prevent division by zero
• Using IsError function to avoid error display
• Create multiple conditions using nested IF
• Using logical function OR, AND
• Using Vlookup to find specific data
• Using Hlookup to find values in rows
• Using Match and Index to retrieve data
• Changing case of text using Upper, Lower or Proper formula
• Append text and numerical value
• Convert imported text format into numbers
• Break imported date field into individual columns
• Perform addition and calculate difference between two dates
• Perform calculations with Time fields
• Using Array Formulas
• Calculating the difference between Maximum and Minimum values in an Array
• Using Frequency function to Count responses in tabulated data
• Using Database functions DSum and DCount
• Understand the advantages of shortening worksheet names
• Protecting cells from amendments by others
• Using Data validation to improve data entries
• Using Auditing Tools for checking errors
• Adding useful notes by commenting worksheet

 
Connaissances requises : 
Before attending this course, students must have:

• Intermediate Excel experience