Check List (Syallbus)
Hodders AS Level Book: pg157
Done
- basics
- SUM function
- AVERAGE function
- MAX function
- MIN function
- ROUND function
- ROUNDUP function
- ROUNDDOWN function
- COUNT function
- COUNTA function
- COUNTIF function
- COUNTIFS function
- SUMIF function
- SUMIFS function
- AVERAGEIF function
- AVERAGEIFS function
- MAXIFS function
- INDEX function
- MATCH function
- LEFT function
- RIGHT function
- MID function
- LEN function
- FIND function
- ISTEXT function
- ISNUMBER function
- ISNONTEXT function
- UPPER function
- LOWER function
- EXACT function
- CODE function
- CHAR function
- DEC2BIN function
- DEC2HEX function
- BIN2DEC function
- BIN2HEX function
- HEX2BIN function
- HEX2DEC function
- WEEKDAY function
- DAY function
- MONTH function
- YEAR function
- HOUR function
- MINUTE function
- SECOND function
- DATEDIF function
- MEDIAN function
- MODE function
- SUBTOTAL function
- IF function (pg182)
- Nested IF functions (pg188)
- IFS function
- ISERROR function
- IFERROR
- LOOKUP function
- HLOOKUP function
- VLOOKUP function
- XLOOKUP function
Done but not in note
- Edit spreadsheet structures
- Merging cells
- Wrapping text
- Display formulae
- Create formulae (Mathematical operators)
- Using absolute and relative cell references (pg173)
- Name Manager (of cell range references)
- INT function
To-Do
-
importing csv
-
page structure, margings and customizations (when printing)
-
Displaying gridlines, row and column headings
-
Protecting cells and their contents
-
Split window and freeze panes
-
Freeze and unfreeze panes
-
Validation Rules (pg206)
-
Cell Formatting
-
Conditional Formatting
-
Search using text filters
-
Search using numeric data
-
Search using substrings
-
Sort data
-
Pivot tables
-
Pivot charts
-
Export in portable document format
-
Macros
-
Pie charts
-
Bar charts
-
Line graphs
-
Create a chart
-
Export graphs and charts
-
what if analysis (pg261)
-
Goal Seek