Input data from the web

Hey all

I'm an amateur investor and saw someone on a meeting with the most awesome Excel tool to manage his stocks.
The guy was able to download real time info straight from the web into excel, not using the standard 'stocks' option in the data tab.
Somehow he was able to gather data straight from the website and able to drag down the functions when he input a new ticker (stock abbreviation).
Het got his info from this kind of webpage, I'll take Microsoft as example: //finance.yahoo.com/quote/MSFT/key-statistics

He was able to get data in that Excel doesn't offer in its standard 'stocks' option.

Anyone who know how to do this?
I've put an example in attachment.

Thnx in advance