Help with

This website has been created to provide help with

Excel provides us with many Built-In Functions, that are designed to perform specific calculations. These are listed in the 'Formulas' menu of the Excel ribbon (see below).

Excel Built-In Functions Menu

This website provides information and examples of each of the Built-In Functions and also shows you how to combine these functions with each other, and with the Mathematical Operators (+, -, *, /, etc.), to create Excel Formulas.

There is also a section explaining Excel Array Formulas, which is essential reading for some of the more complex (but most useful)

For beginners, our Basic Excel pages provide a strong understanding of the basic Excel features, which will help you to get the best use of 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.

Most of the examples on this site will work in all versions of Excel. However, some of the built-in functions are only available in the more 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 .

Related pages

loan amortisation spreadsheet6 degrees to radiansvba excel dirvisual basic dim arrayexcel count duplicate valuesexponential distrandom number generator with decimalshow to extend trendline in excelmillimeters to feet converterweight loss progress charthow do you use average function in excelreturn on investment formula excelmetric conversion sq meters to sq feetnested iif accessinvtanmonthly activity calendar templatecorrelation calculation excelcalculating mortgage payment in excelexcel hyperlinkquart to cubic feetvba excel inputboxhow to calculate modalexcel compound formulasubtract function in excelsumif datemonth at a glance blank calendar templatehow to tally in excelconversion from decimal to hexadecimalmil to mm conversion formulaexcel integersquare meter square feet conversioncosine of 45 degreesmacro hyperlinkformulas for calculating percentagesexcel probability density functionformula for interest compounded yearlyexcel copy worksheetexcel vba sample codenet present value of annuity calculatorvlookup datesexcel shortcut select columnexact formula in excelhow to transpose table in excelhow to copy and paste using ctrldepreciation ddbnpv calculation in excelexcel slope functionconvert minutes to hours and minutes in excelrepayment mortgage formulareturn array in vbahow to do vlook upnegative skewnesshow to multiply numbers in excelexcel functions by categoryhow to combine cells in excellower quartilesexcel hyperlink to websiteconvert liters to meters cubedcreate invoices from excel spreadsheetexplain macros in excelassign a macro to a button in excelexcel skip weekendsexcel annual calendar templateexcel vba substringcentimeters to poundshow do you convert minutes to decimalsexcel engineersconverter m2 to m3amortization worksheetmicrosoft excel functions tutorialexcel 2010 iserrorconvert metres to square feetexcel pv formulacreate calendar from excel spreadsheet