| 1. | What is a Function? | |
| 2. | Parameters | |
| 3. | Types of functions | |
| 4. | =If(cond,True,False) | |
| 5. | =indirect() | |
| 6. | =sum( ) | |
| 7. | =count( ) | |
| 8. | =counta( ) | |
| 9. | =mid(cell,start,len) | |
| 10. | =vlookup(cell,range,column,0) | |
| 11. | =match( ) | |
| 12. | =subtotal( ) | |
| 13. | =left(cell,# chars) | |
| 14. | =right(cell,# chars) | |
| 15. | =mid(cell,start,length) | |
| 16. | =len(cell) | |
| 17. | =text(now(),"ddd") - Gets day of week for passed date | |
| 18. | =countBlank(B:B) | |
| 19. | =And(Cond1, Cond2, ...Condn) - All must be True to be True otherwise False | |
| 20. | =Or(Cond1, Cond2, ... Condn) - One must be True to be True otherwise False | |
| 21. | =SumIfs( ) | |
| 22. | =Substitute( ) | |
| 23. | =Find( ) | |
| 24. | =Search( ) | |
| 25. | =ifna( ) - use with VLookup | |
| 26. | User defined functions | |
| 27. | =hyperlink(location,text to display) |