Anmol BansalinTowards Data ScienceINDEX-MATCH — An upgrade on VLOOKUP functionsMaster one of the most versatile functions of SpreadsheetsAug 17, 2020Aug 17, 2020
Anmol BansalinTowards Data ScienceHow to use the notorious VLOOKUP function in Google Sheets?And how to overcome the various challenges it poses.Aug 5, 2020Aug 5, 2020
Anmol BansalinAnalytics VidhyaHarnessing the power of Pivot Tables in Google SheetsOne of the first steps to analyze any data is to summarize it and get the basic overview of what your data is saying. There are numerous…Jul 25, 20202Jul 25, 20202