Help with Excel Functions and Formulas
If you have a problem with an Excel function or formula, you have come to the right place!
ExcelFunctions.net has been produced to help you to learn all about, and to solve all your problems with Excel functions and formulas. With the help on this site, you will soon find that you are confidently using a wide range of Excel formulas and functions, that will transform your basic spreadsheet into a professional working document that automatically performs all your calculations - and looks great too!
There is a page dedicated to each of Excel's Built-In Functions, including information and examples of how to use the function, tips, and solutions to common errors. We have also created an Excel Vlookup Tutorial to assist those who want to learn more about this popular Excel function.
Many people use the terms 'Excel Functions' and 'Excel Formulas' interchangeably, but the term 'Excel Formulas' (or Excel Formulae) is a wider term, that generally refers any combination of Excel Functions and/or Operators. Therefore, we have included a separate section on Excel Formulas, that provides examples of how to perform popular tasks using a combination of functions and operators. There is also a section on Excel Array Formulas, which you need to understand if you want 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 Excel basics, that are needed to enable you to get the best use from your functions and formulas. There is a section on Excel Tips and Tricks to help you to work more efficiently with your spreadsheets, and a section covering Excel Errors which will help you to diagnose your error messages and, of course, to fix these errors.
The examples on this site use Microsoft Excel 2003, 2007 and 2010. If you are currently using an older version of Microsoft Office, and would like to learn more about Microsoft Office 2010, full details are given on the Microsoft Office Online website.
Finally, for those who want to take their skills to the next level, we have included an Introductory Guide to Excel Macros and an Excel VBA Tutorial, which covers the basics of the VBA programming language in Excel. In this section, we will show you how to create your own customised Excel function, for those occasions when there is no suitable built-in function. With practice, writing Excel macros will become a natural part of your spreadsheet development, enabling you to produce the most professional-looking spreadsheets, that are actually quite simple to produce ...
... once you know how!
