Help with Excel Functions and Formulas





This website provides help with Excel, with a particular focus on Excel functions and formulas.

You will find information and examples of each of the Excel Built-In Functions and examples of various Excel Formulas. There is also a section explaining Excel Array Formulas, which will help you to make full use of some of the most useful Excel functions and formulas.

For beginners, our Basic Excel pages will give you a strong understanding of the basic Excel concepts, which will help you to get the best use from Excel functions and formulas. There is also a section on Excel Errors which will help you to diagnose and fix any errors that you encounter.

Finally, for those who want to learn how to program their own functions in Excel, we have an Introductory Guide to Excel Macros and an Excel VBA Tutorial. With the help of our step-by-step guides, Excel macros will become a natural part of your spreadsheet development, enabling you to perform complex analysis and automate repetitive tasks.

The examples on this site generally apply to Microsoft Excel 2003, 2007, 2010 and 2013. However, some of the built-in functions are only available in the most recent versions of Excel. If you are currently using an older version of Microsoft Office, and would like to try the latest version, you can get a free trial on the Microsoft Office website.