Getting started with excel-formula – Installation or Setup

Detailed instructions on excel-formula(s).

There are many formulas that you can choose from. They are divided up into 7 different categories and are on the FORMULAS tab in Excel. The categories are:

  1. Financial
  2. Logical
  3. Text
  4. Date & Time
  5. Lookup & Reference
  6. Math & trig
  7. More Functions

Then there are also sections for

  1. Recently used
  2. AutoSum

If you are not sure which one to use you can use the Insert Function button to help with determining which one to use.

You do not have to use just one formula at a time, you can combine them to get the results that are needed or combine them with other things like Named Ranges.

Named Ranges are also on the FORMULAS tab in the Define Name section. You can use the Name Manager to create or modify the ranges and names of the ranges. There are also three other buttons there for Define Name to define and apply names, Use in Formula to choose a defined name and insert it into a formula, and Create from Selection which will create a named range with the name based on the top-left most cell in the range.

There is also the Formula Auditing section. This section will help in troubleshooting a formula. Here you can trace the formula and see what exactly it is doing.

Finally, there is the Calculation section which will allow you to turn on/off the automatic calculation of all formulas and to manually calculate any formulas whether auto-calculate is on or not.

if you want to reproduce, please indicate the source:
Getting started with excel-formula – Installation or Setup - CodeDay