This video looks at the basic =inserthtml formula to link to a web site and look for a table or list and import it into your spreadsheet
This little video is an excellent overview of using some of the built in tools within Google Sheets to sort and analyse columns of data. Its marketing oriented, but the tools apply to all sorts of data and use
So how do your take this a little further and make new bespoke formula, this short video will help
This very excellent video looks at scraping very specific data from a web table and linking it into a google spreadsheet