Monday, April 24, 2017

How to check motherboard specifications

1. Go to cmd 2. At the command prompt (e.g. C:\>), type and enter: wmic baseboard get product,Manufacturer,version,serialnumber

Sunday, April 23, 2017

How to Change your Wi-Fi Name

1. Go to the command prompt. The easy way is to hit your Windows button, type CMD, then hit Enter. 2. At the command prompt (e.g. C:\>), type and enter: ipconfig 3. Note down the IP address for "Default Gateway". Example of an IP address: 192.123.0.1 4. Type and enter that IP address into your browser's address bar. 5. Enter the username and password to access the router's dashboard. 6. Go to Settings > Wireless > Change SSID (Wifi name) 7. Enter your new wifi name (e.g. GetCashBack.my) and SAVE 8. Reset (or Turn OFF then ON) your router. 9. Create a new Connection on your device. Select the new Wi-Fi name, then re-enter the old wifi password (it wasn't changed). Hit Connect.

Sunday, April 9, 2017

How to find things in Excel

Search the range A1 to A10 for the first cell which contains text, and show that text
=hlookup("*",A1:A10,1,false)



Tuesday, April 4, 2017

How to get the image URL of any website



1. Right-click on any image (ensure there is no transparency over it; if there is, remove it first)
2. Select "Inspect element"
3. Under the "Elements" tab, a certain section of the HTML code is highlighted. Go to the subtab "Styles"
4. Under the "Styles" subtab, look for background-image: url(xxx). Right-click on the xxx, then pick "open link in new tab".

Popular Posts