I've managed to get to the bottom of the problem on my Dell laptop.
I have tried everything mentioned in this post and nothing worked, but eventually, I plugged USB HUB which allowed me to plug Ethernet cable and connect straight to the router. This enabled internet connection straight away and I was able to INSTALL WINDOWS OPTIONAL UPDATES. One of those updates was my network card driver, which solved the issue.
I hope this will help others