Excel

Spreadsheets (Excel)

1.  Import: .csv
   csv=comma separated value
    standardized format
    txt file

2. Absolute and relative cell references
    relative= in C1 write: A1 + B1=2
                 means it changes formula depending from where you paste it
    aboslute: will refer to that cell even if you copy and past formula


3. Named cells, named ranges
   named cells=makes reading formulas easier
                      is an absolute reference
   named range=naming a group of cells

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

5. filter (perform searches using AND, OR, NOT, LIKE, >, <, =, >=, <=
          filtering searches like google

6. perform searches using wildcard means *