Search this site: Custom Search

Have you ever tried to use an Excel function or an Excel formula in your spreadsheet that just won't work? It's so frustrating when you know that a simple Excel function or formula can be used to perform your task, but you just can't figure it out!

Before you fork out all your hard-earned cash on expensive Excel training courses ... or worse still, 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 useful 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. There is also a section on typical Excel Errors that you may encounter. We will also, of course, show you how to fix these errors!

The site also contains a section on Excel Formulas (or Excel Formulae), that explains the rules of combining Excel Functions with Operators. This section will also provide you with examples of simple functions and tips that will help you to perform the most complex tasks with the minimal effort.

For beginners, our Basic Excel pages will give you a strong understanding of the basics that are needed to make the most of 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 both Microsoft Excel 2003 and Microsoft Excel 2007. If you are currently using the 2003 version of Microsoft Office, and would like to try Microsoft Office 2007, a free trial can be downloaded from 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, within 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!