Working with Formulas, Functions, and Data
Introduction to working with formulas and functions
Introduction to working with formulas and functions
1. Introduction to working with formulas and functions.mp4Insert and edit a formula or function
Insert and edit a formula or function
2. Insert and edit a formula or function.mp4Use the SUM function
Use the SUM function
3. Use the SUM Function.mp4Use the AVERAGE function
Use the AVERAGE function
4. Use the AVERAGE Function.mp4Use the COUNT function
Use the COUNT function
5. Use the COUNT Function.mp4Use the MIN function
Use the MIN function
6. Use the MIN Function.mp4Use the MAX function
Use the MAX function
7. Use the MAX Function.mp4Use the UNIQUE function to discard duplicate data
Use the UNIQUE function to discard duplicate data
8. Use the UNIQUE Function to discard duplicate data.mp4Use the SORT function to automatically sort data
Use the SORT function to automatically sort data
9. Use the SORT Function to automatically sort data.mp4Use the FILTER function to filter data
Use the FILTER function to filter data
10. Use the FILTER Function to filter data.mp4Use the QUERY function to search for data
Use the QUERY function to search for data
11. Use the QUERY Function to search for data.mp4Use the IMPORTRANGE function to import data from another spreadsheet
Use the IMPORTRANGE function to import data from another spreadsheet
12. Use the IMPORTRANGE Function to import data from another spreadsheet.mp4Use the COUNTIF function
Use the COUNTIF function
13. Use the COUNTIF Function.mp4Use the IF function
Use the IF function
14. Use the IF function.mp4Use multiple functions in the same cell
Use multiple functions in the same cell
15. Use multiple functions in the same cell.mp4Reference data from other sheets
Reference data from other sheets
16. Reference data from other sheets.mp4Give a name to a range of data
Give a name to a range of data
17. Give a name to a range of data.mp4Analyze data with pivot tables
Analyze data with pivot tables
18. Analyze data with pivot tables.mp4Show data trends in a cell
Show data trends in a cell
19. Show data trends in a cell.mp4Google Finance function
Google Finance function
20. Google Finance function.mp4Google Translate function
Google Translate function
21. Google Translate function.mp4Google Image function
Google Image function
22. Google Image function.mp4VLookUp function
VLookUp function
23. VLookUp Function.mp4Assign your preferred language to functions
Assign your preferred language to functions
24. Assign your preferred language to functions.mp4