| SUM SUMIF SUMIFS |
| AVERAGE AVERAGEIF AVERAGEIFS |
| COUNT COUNTIF COUNTIFS |
| COUNTA |
| IF Nested IF Conditional IF |
| IFERROR error Handling |
| CLEAN TRIM |
| LENGTH |
| LEFT RIGHT |
| MID and Text to Columns |
| LOWER and UPPER CASE |
| PROPER CASE |
| TEXT |
| ROUND |
| ROUNDUP |
| ROUNDDOWN |
| ABS Absolute |
| POWER |
| SQRT Square Root |
| RAND |
| RANDBETWEEN |
| CEILING and FLOOR |
| MOD |
| SUBSTITUTE |
| REPT |
| SEARCH and FIND |
| CHOOSE |
| AND Operator |
| OR Operator |
| NOT Operator |
| XOR Operator |
| IFNA |
| IFS |
| VLOOKUP |
| HLOOKUP |
| XLOOKUP |
| MATCH |
| INDEX with MATCH |
| OFFSET |
| INDIRECT |
| ROW and COLUMN |
| ADDRESS |
| ROWS and COLUMNS |
| DATE TODAY |
| DATETIME NOW |
| DATEDIF |
| EDATE |
| EOMONTH |
| WORKDAY |
| NETWORKDAYS |
| EXTRACT DAY MONTH YEAR |
| EXTRACT HOUR MINUTES SECONDS |
| EXTRACT WEEKDAY WEEKNUM |
| CONCAT |
| TEXTJOIN |
| CHAR |
| CODE |
| VALUE |
| T |
| Normal Filter and FILTER Formula |
| SORT formula vs Manual sort |
| UNIQUE Formula vs Remove Duplicates Vs Highlight Duplicates |
| Multiple Sorts vs SORTBY |
| SEQUENCE |
| ARRAYFORMULA in Google Sheets |
| TRANSPOSE |
| MMULT |
| ISFORMULA |
| ISERROR |
| ISNA |
| ISBLANK |
| ISNUMBER |
| ISTEXT |
| ISLOGICAL |
| TYPE |
| SHEET vs SHEETS |
| SPARKLINE |
| HYPERLINK |
| Convert Data into Table Format |
| Table Slicers |
| PIVOT Table |
| Sort data, highlight duplicates and text to columns |
| Insert Blank Rows by GROUPING |
Best,
Rajiv Pujala
+91 7013699612
iamrajivpujala@gmail.com