- Getting to know about Google Sheet Template
- Working With Google Sheet Functions & Formulas
- – Conditional Formatting (Create, Copy and Find Duplication)
- – Working with Counting function (COUNT, COUNTIF, COUNTA, COUNTBLANK)
- – Data Protection function (WORKSHEET, RANGE, CELL PROTECT)
- – Others function (DATA VALIDATION, NAMED RANGES, SPLIT )
- Supercharge your Google Sheets data
- – Consolidate Data from Multiple Spreadsheet & Linking Worksheets (IMPORTRANGE)
- – Working with IF function(IF, NESTED IF, IFERROR, IF with AND, IF with OR statement)
- – Filter data for specific data extraction (FILTER, SORT, UNIQUE)
- – Working with Lookup function (VLOOKUP, HLOOKUP, LOOKUP, INDEX, MATCH)
- – Retrieving Data with Google Function (QUERY, ARRAYFORMULA)
- Presenting your Google Sheets data
- – Data Slicer
- – Pivot Table
- – Chart
- Recap
- FAQ
