Scrape data from Wikipedia to a Google sheet

Do you ever have Wikipedia data you need in a spreadsheet? Using Google Sheets you don’t have to copy and paste. Instead, use the ImportHTML function in Google Sheets and get the data from Wikipedia. Scraping data can save you tons of time. Copy and paste...
Vlookup vs Index and Match in Excel

Vlookup vs Index and Match in Excel

Vlookup is a great function. Most Excel users would have it in their top 10 function list. VLOOKUP is a lookup and reference function. If you are trying to find things in a table or a range by row Vlookup is a great function to use. Two other functions when joined...

Pin It on Pinterest