Excel

import: .csv = Comma Separated Values, Is a standardized format so it can be read by everyone.

Absolute and Relative references = A1 is a cell reference = Relative References: When the formula changes  when you copy paste. Absolute cell referencing will absolutely always refer to that cell even if you copy and paste.

Named Cells = A named cell is an absolute reference. Another way of doing absolute reference.

Named Range = Naming a range of cells e.g Class Marks. Is an automatic relative reference. Makes reading formulas easy.

Sum, Average, Maximum, Minimum, Integer, Rounding Counting, If, Look up.

Filtering AND, OR, NOT, LIKE - is like a Google search, cuts down options.

Wildcard - actually is a star when your searching, is kind of like the word anything. Broadens searches.


IMPORTANT!!! - ALWAYS SAVE AS EXCEL WORKBOOK