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

If you select a function from the menu, it will automatically be inserted into your spreadsheet, where you will be prompted to enter any required arguments.

This website provides information and examples of each of the Excel Built-In Functions and examples of how to perform popular tasks using a combinations of these functions and/or 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.

The examples on this site mostly apply to all versions of Excel, from 2003 onwards. However, some of the built-in functions are only available in the most 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

sine table for anglesinverse tangent calclogarithmic formula sheetexcel filter in formulapoisson probability equationbell curve template excel 2010weight watchers tracker spreadsheetms excel 2007 formulas with examples pdf free downloadft to m2 conversionallow macros in excelexcel net present value formulatemplate spreadsheet excelbirthday calculationsabsolute cell referenceb10 valuesample correlation coefficient excelfunction return vbacos pi over 2merge columns excelwhere is the average function in excel 2010vba write formula to celllognormal distribution calculatorexcel cdfexamples for vlookup in exceladvance formula in excelexcel template monthly budgetcount of cells in excelloan amortization schedule excel 2007t-test paired two sample for means excelexcel count functionscompound future value calculatorconverting ft3 to m3convert cubic meter to cubic inchescountif on excelexcel remove doublesweibull verteilungformula creation in excelms excel tutorials with exampleshow to unhide in excel 2013not iserrorweekend calendar templatefinancial calculator amortizationexcel formula cell valuehow to calculate cosine of an angleexcel tutorials 2007formula of quartile deviationannually compounded interest formulaisna netnote amortization schedule excelsum if andwhat is compatibility mode in excelhow to calculate birth date in excelsales invoice template excel free downloadiif excel functioncreating an excel spreadsheet with formulasconversion kn to mpaconvert birthdate to age in excelsine of an angle calculatornot equal sign in vb.netdifference between sorting and filtering in excelvba drop down listexcel percentilecolor grid worksheetscall excel function in vbahow to use sumifs in excel 2013travel plan template excelhome budgeting spreadsheetbeginners excel traininghow to write vba code in excelpercentages on calculatorcomplex excel formulasexcel auto enable macroscolumn formula excelexcel annuity payout calculatorunmerge excel