Home

How to Make calculations in Excel with formulas & references

May 5, 2010 04:00 PM

Excel spreadsheet demonstrating formulas for arithmetic calculations and averages.

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to make calculations in Excel using formulas and cell references. Learn about the different Excel Math operators and functions that you can use in Formulas.

You will see five types of formulas:

1) Formulas with cell references and operators

2) Formulas with functions

3) Formulas with functions and operators

4) TRUE / FALSE formulas

5) Text formulas

You already know how to use your phone. With Gadget Hacks' newsletter, we'll show you how to master it. Each week, we explore features, hidden tools, and advanced settings that give you more control over iOS and Android than most users even know exists.