By using the most suitable functions in your formulas, you will get the most accurate results possible, plus your Excel models will be easier to maintain and audit.

• Are you searching for a new function to simplify your formulas ? (Several added in 2013)
  
  
• Are you wondering, if a function is backwards compatible with previous Excel versions ?
  
  
• Are you looking for translated function help (besides English) ?

Do you want to read about the syntax and usage of an Excel 2013 or VBA function in your native language and practice with a demo workbook  ? 

The facts:

• There are over 600 Excel & VBA functions in Office 2013. 
• Excel functions have been translated in 16 languages. 
• Microsoft offers over 20,000+ function help webpages in 50+ languages. 
  
  

How to navigate fast among so many help pages ?

Our free Ribbon Add-in will help you navigate to Microsoft's online help pages with embedded workbooks, which can be downloaded to your computer for function inspection and in-depth practice.

• The VBA Add-in is unlocked and requires enabled macros. Read how to enable macros.
  
• The Ribbon Add-in works with Excel 2007, 2010, 2013 (both 32 & 64-bit Office)
• License: Creative Commons Attribution-ShareAlike CC-BY-SA (commercial use allowed)

Free - unlocked VBA - syntax & usage Addin for Excel / VBA 2013 functions (English version)

---

New functions are being added in Excel's library with every new Microsoft Office launch. The new functions can be used in the current version of Excel, but are incompatible with earlier Excel versions.

Some Statistical functions have been renamed so that they are more consistent with the function definitions of the scientific community and with other function names in Excel. 

If backward compatibility is required, you can run the Compatibility Checker, so that you can make the necessary changes in your worksheet to avoid errors.

An icon next to a function name indicates the Excel version in which the function was first added or renamed.

---

New Functions In Excel 2016

Only 5 new forecasting functions are introduced in Excel 2016. The new functions are in the Statistical category (Formulas tab>More Functions>Statistical) and can be used to predict future values based on historical data:

• FORECAST.LINEAR
• FORECAST.ETS
• FORECAST.ETS.SEASONALITY
• FORECAST.ETS.CONFINT
• FORECAST.ETS.STAT

---

Download Translated Ribbon Add-ins

Excel Functions

Click flag to download the free VBA Add-in in English

Funções do Excel

Clique na bandeira para baixar gratuitamente o suplemento VBA em Português do Brasil

Funzioni di Excel

Click sulla bandiera per scaricare l'Add-in gratuito in lingua Italiana

Συναρτήσεις Εxcel

Επιλεξτε τη σημαία για να κατεβάσετε το δωρεάν VBA πρόσθετο στα Ελληνικά

Excel 函数

点击按钮下载中文版免费VBA插件

---

VBA Code (Unlocked)

Option Explicit
 
' (c) www.spreadsheet1.com
' ------------------------
' License: Creative Commons Attribution-ShareAlike CC-BY-SA
' http://creativecommons.org/licenses/by-sa/4.0/legalcode
 
' Please feel free to remix, tweak & build upon this work, even for commercial purposes, as long as:
 
' 1) www.Spreadsheet1.com & www.RibbonCommander.com are credited.
' 2) New creations are licensed under identical terms.
' 3) Add-in is freely distributed ** NOT intended for sale **
 
Sub CategoryBtn_OnAction(control As IRibbonControl)
 
    Dim sLink As String
     
    On Error GoTo ErrHandler
     
    sLink = "http%3A%2F%2Foffice.microsoft.com%2Fen-us" & _
            "%2Fexcel-help%2Fexcel-functions-by-category-HA102752955.aspx%23_Toc3093067" & _
            Format(CStr(5 + Val(control.Tag)), "00")
     
            Application.ThisWorkbook.FollowHyperlink sLink
Exit Sub
     
ErrHandler:
    MsgBox "The function category webpage" & vbCrLf & _
           "cannot be launched due to a web error or" & vbCrLf & _
           "due to a temporarily unavailable service.", vbCritical, "Functions 2013 Demo"
End Sub
 
Sub NavigateToWebPage_OnAction(control As IRibbonControl)
 
    On Error GoTo ErrHandler
 
    Application.ThisWorkbook.FollowHyperlink control.Tag
     
Exit Sub
 
ErrHandler:
    MsgBox "The function webpage cannot be launched due to a web error" & vbCrLf & _
           "or due to a temporarily unavailable service.", vbCritical, "Functions 2013 Demo"
End Sub
 
Sub About_click(control As IRibbonControl, id As String, Index As Integer)
 
    On Error GoTo ErrHandler
 
    Select Case Index
        Case 0
            Application.ThisWorkbook.FollowHyperlink "http://www.spreadsheet1.com/excel-2013-translated-functions-free-addins.html"
        Case 1
            Application.ThisWorkbook.FollowHyperlink "http://www.ribboncommander.com"
    End Select
     
Exit Sub
 
ErrHandler:
    MsgBox "The webpage cannot be launched due to a web error or" & vbCrLf & _
           "due to a temporarily unavailable service.", vbCritical, "Functions 2013 Demo"
End Sub

---

Add-in Mirror Sites

OfficeSmart: Philippos Panagiotidis, Excel MVP
MyEngineeringWorld.net: Christos Samaras, PhD

---

Function Translations In A Single Multi-Lingual Add-in

Microsoft Office uses the default input language in the Windows operating system to determine the default language for Office programs. Excel's function names depend on the language installed.

Besides English, function names are available in 16 languages. Some examples are shown below:

COUNT Function

SUM Function

VLOOKUP Function

Language availability

Menus as shown in our dynamic multi-lingual Excel / VBA function navigation Add-in

---

Excel 2013 functions have been translated by Microsoft in Brazilian, Czech, Danish, German, Dutch, Spanish, French, Italian, Hungarian, Norwegian, Polish, Portuguese, Finnish, Swedish, Russian and Turkish.

Funções do Excel
Funkce aplikace Excel
Excel-funktioner
Excel-Funktionen

Excel-functies
Funciones de Excel
Fonctions Excel
Funzioni di Excel

Az Excel függvényeinek
Funksjoner i Excel
Funkcje programu Excel
Funções do Excel

Excelin funktiot
Excel-funktioner
Функции Excel
Excel işlevleri

---

comments powered by Disqus