Have you ever tried to use an Excel function or an Excel formula but been unable to get it to work? It's so frustrating when you know there's a simple solution to your spreadsheet problem, but you just can't figure it out!

Before you take out your frustrations on your poor old computer ... WAIT! ...

... Help is at hand!

ExcelFunctions.net aims to solve all the problems that you have when using Excel functions and formulas. The information on this site will help you to use Excel formulas and functions to 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 most commonly used Built-In Functions, including examples of how to use the functions, along with tips and solutions to common errors. The site also provides advice on Excel Errors, that will help you to diagnose you error messages and, of course, help you to fix these errors!

The site also contains a section on Excel Formulas (or Excel Formulae), a term which is used to describe any combination of Excel Functions and Operators, and for the more advanced user, there is a section on Excel Array 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 Excel spreadsheet formulas. You will also find a number of Excel Tips and Tricks that, once discovered, you'll wonder how you ever managed without!

The examples on this site are illustrated using 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 (opens in a new window).

Finally, for those who want to take their Excel 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 cases when Excel does not have a suitable built-in function. With practice, writing Excel macros will become a natural part of your spreadsheet development, enabling you to develop the most professional-looking spreadsheets, that are actually quite simple to produce ...

... once you know how!