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
