Excel

These are required in the use of excel.

1. Import CSV- (comma separating values)

2. Absoulute and realative referances- A1 is cell referance.

Relative cell refernce is when it changes depending on where you paste it.

A aboslute reference is where its is absoluting always going to refer to that cell.

3. Named cells - makes reading cells easier

    Named ranges- naming a group of cells

4. Sum, average, maximum, minimum, integer, rounding, counting, if , lookup

5. perform searches using AND, OR , NOT, LIKE,  >,  < ,  = , >= , <=

  filtering searches like google.

6. Perform searches using wildcards