How to use Google Sheets in Your Buinsess
- 1. COUNTIF() for Conditional Counting
- 2. TODAY() to update current date
- 3. TEXT() to convert numbers into currency
- 4. SPLIT() to divide data into multiple cells
- 5. SEARCH() Function to Check Value in a String
- 6. CONCATENATE() to Append Multiple Cells
- 7. VLOOKUP() for Vertical Lookup
- 8. IF() to Check Condition of a Logical Expression
- 9. IFERROR() to Return Cell Error Value
- 10. IMPORTRANGE() to Import a Range of Cells
- 11. IMPORTFEED() to Import an RSS or ATOM Feed
- 12. GROWTH() to predict the growing trend
- 13. SUBSTITUTE() to replace existing text
- 14. IMPORTXML() to import website data
- 15. REGEXEXTRACT() to extract substrings
- 16. TRANSPOSE() to transpose rows and columns
- 17. QUERY() to Run a Google Visualization API Query
- 18. ARRAYFORMULA() to Display of Values Returned
- 19. SUMIF() to add numbers in a range cell
- 20. SORT() to sort a range of cells
- Wrapping Up
