| 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) |