ARTICLES

SUM, COUNT, CONCATENATE and LEN are some basic formulas to use in Excel. These are predefined formulas that perform operations within user-specified parameters or arguments. Formulas begin with the equal sign, enclose pa...

www.reference.com/article/basic-formulas-use-excel-e8b4cd3e9c5da752

Use of tutorials and guides that provide helpful instructions can help you learn to create Excel formulas, and practicing these spreadsheet tools reinforces the knowledge. Use a guide to Excel spreadsheet equations, such...

www.reference.com/article/can-learn-create-excel-formulas-181efe9c0a547939

To enter a basic formula in Excel, enter an equal sign into the cell where you want to place the formula. This signals to Excel that the following input is formula input. The formula itself varies depending on the type o...

www.reference.com/article/enter-formulas-excel-91efad5e73d0467c

SIMILAR ARTICLES

In Excel, the mean function is used to calculate the average of a set of numbers. The numbers used can come from any cell in an Excel spreadsheet by listing the cells involved into the average function box.

www.reference.com/article/mean-excel-4718c319f3d9a8cc

Microsoft offers a free training center for Excel as of 2015. The database includes courses for Excel on Windows, Mac OS, Android, iOS and Windows Phone. Alternatively, users can access a help database within Excel by pr...

www.reference.com/article/can-learn-use-excel-e7aff25e6cc2cd3f

To create a spreadsheet, open Excel and begin entering information into the cells. Save the spreadsheet to the hard drive by clicking File and Save. In Excel, every column has a capital letter at the top, and each row ha...

www.reference.com/article/create-spreadsheet-using-excel-577e8f3d1849452f

To find duplicates in Excel, select the data that needs to be searched, click on Conditional Formatting from the Home tab, create a new rule, and then format the rule for duplicate values. Select a format for the duplica...

www.reference.com/article/duplicates-excel-67fa3d31f1b1ae33