Almost a Technocrat in Draft

This is how to enable Samsung Galaxy Note 4 to force use only 4G (LTE) network connection for high speed internet data. There is a built-in switch in the smartphone that will enable the smartphone to force use only either 3G (WCDMA) or 2G (GSM) network connection but, there is no switch at all to enable the smartphone to force use only 4G (LTE) network connection. Video Tutorial This is screen video record to show you how to do it. If you prefer screenshots, please skip this video and scroll after the video. Screenshots Tutorial If you are clueless about the existing settings that enable you to switch network mode, goto “Settings > More networks > Mobile networks > Network mode”. Steps: Step 1 : From the phone dialer, dial *#2263# and the smartphone will bring you into the “Service Mode” screen like below. Step 2 : Select “[4] LTE BAND PART1 []” and the smartphone will bring you into a screen to select the types of LTE mode. Step 3 : Select “[1] LTE ALL []” to force the smartp...

I keep forgetting how to boot my Asus EeePC 1005px from USB drive whenever I need to reinstall my Ubuntu Linux into the netbook. This is how to do it. During the BIOS boot-up screen, press ESC button and you will be presented with a boot device menu. Select the USB drive that you have already plugged in to your netbook and press enter. The boot device you selected is temporary and it's good for the purpose of reinstalling OS into the netbook. You don't have to change the boot order from the BIOS setup as the change is going to be permanent. By using the boot device selection menu, you can temporary set the boot device for that boot up only.

A list of useful links about D-Link DNS-320L ShareCenter Network Attached Server. DNS-320L at D-Link Forum D-Link DNS-320L at nas-tweaks.net D-Link UK Product Page D-Link DNS 320L Support Download Page

If you are planning of selling off your old hard disk drive (HDD) or even USB drive, you might need to do a secure delete of the contents of your old HDD. This will ensure all your personal data in your HDD is unrecoverable using data recovery software. The idea behind this secure deletion or erasure of your HDD content is basically overwriting every bytes of your disk drive with either zeros or random data. This way, whoever that tries to recover the data, they will only see zeros or gibberish data (random data). I like to have a thumb drive preloaded with bootable Live Ubuntu USB thumb drive ready to perform tasks like this. For this post, I am not going to cover the topic of how to setup your USB thumb drive with Ubuntu Live OS. The tutorial is ready available at official Ubuntu website . Once the Ubuntu Live OS is booted up on your PC, there are already built-in commands you can use to perform such secure deletion or erase of your HDD content. There 2 commands that you can use from...

This is how you can combine text contents from 2 cells into 1 cell using formula. You can even insert your custom text in between, before or after the combined text. To combine text contents from 2 cell into 1 cell, use the "&" to join them together: A1&B1 If you want to insert a space in between the 2 combined text: A1&" "&B1 If you want to insert a hyphen in between them: A1&" - "&B1 If you want to add your custom text before the combined text: "custom text "&A1&B1 If you want to add your custom text after the combined text: A1&B1&"custom text" You can also combine the text together using "CONCATENATE" function: CONCATENATE(A1,A2) CONCATENATE(A1," ",A2) via ( http://office.microsoft.com/en-001/excel-help/use-formulas-to-edit-correct-and-proofread-text-RZ006183133.aspx?section=12 )

This is how you can add a line break into Ms Excel cell using formula. Using keyboard while typing into the cell, to insert a line break just hit "at+enter". But what about using formula? To insert a line break into Ms Excel cell using formula, use this: CHAR(10) Example: ="this is the first line"&CHAR(10)&"this is the 2nd line" via( http://excel-formulas.blogspot.com/2009/03/line-break-in-cell-using-formula.html )

By default if you try double clicking and open 2 Excel files, they will open up and stack into 1 instance of Excel program. What if you are cross referencing 2 Excel files using 2 monitors? You definitely want them to show each in one monitor (if you have 2 computer monitors). This is how simple you can workaround it: Directly run Excel program from your start menu 2 times so that you have two Excel running at the same time. Notice that they are in separate window instead of stacking on each other. Drag each of your Excel files into each of the running Excel program. Now you have 2 windows of Excel showing each of your Excel files.  Just put each of your Excel window to each of your 2 computer monitors. Now you can cross reference your 2 Excel files using 2 computer monitors.