Formulas are the heart of Excel. With huge list of built-in formula and functions, Excel stands out from other datasheet handling applications. Formulas are used for calculating/analyzing data based on values in designated cells. It supports trigonometric, statistical and other functions. You can also create a new rule, or constraint to apply over your datasheet. This post covers writing formulas and applying conditional formatting on a basic level.
For Instance: We will start off with creating simple worksheet of students, which includes; Name of the student, and obtained Marks in their respective courses.
