Vlookup Explained!

VLOOKUP(), the Vertical Lookup function, is very useful to sort through a large table of records and find values associated with any column to the RIGHT of your reference column.
For example, in a table of ID NUMBERS and AGE, you can type in an ID NUMBER and find the age of that person easily.
GENERAL SYNTAX is:

Apply Basic Formulas and Conditional Formatting

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.