Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/include.php on line 73

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/include.php on line 157

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/include.php on line 235

Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /kunden/188616_52080/maninweb/business/include.php:73) in /kunden/188616_52080/maninweb/business/include.php on line 34

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /kunden/188616_52080/maninweb/business/include.php:73) in /kunden/188616_52080/maninweb/business/include.php on line 34

Deprecated: Function set_magic_quotes_runtime() is deprecated in /kunden/188616_52080/maninweb/business/include.php on line 62

Deprecated: Function eregi_replace() is deprecated in /kunden/188616_52080/maninweb/business/include.php on line 247

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/classes/class.global.inc.php on line 184

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/classes/class.global.inc.php on line 196

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/classes/class.global.inc.php on line 208

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/classes/class.global.inc.php on line 221

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/classes/class.global.inc.php on line 234

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/classes/class.global.inc.php on line 246

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/classes/class.global.inc.php on line 258

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/classes/class.global.inc.php on line 270

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/classes/class.global.inc.php on line 282

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/classes/class.global.inc.php on line 294

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/classes/class.global.inc.php on line 316

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/classes/class.moduleloader.inc.php on line 69

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/classes/class.moduleloader.inc.php on line 129

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 311

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 530

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Strict Standards: Declaration of CGExtensions::GetHelp() should be compatible with CMSModule::GetHelp($lang = 'en_US') in /kunden/188616_52080/maninweb/business/modules/CGExtensions/CGExtensions.module.php on line 45

Strict Standards: Declaration of CGExtensions::GetAdminDescription() should be compatible with CMSModule::GetAdminDescription($lang = 'en_US') in /kunden/188616_52080/maninweb/business/modules/CGExtensions/CGExtensions.module.php on line 45

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Strict Standards: Declaration of Comments::GetAdminDescription() should be compatible with CMSModule::GetAdminDescription($lang = 'en_US') in /kunden/188616_52080/maninweb/business/modules/Comments/Comments.module.php on line 256

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Strict Standards: Declaration of MovedPages::GetHelp() should be compatible with CMSModule::GetHelp($lang = 'en_US') in /kunden/188616_52080/maninweb/business/modules/MovedPages/MovedPages.module.php on line 416

Strict Standards: Declaration of MovedPages::GetAdminDescription() should be compatible with CMSModule::GetAdminDescription($lang = 'en_US') in /kunden/188616_52080/maninweb/business/modules/MovedPages/MovedPages.module.php on line 416

Strict Standards: Declaration of News::GetAdminDescription() should be compatible with CMSModule::GetAdminDescription($lang = 'en_US') in /kunden/188616_52080/maninweb/business/modules/News/News.module.php on line 740

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Strict Standards: Declaration of Search::GetAdminDescription() should be compatible with CMSModule::GetAdminDescription($lang = 'en_US') in /kunden/188616_52080/maninweb/business/modules/Search/Search.module.php on line 268

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Strict Standards: Non-static method PageInfoOperations::LoadPageInfoByContentAlias() should not be called statically in /kunden/188616_52080/maninweb/business/index.php on line 237

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/classes/class.contentoperations.inc.php on line 73

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/classes/class.contentoperations.inc.php on line 559

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/Tree/Tree.php on line 288

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/Tree/Tree.php on line 299

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/Tree/Tree.php on line 315

Deprecated: Function split() is deprecated in /kunden/188616_52080/maninweb/business/lib/classes/class.contentoperations.inc.php on line 917

Strict Standards: Non-static method Events::SendEvent() should not be called statically in /kunden/188616_52080/maninweb/business/index.php on line 360

Strict Standards: Non-static method Events::ListEventHandlers() should not be called statically in /kunden/188616_52080/maninweb/business/lib/classes/class.events.inc.php on line 104

Warning: Cannot modify header information - headers already sent by (output started at /kunden/188616_52080/maninweb/business/include.php:73) in /kunden/188616_52080/maninweb/business/index.php on line 362
Maninweb.de - Professional Excel Solutions
Deprecated: Function ereg_replace() is deprecated in /kunden/188616_52080/maninweb/business/plugins/function.stylesheet.php on line 104
Sitemap  · Français  · English  · Deutsch
Home » Blog » Article

Deprecated: Function ereg_replace() is deprecated in /kunden/188616_52080/maninweb/business/plugins/function.title.php on line 35
Article

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/classes/class.useroperations.inc.php on line 51

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/classes/class.useroperations.inc.php on line 84

Deprecated: Assigning the return value of new by reference is deprecated in /kunden/188616_52080/maninweb/business/lib/classes/class.useroperations.inc.php on line 182

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154


Strict Standards: Non-static method Events::SendEvent() should not be called statically in /kunden/188616_52080/maninweb/business/plugins/prefilter.precompilefunc.php on line 84

Strict Standards: Non-static method Events::ListEventHandlers() should not be called statically in /kunden/188616_52080/maninweb/business/lib/classes/class.events.inc.php on line 104

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /kunden/188616_52080/maninweb/business/lib/smarty/Smarty_Compiler.class.php on line 270

Strict Standards: Non-static method Events::SendEvent() should not be called statically in /kunden/188616_52080/maninweb/business/plugins/postfilter.postcompilefunc.php on line 84

Strict Standards: Non-static method Events::ListEventHandlers() should not be called statically in /kunden/188616_52080/maninweb/business/lib/classes/class.events.inc.php on line 104
Comparison and function list of Excel 2010, 2007 and 2003

16.01.2010
Some people from my english speaking audience asked me a few days ago, if it may be possible to translate my german article published on 11/27/2009 about the comparison between the functions included in Excel 2003, 2007 and 2010. The file listing the functions of the different Excel versions is also presetted to English and can be downloaded at the end of this article. Below a screenshot from the worksheet:

Office 2010 Plus Functions


Strict Standards: Non-static method Events::SendEvent() should not be called statically in /kunden/188616_52080/maninweb/business/plugins/prefilter.precompilefunc.php on line 84

Strict Standards: Non-static method Events::ListEventHandlers() should not be called statically in /kunden/188616_52080/maninweb/business/lib/classes/class.events.inc.php on line 104

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /kunden/188616_52080/maninweb/business/lib/smarty/Smarty_Compiler.class.php on line 270

Strict Standards: Non-static method Events::SendEvent() should not be called statically in /kunden/188616_52080/maninweb/business/plugins/postfilter.postcompilefunc.php on line 84

Strict Standards: Non-static method Events::ListEventHandlers() should not be called statically in /kunden/188616_52080/maninweb/business/lib/classes/class.events.inc.php on line 104
Well, in the following I will describe, how I got the functions names of Excel for the three languages listed below. First, I created a Excel 2003 workbook and then I manually inserted and categorized all available functions in German. Then I openend this workbook in Excel 2007 and I added all additional functions. I repeated this step with Excel 2010. To get the english and french names of the functions, the multilanguage versions of Office are needed. For Office 2003, you may install the english version and then add more languages by using the Office 2003 MUI version. For Office 2007, it is a little bit easier; you just may purchase the appropriate language packs and the install them. At the time, I wrote the german article, the language packs for Office 2010 were not available yet. So, I installed the three version in different virtual machines. When opening the Excel file in different language versions of Excel, the used formulas are translated automatically. The followingb table list all new functions of Excel 2010 compared to Excel 2007 in English, French and German.

English French German
Date & Time
NETWORKDAYS.INTL NB.JOURS.OUVRES.INTL NETTOARBEITSTAGE.INTL
WORKDAY.INTL SERIE.JOUR.OUVRE.INTL ARBEITSTAG.INTL
Math. & Trig.
CEILING.PRECISE PLAFOND.PRECIS OBERGRENZE.GENAU
FLOOR.PRECISE PLANCHER.PRECIS UNTERGRENZE.GENAU
Engineering
ERF.PRECISE ERF.PRECIS GAUSSF.GENAU
ERFC.PRECISE ERFC.PRECIS GAUSSFKOMPL.GENAU
Statistical
BETA.DIST LOI.BETA.N BETA.VERT
BETA.INV BETA.INVERSE.N BETA.INV
BINOM.INV LOI.BINOMIALE.INVERSE BINOM.INV
BINOM.VERT BINOM.DIST LOI.BINOMIALE.N
CHISQ.DIST LOI.KHIDEUX.N CHIQU.VERT
CHISQ.INV LOI.KHIDEUX.INVERSE CHIQU.INV
CHISQ.INV.RT LOI.KHIDEUX.INVERSE.DROITE CHIQU.INV.RE
CHISQ.TEST CHISQ.TEST CHIQU.TEST
CHISQ.DIST.RT LOI.KHIDEUX.DROITE CHIQU.VERT.RE
CONFIDENCE.NORM INTERVALLE.CONFIANCE.NORMAL KONFIDENZ.NORM
CONFIDENCE.T INTERVALLE.CONFIANCE.STUDENT KONFIDENZ.T
COVARIANCE.P COVARIANCE.PEARSON KOVARIANZ.P
COVARIANCE.S COVARIANCE.STANDARD KOVARIANZ.S
EXPON.DIST LOI.EXPONENTIELLE.N EXPON.VERT
F.DIST LOI.F F.VERT
F.DIST.RT LOI.F.DROITE F.VERT.RE
F.INV INVERSE.LOI.F.N F.INV
F.INV.RT INVERSE.LOI.F.DROITE F.INV.RE
F.TEST F.TEST F.TEST
GAMMA.DIST LOI.GAMMA.N GAMMA.VERT
GAMMA.INV LOI.GAMMA.INVERSE.N GAMMA.INV
GAMMALN.PRECISE LNGAMMA.PRECIS GAMMALN.GENAU
HYPGEOM.DIST LOI.HYPERGEOMETRIQUE.N HYPGEOM.VERT
LOGNORM.DIST LOI.LOGNORMALE.N LOGNORM.VERT
LOGNORM.INV LOI.LOGNORMALE.INVERSE.N LOGNORM.INV
MODE.MULT MODE.MULTIPLE MODUS.VIELF
MODE.SNGL MODE.SIMPLE MODUS.EINF
NEGBINOM.DIST LOI.BINOMIALE.NEG.N NEGBINOM.VERT
NORM.DIST LOI.NORMALE.N NORM.VERT
NORM.INV LOI.NORMALE.INVERSE.N NORM.INV
NORM.S.DIST LOI.NORMALE.STANDARD.N NORM.S.VERT
NORM.S.INV LOI.NORMALE.STANDARD.INVERSE.N NORM.S.INV
POISSON.DIST LOI.POISSON.N POISSON.VERT
PERCENTILE.EXC CENTILE.EXCLURE QUANTIL.EXKL
PERCENTILE.INC CENTILE.INCLURE QUANTIL.INKL
PERCENTRANK.EXC RANG.POURCENTAGE.EXCLURE QUANTILSRANG.EXKL
PERCENTRANK.INC RANG.POURCENTAGE.INCLURE QUANTILSRANG.INKL
QUARTILE.EXC QUARTILE.EXCLURE QUARTILE.EXKL
QUARTILE.INC QUARTILE.INCLURE QUARTILE.INKL
RANK.AVG MOYENNE.RANG RANG.MITTELW
RANK.EQ EQUATION.RANG RANG.GLEICH
STDEV.P ECARTYPE.PEARSON STABW.N
STDEV.S ECARTYPE.STANDARD STABW.S
T.DIST LOI.STUDENT.N T.VERT
T.DIST.RT LOI.STUDENT.DROITE T.VERT.RE
T.DIST.2T LOI.STUDENT.BILATERALE T.VERT.2S
T.INV LOI.STUDENT.INVERSE.N T.INV
T.INV.2T LOI.STUDENT.INVERSE.BILATERALE T.INV.2S
T.TEST T.TEST T.TEST
VAR.P VAR.P.N VAR.P
VAR.S VAR.S VAR.S
WEIBULL.DIST LOI.WEIBULL.N WEIBULL.VERT
Z.TEST Z.TEST G.TEST

As you can see in the table above, many new functions have been added for statistical purposes, some new functions are available for the other categories. As some of the new statistic functions are just replacing previous functions, the older versions have been moved to the categorry "Compatibility" for ensuring compatibility with previous versions of Excel. Below a table with the moved functions:

English French German
Compatibility
BETADIST LOI.BETA BETAVERT
BETAINV BETA.INVERSE BETAINV
BINOMDIST LOI.BINOMIALE BINOMVERT
CHIDIST LOI.KHIDEUX CHIVERT
CHIINV KHIDEUX.INVERSE CHIINV
CHITEST TEST.KHIDEUX CHITEST
CONFIDENCE INTERVALLE.CONFIANCE KONFIDENZ
COVAR COVARIANCE KOVAR
CRITBINOM CRITERE.LOI.BINOMIALE KRITBINOM
EXPONDIST LOI.EXPONENTIELLE EXPONVERT
FDIST LOI.F FVERT
FINV INVERSE.LOI.F FINV
FTEST TEST.F FTEST
GAMMADIST LOI.GAMMA GAMMAVERT
GAMMAINV LOI.GAMMA.INVERSE GAMMAINV
HYPGEOMDIST LOI.HYPERGEOMETRIQUE HYPGEOMVERT
LOGINV LOI.LOGNORMALE.INVERSE LOGINV
LOGNORMDIST LOI.LOGNORMALE LOGNORMVERT
MODE MODE MODALWERT
NEGBINOMDIST LOI.BINOMIALE.NEG NEGBINOMVERT
NORMDIST LOI.NORMALE NORMVERT
NORMINV LOI.NORMALE.INVERSE NORMINV
NORMSDIST LOI.NORMALE.STANDARD STANDNORMVERT
NORMSINV LOI.NORMALE.STANDARD.INVERSE STANDNORMINV
PERCENTILE CENTILE QUANTIL
PERCENTRANK RANG.POURCENTAGE QUANTILSRANGtd>
POISSON LOI.POISSON POISSON
QUARTILE QUARTILE QUARTILE
RANK RANG RANG
STDEV ECARTYPE STABW
STDEVP ECARTYPEP STABWN
TDIST LOI.STUDENT TVERT
TINV LOI.STUDENT.INVERSE TINV
TTEST TEST.STUDENT TTEST
VAR VAR VARIANZ
VARP VAR.P VARIANZEN
WEIBULL LOI.WEIBULL WEIBULL
ZTEST TEST.Z GTEST

If I compare the functions of Excel 2010 Beta with the Technical Preview of Excel 2010, it seems that the function FLOOR.PRECISE has been added and ISO.CEILING has been renamed to CEILING.PRECISE. I will test some of the new functions in further articles, an article describing the new functions NETWORKDAYS.INTL and WORKDAY.INT has already been published here: „Networkdays.Intl() and Workday.Intl() in Excel 2010“.

Finally, you can download the workbook including the list of all available functions in Excel 2010 here. The workbook also allows to setup the primary language for displaying the functions. Please note, if you change the language, the calculation may take some moments. And also please note, that we don't give any warranty for the correctness of the informations. If you find an error, it would be great, if you can inform me.






Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154

Warning: Parameter 1 to cms_module_Lang() expected to be a reference, value given in /kunden/188616_52080/maninweb/business/lib/classes/class.module.inc.php on line 2154