Sunday, 16 July 2017

Get refund for your Amazon order without returning the product : Scam Alert

Get refund for your Amazon order without returning the product : Exposing the Scam
In facebook or in some forums, you might have seen some guys offering refund for your amazon products without returning the product, even after delivery of the product. Sounds interesting, right? I also went through a post in a facebook group where a guy posted that he will provide refund for Amazon products. He was asking for 30% of the amount as his commission once you get the refund in your account. The only condition was that the product must be delivered within 30 days of making the deal with the guy.
I knew that he would definitely do any kind of scam to get the refund because earlier also, people were fooling amazon saying that their order status shows delivered in the amazon account but they never got the product delivered to them and amazon was providing refunds to them without any investigation from their side.
I thought I should play prank on the scammer to know exactly what he is going to do with amazon to get the refund. So I contacted the guy and told him that I want to get the refund. He asked my user id and password. I gave him my amazon login id and password (I changed the password temporarily before providing it to him) and after a few minutes, I got an email from amazon support that the conversation was ended in between and I reported that the ordered item was missing in the box. After a few minutes, I got another mail from amazon that the refund for my order has been started and the amount will be sent to my credit card.
The guy who asked for the refund on behalf of me tried to convince me that he is going to provide me the refund, not amazon. But I got the "Trick" he was using to scam amazon and I told him that I'm going to report amazon about this fraud. (I told him that I'm a government employee and I can't be involved in this scam as it would ruin my career, lol, but later I told him that the whole process was actually a trap to expose the illegal practice he had been doing from long time). He tried threatening me that he is going to file a complaint against me in Amazon and then he deactivated his facebook account.
Well, the whole thing was funny for me but it is actually a serious issue for Amazon. These guys are causing loss to amazon and this is not a right thing according to me. I'm a customer of Amazon and it never disappointed me with its services so I thought I should be good for Amazon too. And yes, I sent the mail to amazon and sent a tweet to amazon to cancel the refund request for my order which they did before the payment was credited to my account, thank God! I'm uploading the single screenshot of the whole conversation with the scammer and the refund mail from Amazon.

Check the screenshot of conversation: https://drive.google.com/open?id=0B1WpxeCQzpcPTk5FRHdESUxmSlk (Zoom the image to see the text clearly)

This is the mail which let me know what did that guy do to request for refund. That's why I came to know that he said that he got the product delivered but the box was empty. Check the screenshot here : https://drive.google.com/open?id=0B1WpxeCQzpcPUWJsN3RfSENjUE0

In the previous mail, the immediate refund request was cancelled and the case was escalated to accounts or refund team, and surprisingly they processed the refund. See the screenshot of  the Refund Mail: https://drive.google.com/open?id=0B1WpxeCQzpcPYVVhQU9jYThMVEE

I've seen some proofs that people got full refund for iPhones too using this scam. Just one request to amazon, please check the things before providing the refunds for the cases that claim "My ordered item was missing from the box" because it is very rare and there are 99% chances that the person who is reporting this kind of situation to get refund is a SCAMMER.
I hope amazon will improve their policies for the refund and will do the full investigation for these kind of fraud in future and will minimize the loss to their sellers and their own company.
Share:

Wednesday, 12 July 2017

Concept of online coupon codes and offers

online stores and coupons
As far as business point of view is concerned, coupon code and promo codes are specific way to promote products and brands among customers. This is one of the most specific ways to bring your products in the market.  Although there is various traditional and commercial ways to promote business but as per market demand online coupon codes are the best way to get recognition and response from customer. Promoscode is offering quite similar facility for users to change the way of shopping.

At the point when coupon codes initially started flowing, they were not frequently found on the retailer's site. Rather, coupon codes showed up on related shopping locales so as to lead customers to the retailer's online store. Today, numerous retailers keep on having coupons on related sites, additionally offer at least one coupon code on their store's sites or through weekly messages that are conveyed to their clients.

The most ideal approach to find a coupon code is by utilizing your most loved web crawler, for example, Google and writing in "Coupon Code". This will create a rundown of sites that offer coupon codes. Customers would then be able to visit the sites and look at the coupon investment funds that are accessible.  In some cases customers can discover coupon codes for particular stores after they have chosen what they need to buy. This should be possible by putting the retailer's name and coupon code into the web index.

For instance, if a customer knew they needed to buy a dress from stores, they could locate the accessible coupon codes for products by entering "discount coupon codes". A rundown of sites would then be created and they would then visit the sites to look for a discount coupon that they could use to avail the discount while purchasing the dress.  

There are various resources that avail various types of coupons and deals for different products.  Clients may get these coupons from different sources, including national daily newspapers and the Internet, with sites offering free printable basic need coupons can be printed at home and utilize them at retail location. Some real basic need chains additionally deliver advanced coupons that might be stacked onto the retailer's dependability card at home, or at a coupon apportioning machine situated in store. In 2011, the best five vehicles for dispersing purchaser bundled merchandise coupons in the U.S. were: the Free Standing Insert, a coupon booklet circulated through daily papers and different sources (89.4%); in-store appropriation (4.2.%); post office based mail (2.3%); magazines (1.5%); and coupons disseminated on or in item bundling (1.3%). Other conveyance strategies together represented fewer than 2% of all coupons dispersed. There are coupon-giving sites that furnish clients with coupons of different stores. These locales gather coupons from different sources. www.promoscode.in brings maximum numbers of stores and deals for customers and makes online shopping experience the best and economical.  These things are vital and beneficial for customers that will make their task and budget easier.

This article is a sponsored guest post on the behalf of PromosCode.in
Share:

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

code

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
prompt

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

sorted sheets

Keep visiting for more tips and tricks.
Share:

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 NameCheap.com 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:
http://www.catalog.update.microsoft.com/Search.aspx?q=KB4012598
https://technet.microsoft.com/en-us/library/security/ms17-010.aspx

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.
Share:

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 mi.in and amazon.in 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:
antutu
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 beryko.cz 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---
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.
Share:

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 Amazon.in and MI India website.

Share:

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: https://www.jio.com/Jio/portal/jioLogin (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.
    Share:

    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 office.com/myaccount 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: https://www.mediafire.com/?rg6cmy7y6i18lvq
    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:
    <Configuration>
    <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" />
    </Product>
    </Add> 
    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: https://technet.microsoft.com/en-us/library/jj219426.aspx#bkmk_productelement
    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.
    Share:

    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.
    Share:

    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.
    Share:

    Custom Search Box

    Subscribe Our Newsletter

    Advertise With Us