Help with Excel Functions and Formulas

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

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

... Help is at hand!

ExcelFunctions.net aims to clear up all the difficulties that you may be having with Excel formulas and functions. The information on this site will help you to use Excel spreadsheet formulas and functions to transform your basic spreadsheet into a useful working document that 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 function, and typical Excel Problems that you may encounter. It also, of course, shows you how to fix these problems!

The site also contains a section on Excel Formulas, that will show you rules of combining Excel Functions and 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 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 are mentioned in the text. 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. 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!