For those who use Google Sheets, you probably know that you can access additional formulas or functions. We will introduce 10 essential formulas: SUM, SUMIF, VLOOKUP, COUNT, AVERAGE, MAX/MIN, IF, CONCATENATE, TODAY, and UPPER/LOWER. We will show you how to use each function. In addition, we will introduce tricks for creating drop-down lists, multiplying quantities to find purchase prices, and using pivot tables for basic presentations. We will also cover customizable charts to suit your report needs.
#GoogleSheet #CalculationTable #GoogleSheetTutorial
Index
00:00:40 Introduction to 10 Formulas
00:14:15 Introduction to Multiplying Quantities to Find Prices
00:15:50 How to Use Drop-down Lists
00:18:30 How to Use Pivot Tables
00:19:40 How to Create Charts
Google Sheets Tutorial
https://www.mindphp.com/%E0%B8%9A%E0%...
By: https://www.mindphp.com/