Formulas are a very important part of advanced Excel usage. A formula is like a calculation: one or multiple instructions that can be executed by Excel to lead to an output. In Excel, all formulas start with an equals sign = .
Try it out
Try writing
=10+5In cell A1 in the spreadsheet editor below.
Spreadsheet editor
Nicely done! You now know how to use a formula in Excel! You can also subtract (using – ), multiply (using * ) and divide (using / ) in the same way.
Using arithmetic is fun and all, but the formulas in Excel become even more powerful if you know how to integrate them with the data in the cells. We will get to that in the next lesson. Continue with the COUNT function.
Using arithmetic is fun and all, but the formulas in Excel become even more powerful if you know how to integrate them with the data in the cells. We will get to that in the next lesson. Continue with the COUNT function.
Finish the above exercise to continue to the next lesson.