The mathematical functions in Microsoft Excel

Multimodal Synchronous

> The face-to computing functions in Microsoft Excel for the richness of exchanges and the necessary perspective to the discovery and mastery of all potential software, training focused on efficiency.

> Virtual Classroom for fast growing competence around its own business issues, training focused on efficiency.

> ShareHelpActiv'Tutoring ™ and ™ for synchronous teaching support demand and support.

Prerequisite :

Reminder about the features (Syntax, types d’arguments)

Use of names

• Create , remove, change names
• Use names in formulas

The statistics functions

• Function (AND) and (AND) Nested
• functions (SOMME.SI) ) and (NB.SI)
• functions (SOMME.SI.ENS) ) and (NB.SI.ENS)
• The function IFERROR() (from 2007)
• Conditional formatting

The logic functions

• Features (AND) and (AND) Nested
• Features (AND) and (Or)
• IFERROR Function() (from 2007)
• REAL functions() and FALSE()

Special Functions

• Functions dates : YEAR(), MONTH(),WEEKDAY(), DATEDIF()
• Text Functions : TEXT(), LEFT(),RIGHT(),STXT()

Search functions

• RESEARCH(), VLOOKUP(), SEARCH(H)
• INDEX( ), EQUIV( )

Virtual Classroom The calculation functions in Microsoft Excel into independent modules 2:00

Excel's calculation functions (2h00)

• The Sum function
• Absolute and relative references (freeze / appoint a cell)
• Calculations %
• The wizard function
• The AutoComplete function
• AVERAGE selection functions(), MAX() and MIN(),NB(), NBVAL(), COUNTBLANK()
• Introduction to functions with several arguments VPM() ,NB.SI()

Search functions (2h00)

• Reference Types (Reminder about Absolute Ref & Ref Mixed)
• Recall on the names
• VLOOKUP HLOOKUP Function()
• IFERROR Function()
• INDEX Function()
• Fonction EQUIV()
• HYPERLINK function
• IFERROR function()
• Target value
• Scenario manager
• OFFSET function() by level or time

Special tools and special functions (2h00)

• Search For / Replace
• The wizard and forums
• Text functions : LEFT() RIGHT()STXT()-TEXT()-CONCATENER- CNUM() ..
• Date Functions : DATEDIF()- SERIE.JOURS.OUVRES(), END;MONTH(), YEAR(),
• NB.JOURS.OUVRES.INTL()
• Functions Number : ROUND()–ENT()....
• Financial Function : VPM(), VA(), RATE(), NPM()
• The tool CONVERT

Conditional functions (2h00)

• Conditional Formatting
• Reference Types (Reminder about Absolute Ref & Ref Mixed)
• IF function, If nested ; If the functions ET() OR()
• NB.SI functions() and SOMME.SI()
• COUNTIFS functions , SOMME.SI.ENS()(office 2010)
• IFERROR Function()