Computer & smartphone Tips Trick

To share Internet connection from Windows 10 laptop, you can do with easily because Windows 10 has the facility called Mobile hotspot.  Any of Internet connection you have on your Windows 10 laptop, modem, Lan cable, wifi, etc you can share using this Mobile hotspot. How to do : 1. Click  the network icon  located at System tray.

With USB power sharing function, you can use the USB port for charging your handphone/smartphone and any others, without switch on the laptop. Not all of laptops have this USB power sharing function. For the laptop that has this function, at default the function is still disable (generally). To know whether the laptop has USB power sharing function or not, and make it enable when it has: Enter to BIOS and look for options that are related to USB. Each laptop from different brand has different name for this function,    USB sleep and Charge, USB Charging, USB Power Share , etc.

At default setting in Windows , when you don't make activity for a specified time , not use the keyboard,  mouse, or touch screen, the display will off automatically. This function is useful for energy saving. You can find this setting is in the Power Options section. . There is a question : 'How to turn off the display directly/manually?, not wait for specified time..'. The answer:  You can use the Power button and configure it so that if pressed, it can turn off the display.

On Windows 10 store, when you want to install and already choose the app but there is no active install button and give the information like this :  'Powered by great new features in the lates Windows update. Get it now at https://aka.ms/winup'. What must you do? The button for installing is not active

How to create website shortcut in Android using Chrome. To create website/URL shortcut in Android and show it at home screen. 1. Run Chrome browser at your Android 2. Open the website that you want to create it's shortcut. 3. After the website is opened, tap the menu (3 vertical dots), then choose Add to Home screen .

At default, there is no Hibernate option when clicking  the Power button at Start menu in Windows 10. Only Sleep, Shutdown, and Restart. But don't worry, you can show it with easy steps To show Hibernate at Power Start menu : 1. Press Windows + R (to open Run Command) 2. Write  powercfg.cpl at Run command column, then click OK or hit Enter key.

Excel formula for counting number of male or female employees/students, etc. For this purpose you can use the Countif formula. How to use the formula : In the example I have a simple table with male (M) and female (F) gender. To count number of male (M) at cell B9 the formula is: =COUNTIF(B2:B7,"M")  (of course you have to change B2:B7 with the cells of yours)