Productivity & Collaboration Tools     Google     Google Apps     Google Sheets 2020

---

Google Sheets includes built-in formulas to extract and analyze data. Discover how to work with some of these formulas on both numeric and text values, and how to use LOOKUP and VLOOKUP.

---

---

Objectives

Google Sheets: Using Formulas to Obtain Data identify data entries with formulas use formulas to find information about dates use formulas to display and retrieve information about data entries find the largest and smallest values separate data into different cells combinate data from different cells compare two lists with the VLOOKUP function use the HLOOKUP function to insert data identify and highlight errors in formulas