Some Basic Tutorial of MS Excel

Quick Sorting Tutorial:
One Column
To sort on one column, execute the following steps.

1. Click any cell in the column you want to sort.
2. To sort in ascending order, on the Data tab, in the Sort & Filter group, click AZ.

To sort on multiple columns, execute the following steps.

1. On the Data tab, in the Sort & Filter group, click Sort.
The Sort dialog box appears.

2. Select Last Name from the 'Sort by' drop-down list.
3. Click on Add Level.
4. Select Sales from the 'Then by' drop-down list.
5. Click OK.

Result. Records are sorted by Last Name first and Sales second.

Quickly Delete blank rows in Excel
After selecting the data range, continue as follows:

  1. Press [F5].
  2. In the resulting Go To dialog box, click Special.
  3. Click the Blanks option and click OK. Doing so selects the blank cells
  4. Now you're ready to delete the selected cells. On the Home tab, click the Delete dropdown in the Cells group and choose Delete Cells. Excel will display the Delete dialog box, with the Delete Cells Up option selected. Click OK. Or, press [Ctrl]+-. Excel will delete the blank cells from the selected data range

Add some word to all or some rows in MS Excel?

If I want to add some words before or after each word of a column, how can I do that?

I mean: for example, I put the words "who is" before each number in the first column and get

Who is Lora
Who is Muhit
Who is Jana
Who is Devid
Who is John
Who is Kanon
Who is Rivery

The easiest way is:

  • Select All cells that want to change.
  • right click and select Format  cell.
  • In category select Custom.
  • In Type select General and insert this format ----> "Who is "@
Add some word to all or some rows in Excel?

Add some word to all

How to solve wordpress multisite subdomain error for hostgator

After a lot of trying, finally, I managed to set up a WordPress multisite to work on a HostGator server setup.

You need to add setup a wildcard subdomain from hostgator subdomain setup.
Go to subdomains and add one with just an asterisk(*).

To check if the wildcard setup is really working:  

If your domain is, then visit any random subdomain which is not assigned yet. For example:
If this subdomain redirects to your main domain, then your wildcard setup is ok. Otherwise, you have to manually edit the A record for the asterisk(*).
To do that go: Simple DNS Zone Editor
Add an A record to: *
You will find the address below of that page. The IP address or record (ex: which is assigned to your main domain.
After adding this record, I think you will not find any error now. But in case do the wildcard checking again.

Add this into wp-config.php to enable multisite.
define('WP_ALLOW_MULTISITE', true);

Login to your WordPress dashboard and go to Tools>>Network (.com/wp-admin/network.php) You will then see the following type of instructions. Just follow the instruction.

I don't know. Your site should be ok now.

Driver Install Error: A service installation section in this INF is invalid. [Solved]

Process 1:

(1) Go to C:\Windows\INF
(2) Type "wpdmtp.inf" in search bar provided to the right of the address bar in Windows 10.
(3) Once you found it, just right click on it and select install. It will take a very few seconds.
(4) Connect your device to the pc.

Process 2:
If the player is showing up in your Windows' Device Manager under "portable devices" with a yellow "!":

1.) Right-click the yellow "!" and choose "update driver".
2.) When given the option to connect to Windows Update, choose "no, not this time" and click next.
3.) Choose "Install from a specific location (advanced)" and click next.
4.) Choose "Don't search. I will choose the driver to install" and click next.
5.) Click the "Have Disk" button. Browse to C:\Windows\inf and choose the file marked "wpdmtp.inf"

I can't believe the generic players have such support when so many people have this problem! I think the Windows file problem might be caused by "compressing old files" when you do a disk cleanup.

Web Development Offer

I am a Bangladeshi individual who is dedicated to giving web design and development service to any company that is just starting out or is already reputed enough but require that IT services and that can guarantee efficiency and quality. I have worked for different foreign companies that accept only top level work. When an organization looks for a good website with a wonderful design and best development, then I am here. Quality is always one of my top priorities.

I know how much time is precious to you. That is why I try to meet your goals in the given time.

If you want my service, please email me:
Contact me: 01717656839
If you agree to work with me, you have to pay me first. Here is my refund policy.

How to fix torrent 'magnet link not working' on chrome

Clicking on magnet links at any torrent host site doesn't do anything?
Then follow the below process.

Go to start menu > run
type in %LOCALAPPDATA%\Google\Chrome\User Data 
Double click the Local State file
select notepad to open it.
search for "protocol_handler" > "excluded_schemes" > "magnet": true
Change true to false.

magnet link not working

torrent magnet

How To Remove Shortcut Virus Windows 7/8 and Read Hide files On Pendrive/PC

Your files turned into shortcuts on USB/PC? Many people are having the same problem and its so frustrating.  Bassically it spreads via USB memory sticks or external hard drives, and “converts” all the files into shortcuts.  Fortunately the real files are still there, the user is just unable to see them. We will fix the problem in five simple steps.
 Remove Shortcut Virus

Step One
First, you need to make all files visible. The following process apply for Windows XP, Vista and 7.

  • Click on Start
  • Click on Control Panel
  • Pick Folder Options
  • >Click on “View” tab
  • Clear the following check boxes:
  • Clear the check box “Hide protected operating system files (Recommended)”
  • Clear the check box “Hide extensions for known file types”
  • Click Accept to apply the changes

make all files visible

Step Two
We need to make sure that your computer is clean from the infection. Do a scan with updated antivirus(If possible). And follow the bellow process (Widows XP/7/8):

  • Open Task Manager (Ctrl+Alt+Del) and End Process for any WSCRIPT.EXE that is currently running. (This will stop the running virus, the next steps are for preventing it from running again next time you start your computer)
  • Click on Start
  • Type REGEDIT and Tap Enter
  • Click on Software\
  • Click on Microsoft\
  • Click on Windows\
  • Click on CurrentVersion\
  • Click on Run.
  • On the list on the right find any reference to a file that ends with  .vbs and take note of were that .vbs file is located
  • Go to the said location and delete the .vbs file
  • Go back to Regedit and delete the key referencing thtat said .vbs  file

Step Three
If everything went fine at this step you should be able to see “new” files in your USB drive. The formerly hidden files probably are your missing files and folders. The shortcuts  on the other hand were created by the infection and are not related with your files.

Proceed to delete the shortcuts, the Autorun.inf, any .vbs file and everything you don’t recognize as yours. Needless to say, be careful, do not delete your legit files!
delete the shortcuts, the Autorun.inf, any .vbs file

Step Four
To permanently change the properties of your files back to normal we need to open the Command Prompt. On Windows 8, Vista and 7:

  • Click on Start
  • Type cmd in the first box you see
  • Press ENTER

On Windows XP:

  • Click on Start
  • Click on Run
  • Type cmd
  • Press ENTER

Step Five
On the black Window that appears -technically called the Command prompt- write the commands shown on the picture. Don’t forget to replace the letter X with the letter of your infected drive.

For example, if your affected drive letter is F then the command should be
attrib -h -r -s /s /d F:\*.*

After writing the command hit enter and wait a few seconds while the changes are made.
Command prompt

Go back to the file explorer and see if the file attributes are back to normal.
Removed Shortcut

How to make bootable usd drive from windows 8/7 dvd or pc files

It is a easy process to create a bootable pendrive through command line (CMD). I will tell you the process step by step.

Step 1: 

Copy the windows files from dvd or mounted iso file and save them to a folder in your harddisk. You just need to make sure you know where it is located.

Step 2: 
Make sure your pendrive is inserted, go to start search cmd , right click on it and select run as administrator. CMD will appear, now you need to write the below comands one by one:

list disk
select disk 1(Warning: choose  the usb device, you will recognize it by its size)
clean   (this will erase the usb)
create partition primary
select partition 1
format fs=ntfs    (this will format the usb drive and will take 10-15 minutes)

make bootable usd drive from windows 8/7 dvd or pc files

Step 3: 
After the format is done you have to continue writting  in command promt :
exit (this command will exit the disk part function)

Step 4: 
Now you have to write the path to the executable file in your windows saved folder, make sure that in your windows folder you have the boot folder with the bootsect executable file. For my case, I putted this file in E:\win8
So I made this command below:  

E:  (to enter the drive of my windows file)
cd win8  (to enter the folder of my windows file)
cd boot (to enter the folder of boot file)
bootsect.exe/nt60 h:   (h is the letter of the usb drive ,this comand will update the boot core)

Step 5:
Now you have to copy all the files in the windows folder to your usb drive.

ALL DONE. You can install windows from the usb drive.  Bookmark my blog, hope this will help you a lot. Thanks.

Proxy Browsing: How access and browse blocked-restricted website using Chrome and Firefox

1. Go to
Find an ip.

Chrome  user: Goto . Install switchy. Then configure new profile like the image below with the ip you found first step.

Bandwidth Control and Monitoring With Net Limiter Software Free Download

For those who are interested in having control over bandwidth(internet speed) under windows a couple of working (tested with 95/98/ME/NT/2k/XP/Vista/Seven) solutions are :

You can use Net Limiter. Its a great software.its an ultimate internet traffic control and monitoring tool designed for Windows. You can use NetLimiter to set download/upload transfer rate limits for applications or even single connection and monitor their internet traffic.

Along with this unique feature, Netlimiter offers comprehensive set of internet statistical tools. It includes real-time traffic measurement and long-term per-application internet traffic statistics

There are 3 NetLimiter editions available, Pro, Lite and freeware.