Thursday, 22 June 2017

How to sort excel sheets within a workbook

Microsoft Excel is one of the most used spreadsheet application and has lots of features that makes data processing easier. In excel, we can use macros too and in this tutorial, I'll write about sorting excel sheets within a workbook. Follow the steps given below:
1. Open Excel and create some sheets in the workbook. Rename them and arrange them randomly (I'm assuming an example sheet to start with). I've named the sheets as navy call list.
create sheets

2. Now right click on any sheets and click "View Code" as shown in the screenshot below.

view code

3. Now "Microsoft Visual Basic for Applications" window will be opened. Click on "Insert" and click on "Module".

insert module

4. A new module will be created and a blank editor will appear. Copy and paste the following code in the editor:

Sub Sort_Active_Book()
Dim i As Integer
Dim j As Integer
Dim iAnswer As VbMsgBoxResult
' Prompt the user as which direction they wish to
' sort the worksheets.
   iAnswer = MsgBox("Sort Sheets in Ascending Order?" & Chr(10) _
     & "Clicking No will sort in Descending Order", _
     vbYesNoCancel + vbQuestion + vbDefaultButton1, "Sort Worksheets")
   For i = 1 To Sheets.Count
      For j = 1 To Sheets.Count - 1
' If the answer is Yes, then sort in ascending order.
         If iAnswer = vbYes Then
            If UCase$(Sheets(j).Name) > UCase$(Sheets(j + 1).Name) Then
               Sheets(j).Move After:=Sheets(j + 1)
            End If
' If the answer is No, then sort in descending order.
         ElseIf iAnswer = vbNo Then
            If UCase$(Sheets(j).Name) < UCase$(Sheets(j + 1).Name) Then
               Sheets(j).Move After:=Sheets(j + 1)
            End If
         End If
      Next j
   Next i
End Sub


4. Now click on "File" and "Close and return to Microsoft excel".

exit from the code editor

5. Now in Excel, click on "View > Macros > View Macros". It will open the saved macros.

view macros

6. In the Macro window, you should see "Sort_Active_Book" macro. Click on it and click "Run". It will open a prompt, click on Yes if you want to sort the sheet in ascending order, click NO if you want to sort the sheet in descending order.

run macro

7. That's it, you can see that the sheets in your workbook are sorted.

sorted sheets

Keep visiting for more tips and tricks.

Monday, 15 May 2017

What is a Ransomware and how to prevent it

Ransomware is a kind of malicious software which encrypts the files of infected PC upon execution and it's designed to block the access of files in a computer until a sum of money is paid to the hacker. Once the money is paid, the hacker sends a decryption key to the victim which can be used to decrypt the files and get the access back. Most of the times, even if you pay the amount, the victim doesn't get any decryption key and it is almost impossible to track the attacker because they accept the money through bitcoin in encrypted form that is very difficult to track.

What exactly happens when a pc gets infected by a Ransomware?
Well, earlier, ransomware software were too easy to get rid of for a little techie people who knew about windows task manager and startup items. I have personally analyzed some old ransomwares and what they did was just executed themselves and created a startup entry for their main application to show that scary screen which says that your computer or files have been locked and you need to pay some money to the attacker to get back the access to the pc. It could be easily closed by ending the ransomware process from task manager and the malicious file could easily be stopped from auto executing by running msconfig command through RUN and deleting the startup entry of the ransomware software. Some ransomware create events in windows to auto download and execute themselves even after deleting the ransomware software and these kind of ransomwares are bundled with software cracks which are actually malwares. But that too could be stopped by deleting the particular event or task from the computer.
But these days, ransomware are being coded in a much complicated way that are FUD (fully undetectable) for so many anti-virus software and the encryption technology used by the ransomware is very difficult to crack so they are getting more dangerous as they are not detectable and non-removable by any antivirus. Although some antivirus vendors like KasperSky and Malwarebytes are providing decrypting tools to recovered the locked files, there are still so many ransomware available online which decryption algorithm is still not available.

Recently "WCry", referred as "WannaCry" ransomware infected about more than 57000 computers worldwide this friday (12th May 2017) and created a panic among the computer users. It affected hospitals, schools, offices and government agencies. After infecting the computer, it's asking to pay $300 to unlock the files and I'm not sure whether the attacker really sent any decryption key to decrypt the files for anyone who paid the amount.
wannacry ransomware screen
Well, this ransomware was accidently stopped by a cybersecurity researcher which is tweeting with the user name @MalwareTechBlog. The researcher bought the domain name used by the ransomware on a website called for $10.69, and set it up on a server in Los Angeles which stopped the Ransomware as the domain name used by the ransomware was never booked and setting up the domain on the server stopped the ransomware to spread.

How to prevent from getting infected with ransomware?
But still the risk is not over and the attacker might spread the ransomware again by changing the code of it and by making it more difficult to decrypt. So what can be actually done to stop the ransomware to infect your PC? Well, there is no any 100% working solution available for it yet but yes, with the few precautions, you can prevent it. I'm listing a few tips which you can follow to be safe from the ransomware:
1. Don't open any file which you receive through mail from unknown people. The file might be of any extension so don't think that you are opening a safe file and get trapped.
2. Use sandbox before opening any suspicious file which you think might not be any virus. Using a sandbox creates a virtual space in your computer and keeps your computer safe in case if you encounter any virus in your sandbox.
3. Install any good antivirus and anti-malware in your computer and keep it up to date. You may use Malwarebytes, Kaspersky, AVG Internet Security etc.
4. Apart from antivirus, you can use Anti-Ransomware tools too such as Bitdefender AntiRansomware, Malwarebytes Anti-Ransomware, EMET, Kaspersky Anti-Ransomware tool etc.
5. Disable SMB service in windows services to prevent the ransomware to be executed. To do so, open appwiz.cpl from RUN and click Turn Windows Features ON or OFF. Now look for SMB 1.0 and uncheck it and click OK. Usually you can find this option in Windows Server Edition OS.
program and features
turn windows features ON or Off
Alternatively you can run the powershell command too which is given below:
"Disable-WindowsOptionalFeature -Online -FeatureName smb1protocol"

Note: If you are sharing files among different computers, then don't turn off SMB feature. File sharing won't work after disabling this feature.

6. Install all the security patches and updates from Microsoft to keep your PC safe. TO install the important security patches, use the following links:

Since these too are not sufficient to prevent a user from getting infected from a ransomware so the only thing which can prevent your computer from being infected is using strong firewalls and use of common sense.

That's all for today. Keep visiting PC Tricks Guru for more tips and tricks.

Friday, 24 March 2017

Redmi 4A : Specs, Scores and Teardown

Redmi 4A : Specs, Scores and Teardown
On 20th March 2017, Xiaomi launched another budget friendly phone "Redmi 4A" which made the people crazy again and on 23rd of March 2017 it's first sale was conducted on and website and about 2.5 million devices were sold just in 4 minutes which is a huge success for the device. Let's have a look on the specifications of the device which are the best among the other devices of this price segment, i.e. Rs.5999 only.

General Specifications of Redmi 4A:
Dimension : 139.50x70.40x8.50
Weight : 131.50g
Colors Available : Gold, Rose Gold, Dark Gray
Screen Size : 5 inches
Display : HD IPS LCD Capacitive Touch Screen Display
Pixel Density : 294ppi
Resolution : 720*1280 pixels
Gorilla Glass : Not Available
Scratch Resistant Screen : Yes
Processor : 1.4 GHz Quad-Core
CPU : ARM Cortex A53 Qualcomm Snapdragon 425 M SM8917
GPU : Adreno 308
RAM : 2 GB
ROM : 16 GB
Expandable Memory : Yes, upto 128 GB (Micro SD)
Rear Camera : 13 MP
Flash : Yes
Front Camera : 5 MP
Camera Aperture : 2.2 (Still Mode)
Connectivity : WiFi 802.11 a/b/g/n, Bluetooth v4.10
Infrared Blaster : Yes
GPS and Gyroscope: Yes
OS : MIUI 8 Based on Android 6.0 Marshmallow
Battery : 3120 mAh Non-Removable
Dual SIM : Yes (Mini/Micro)
4G VoLTE Support : Yes
Price : 5999 INR

After looking at the specification, you can now understand why this device is too successful. Among the other devices within this price range, Xiaomi Redmi 4A tops.

Benchmark Scores of Redmi 4A:
geekbench single
geekbench multi
3d mark

Pros :
  • Small and light
  • VoLTE support
  • Easy to use with one hand
  • Decent battery life
Cons :
  • Hybrid dual-SIM slot
  • Camera performance is not too good for low light
Teardown Photos of Redmi 4A:
Any mobile device looks great from outside but what really important for a mobile phone, even for any device is it's hardware. You might wanted to know how does it look from inside but never tried to dissemble the device as it might damage the device and void the warranty. Let's see some of the photos of the hardware of the Redmi 4A. Special thanks and credits to for making this awesome video of Redmi 4A teardown;

If you don't want to see the video then I'm putting some snaps from the teardown video below for you:

---After opening the back panel, it looks like this...---
back panel

---This is the side view of the back panel which is made of polycarbonate---
back panel

---This is how the back panel and the body looks from top and bottom internally---
top and bottom view

---You guessed it right! This is the camera of Redmi 4A---
primary camera

---The upper mainboard of Redmi 4A where the connections for Battery, camera, SIM/MMC are located---
main board

---Here comes the processor---
redmin 4a processor

---The Main Board of Redmi 4A---
main board

---Smile Please! Yeah, It's Front Camera Module---
front camera

---And here is the USB Module of Redmi 4A---
usb module

---Polycarbonate body beneath USB Module---
bottom body

---Body without soul---
polycarbonate body

---And finally, the Battery---
I hope you liked this article. Do share your views about the device and keep visiting PC Tricks Guru for more tips and tricks.

Monday, 20 March 2017

Xiaomi Redmi 4A Launched in India

Xiaomi Redmi 4A Launched in India
Xiaomi has launched it's new device Xiaomi Redmi 4A in India today and it's definitely gonna win the hearts. The price for this phone has been set as Rs. 5999 only (Same as the Redmi 1S) and the phone is available in dark gray, gold and rose gold colors.
It's powered by Snapdragon 425, quad core 64-bit processor. It has 5 inches HD display and it's the lightest Redmi phone ever (131.5g only). The device has 13MP+5 MP camera and it houses 3120mAh battery. It has dual 4G SIM slots with VoLTE support. It has 2GB RAM and 16GB ROM that can be expanded upto 128GB with micro SD card. The best thing is that it has Infrared Remote hardware that is still not available in any device in this price range.

Features of Redmi 4A:
-Powerful Qualcomm Snapdragon 425 processor Quad core
- Made out of a single-piece of polycarbonate body
- Rich 5” HD display
- Super thin at just 8.5mm
- Full day battery life with 3120mAh battery
- Seamless performance with 2GB RAM
- No compromises with 16GB storage expandable up to 128GB
- 13MP primary camera with 5-element lens, f/2.2 aperture, HDR and real-time filters
- 5MP front-camera with a fully revamped Beautify
- Dual SIM, dual standby [nano and micro SIM]
- IR remote that supports appliances from thousands of brands
- Available in Gold, Dark Grey and Rose Gold

Redmi 4A is going on sale from 23rd March 2017 at 12 PM exclusively on and MI India website.


Sunday, 12 March 2017

How to suspend or cancel your Jio SIM yourself

How to suspend or cancel your Jio SIM yourself
After using the free services of Reliance Jio, so many users want to suspend or cancel the Jio SIM and there are so many reasons behind it. The first reason is that users are afraid of Porting their numbers into Reliance jio because they are not sure what plans will Jio offer in future and the major problem is the network coverage. Reliance jio doesn't work in 2G/3G mode but other SIM Cards do, so usually in the areas where 4G network coverage is not so good, they won't be able to use their phone and can't make calls. Second is internet speed, I personally noticed that in most of the areas, JIO speed is very less and sometimes it doesn't work at all, even if we see full network signal indicated by the device. But with our primary networks, we can switch to 3G or even 2G in case of urgent data need. Third is frequent network drop which is happening from last few days. So overall users are not sure how will the Jio network perform that's why they don't want to switch to Jio.
Let's come back to the main topic, i.e. How to suspend or cancel your Jio SIM yourself:

  • Login to the JIO Website from the link: (Use your login credentials of MyJio app to login)
  • Once you are logged in, you will see a settings button on the top right screen. Click on that.

How to suspend or cancel your Jio SIM yourself

  • Now you will see "Suspend and Resume" option, click on that.
  • Click on the "I would like to suspend this service" dropdown button.
  • A pop up will appear on the screen,  select any of the options, like "SIM Damaged".
  • Now click on Suspend. That's it. You will see a message that your request to suspend the service has been submitted successfully.

How to suspend or cancel your Jio SIM yourself
How to suspend or cancel your Jio SIM yourself

  • After submitting the request, your SIM will be suspended within 24 hours.

    That's it. For more tips and tricks, keep visiting PC Tricks Guru.

    Saturday, 25 February 2017

    Customize office C2R installation for Office 2013 and 2016 with Office Deployment Tool

    Customize office C2R installation for Office 2013 and 2016 with Office Deployment Tool
    MS Office is one of the most used office suit for all the office needs worldwide and it is available in different versions (2013/16/365). In the older versions, Microsoft used MSI installers which had the option to customize the installation of office, it means we could choose which application we want to install and which we don't but in the new versions of office Microsoft we can't customize the installation because Microsoft is using click to run installer for the installation of office. If you ask Microsoft about custom installation, they would say that it's not possible but actually it is possible using the office deployment tool. So in this article I'll tell you how to customize the office installation.
    Follow the steps given below:

    1. First of all download the offline ISO file of office from or from any mirror site (I'll use office 2016 Pro Plus in this tutorial).
    2. After downloading the ISO file, mount it or extract it.
    3. Inside the ISO file, you will get one folder, "Office" and two files, "autorun.inf" and "setup.exe". Now download the office deployment tool from this link:
    4. After downloading the Office deployment tool, extract the file and you will get 3 files there, "Configuration.xml", "EULA" and "Setup.exe".
    5. Now open the configuration.exe in notepad and you will see some code there which is given below:
    <Add SourcePath="YOUR OFFICE INSTALLATION FILE PATH\" OfficeClientEdition="32">
    <Product ID="ProPlusRetail">
    <Language ID="en-us" />
    <ExcludeApp ID="Access" />
    <ExcludeApp ID="Groove" />
    <ExcludeApp ID="InfoPath" />
    <ExcludeApp ID="Lync" />
    <ExcludeApp ID="OneDrive" />
    <ExcludeApp ID="OneNote" />
    <ExcludeApp ID="Outlook" />
    <ExcludeApp ID="SharePointDesigner" />
    <ExcludeApp ID="Visio" />
    6. You can edit the code as per your convenience and customize the office installation. You can replace the source path with your own path where you have kept the office installation files which you got after extracting the ISO. You can edit the value of office client edition to 32 if you want 32 bit setup and 64 if you want 64 bit setup. In the product ID value, you can type the product ID which you are using, in my case it's ProPlusRetail. In the same way, you can edit the language ID also. Now you need to decide which app you don't want to install and then add the app name in the ExcludeApp ID value. You can get the Product ID and App ID details from this documentation:
    7. Once you are done with editing the xml file, save it.
    8. Now open the office deployment tool folder and press and hold the shift key and while holding the shift key, right click in the empty area of the folder and click "Open Command Window Here". Command prompt will open.
    9. Now type the following command: setup /configure configuration.xml and hit enter key.
    10. That's it. Office installation will begin and only those components will be installed which were allowed in the xml file.
    For better understanding, you may watch the video tutorial given below:

    Keep visiting for more tips and tricks.

    Tuesday, 14 February 2017

    How to reset Microsoft Word settings to default

    How to reset Microsoft Word settings to default
    Microsoft Word is the most used word processing application worldwide and it is popular on both Windows and Mac operating systems. It is the part of the Microsoft Office package which include other essential office applications. In MS Word, sometimes we make some settings which we forget later and it disturbs the whole formatting of any new document. In this situation we need to reset the word settings to default and there is a very simple method for that but note that follow the steps which I'm giving carefully because we are going to make changes in Windows Registry and if you try to play around with it, your OS might crash and your office application might start misbehave.

    1. First of all open RUN box by pressing windows and R keys together.
    2. Now in the RUN box, type regedit and click OK. It will open registry editor.
    3. Now in the registry, navigate to HKEY_CURRENT_USER > Software > Microsoft > Office > 12 > Word and expand it.
    (The number 12 might be different as per the version of office installed in your computer)
    4. Now you should see "Data" folder there. Just right click on it and delete it.

    How to reset Microsoft Word settings to default

    5. Now open your Microsoft word, it should be rest to it's defaults and you can use it without any problems.

    Keep visiting for more tips and tricks.

    Tuesday, 7 February 2017

    How to disable useless google apps in non rooted android phones

    How to disable useless google apps in non rooted android phones

    Disabling google apps in non rooted android phones is a big question among android phone users and personally I also don't like being forced to keep the bloatware in my phone for no reason. These days, most of the android smartphone makers have their own custom ROMs ported over android OS and they have better apps available than the default google apps but still there is no any option to uninstall the pre installed google apps like hangouts, google play music, google play movies etc and it is possible only if you root your phone but most of the android users are not so advanced to understand the TWRP recovery and ROM flashing so they are always forced to keep the bloatware in their phones.
    In this article, I'll tell you the process to disable the google bloatware in your android phone. Note that this process will not uninstall them but it will disable the bloatware and you won't be able to see their icons. Follow the steps given below:

    1. Open google play store in your phone and tap over "Help and Feedback" option.
    2. Now you will see the list of some help articles for google play. Tap over "Browse All Articles".
    3. Now tap on the article "Uninstall, disable and delete apps".

    How to disable useless google apps in non rooted android phones

    4. Once the article is open, tap over "Tap to go to application settings".
    5. Now the list of installed applications will open on the screen.
    6. Tap over the application you want to disable and then tap "Disable". If it asks to uninstall the updates, uninstall them.

    How to disable useless google apps in non rooted android phones

    7. That's it, the application will be disabled. Using the same method you can disable all the useless google bloatware which you don't need and do better memory optimization for your phone.
    Keep visiting PC Tricks Guru for more tips and tricks.

    Tuesday, 31 January 2017

    Get Free Rs.100 Amazon Voucher (For new amazon accounts on making their 1st purchase)

    amazon refer and earn
    Amazon has came up with a great offer in which you can get Rs.100 amazon voucher for free on your first purchase from amazon app. This is a referral campaign in which you can refer your friends to amazon app and if they make their first purchase, they will get Rs.100 and you will get Rs.200 amazon voucher which you can use to purchase anything from amazon. The steps to avail this offer is simple and I'm explaining the steps below so that you can avail this offer easily.

    1. First of all you need an android phone in which you can install/upgrade the amazon app. To install the app, CLICK HERE or open the link:
    2. After clicking the link, following page will open. Tap over get the latest amazon app and install/update your amazon app.

    Get Free Rs.100 Amazon Voucher

    3. Now sign up and login to the amazon app.
    If asked for any promo code, use ASHUT2523E
    4. After completing your purchase, return to the same page in your browser from where you installed your app and tap over the CLAIM GIFT CARD button.
    5. That's it, you will get Rs.100 Amazon voucher which can be redeemed on your first purchase of Minimum Rs.300

    Wasn't it simple? You can get more free gift cards by sharing your own referral link to your friends. You can create new amazon account using your own referral code and make the purchase of minimum Rs.300 to get Rs.200 vouchers.

    Keep visiting PC Tricks Guru for more offer updates.

    Wednesday, 18 January 2017

    How to search details of any person online

    How to search details of any person online
    Searching details of any person online is not an easy task and generally what people do is google the name of the person but internet is an infinite ocean where finding the exact details of any person is not so easy. But today I'll let you know about a search engines that is actually made to search people on the internet. Let's start.

    Note: These search engines use data from different social media and government servers to look for the criminal records, personal details, work details, qualifications etc. I don't assure that you will always find the correct information of any person you've been searching for. 

    This website looks like a normal search engine with two fields. In the first field, you can type the name, email, phone number or social media username and in the second field you can type the location where that person lives (that is optional, but it gives more accurate results). After entering the details, you can begin your search and it will show the person results from which you can find the person you are looking for.

    I tried searching for my details and I was amazed that how perfectly it collects that data from the internet and displays the results. Below is the list of some of the other search engines which you find useful to search the details of any person online.

    That's all for today. Keep visiting PC Tricks Guru for more tips and tricks and share the article with your friends if you like it.

    Custom Search Box

    Subscribe Our Newsletter

    Advertise With Us