Author: Aniruddh

  • How to use Lenovo A6000 as Modem

    Lenovo A6000 is one the most affordable 4G Dual sim Android smartphone in India. The good internal hardware coupled with decent build quality and competetive price is the key attraction of this smartphone. In this tutorial, we will see, how to use Lenovo A6000 as modem through WiFi hotspot and USB tethering.

    Read:

    Take screenshot on Lenovo A6000

    Lenovo A6000 Review

    How to download Lenovo A6000 PC Suite

    How to use Lenovo A6000 as WiFi Hotspot

    As I mentioned earlier, Lenovo A6000 supports 4G speeds. So even if you are outside, you can get the broadband speed on your smartphone. It is worth to use Lenovo A6000 as WiFi hotspot to connect to internet from your laptop or PC. Do remember that, using WiFi hotspot will incur charges as per your data plan also it will drain your device battery faster. Let us have a look into how to use Lenovo A6000 as WiFi hotspot.

    1. Enable the mobile data.
    2. Now go to settings->More…
    3. Tap on to Tethering & hotspot.
    4. Now enable the WLAN hotspot moving the slider to right.
    5. It will enable your Lenovo A6000 as WiFi hotspot.

    How to customise Lenovo A6000 WiFi hotspot Settings.

    If you want to customise the settings such as SSID, password and security type, follow the step given below. Even if you wanto see the Lenovo A6000 hotspot password or just want to change or reset Wi-Fi hotspot password of Lenovo A6000 and A6000 Plus, follow the step given below.

    • Tap on to WLAN hotspot
    • Now go to Set up WLAN hotspot.
    • You enter or edit the SSID, password and security type in this page.
    • Once you are done, tap Save.

    How to use Lenovo A6000 as modem through USB tethering

    1. Follow the same steps mentioned above till the step 3.
    2. Now connect your device to PC or laptop using the USB cable.
    3. Now enable the USB tethering.
    4. Now mobile data will be shared to your PC.

    Video Guide on How to use Lenovo A6000 as WiFi Hotspot

     

  • Lenovo A6000 Cons and Pros Review

    Lenovo A6000 is a budget Dual sim Android smartphone with support for 4G connectivity. The device is available exclusively on flipkart through flash sales. The price of Lenovo A6000 in India is Rs.6999.

    Lenovo A6000 is powered by 1.2GHz quad core 64 bit Qualcomm Snapdragon processor with 1GB of RAM and Adreno 306 GPU. Internal storage of the device is 8GB in which 4.19GB is user available. The device also supports expandable storage upto 32GB. You can even install most of the apps to microSD card as default storage location.

    Lenovo A6000 4G LTE Dual sim

    Lenovo A6000 sports 5 inch IPS screen with screen resolution of 1280×720 pixel(720p HD) and 294 ppi pixel density. The viewing angles and colors reproduction are great. The texts and video looks crisp. The sunlight legibility also good. Overall it is very good display panel in this price range.

    Lenovo A6000 houses 8MP primary camera with LED flash and 2MP front facing camera. Both camera can record videos at 720HD resolution. The connectivity features of the device includes 3G, 4G(LTE Cat 4 speeds of up to 150Mbps download and up to 50Mbps upload.), Bluetooth, WiFi, USB tethering and WiFi Hotspot.  The device has 2300 mAh battery.

    Read: How to take screenshot on Lenovo A6000

    How to download PC suite for Lenovo A6000 and Lenovo A6000 Plus

     Advantages and Disadvantages of Lenovo A6000

    Pros of Lenovo A6000

    • Great Display panel: The 5 inch 720p HD screen provides excellent viewing angles and sunlight legibility.  The colors look great. It is one of the best display screen within the price of 10k.
    • Good battery life: With heavy usage, it lasts almost a day. However with causal usage it last close to 2 days. Standby mode consumes very minimum power.
    • Excellent performance: The quad core 64 bit processor with 1GB of RAM and Adreno 306 GPU coupled with minimalistic UI provides lag free experience.
    • Good sound output: The dual speaker with Dolby features produces excellent sound quality. The output through 3.5mm headphone jack too good.
    • Good build quality: Though it is 5 inch smartphone, it feels very comfortable to hold in hand as well as keeping it in pocket.
    • Decent cellular call quality: The call quality on this device is good.
    • Good value to price:  It is overall good value for money device.

    Cons of Lenovo A6000

    • No OTG support: Lenovo A6000 does not supports OTG.
    • Lack of sensors: Lenovo compromised on the sensors like Gyroscope, compass etc. The device comes with only light, proximity and accelerometer sensors.
    • Max video record resolution is 720p: Max resolution at which video can be recorded on this device is 720p. There is no 1080p video recording available on this device.
    • No LED notification light.
    • The capacitive touch buttons are not back illuminated.
    • No screen protection: The display screen does not features any protective glass such as Corning Gorilla glass. The display screen is finger print magnet.

    Lenovo A6000 Specification Summary

    • 1.2GHz quad core 64 bit Qualcomm Snapdragon processor with 1GB of RAM and Adreno 306 GPU.
    • 5 inch IPS screen with screen resolution of 1280×720 pixel(720p HD) and 294 ppi pixel density.
    • 8GB internal storage in which 4.19GB is user available.
    • microSD support upto 32GB.
    • 8MP primary camera with LED flash.
    • 2MP front facing camera.
    • 2300 mAh battery.
  • How to take screenshot on Lenovo A6000

    Lenovo A6000 is a budget Dual sim Android smartphone with 4G capability. The device runs on Android 4.4 Kitkat out of the box with Vibe UI. Taking screenshot on Lenovo A6000 is very easy. There are two methods through which you can take screenshot. Here are the two methods to take screenshot on Lenovo A6000 4G Android smartphone.

    Useful Tips and Tricks Posts on Lenovo A6000 and A6000 Plus:

    How to use Lenovo A6000 as Modem: How to guide on using features like perforsonal wifi hotspot and USB tethering.

    How to download Lenovo A6000 PC suite: Tips to download and install USB driver and PC suite

    How to take screenshot on Lenovo A6000

    As mentioned before, there are methods. First one is the default Android method and another one is Lenovo Vibe UI exclusive method.

    Android Default method of taking screenshot on Lenovo A6000.

    Like any other Android smartphone, you need to press and hold Volume down and power button simultaneously to take screenshot.

    Vibe UI way of taking screenshot on Lenovo A6000

    • First go to the screen on which you want to take the screenshot.
    • Next go to quick notification area settings by swiping the screen from top to down using two finger.

    Print screen on Lenovo A6000

    • The quick settings has the screenshot icon.
    • Tap on to it to take the screenshot.

    Where the taken screenshot gets saved?

    The taken screenshot on Lenovo A6000 will be saved on Gallery folder.

    Video on How to take screenshot on Lenovo A6000

  • Find matching value in a row and return column name in Excel

    When we work in excel sheets, we are required to find a matching value in a row and return the Column name. For example, we need to calculate the lowest priced store from the price table of multiple stores for multiple products. Another example can be found at the primary reason for exits from the exit feedback form analysis. In these cases, even multi-condition vlookup doesn’t help. We will take the first example and find out how to solve this using the Excel formulas.

    Recommended Reading:

    Conditional VLOOKUP with MATCH In EXCEL
    Example:

    Excel Lookup

    In the above table we have to return the company name which has lowest price for that product. For this we need to find the column which has the lowest price. So we need to use min(Range) excel worksheet formula. This will give us which is the lowest value. Now we need to find the relative position of the value. For this, match worksheet formula is useful. Now have to get the column name of that position. For this we need to use index function. The final formula will become like below.

    =INDEX($B$1:$E$1,MATCH(MIN(B2:E2),B2:E2,0)) which returns Company A.

    How it works?

    MIN(B2:E2) returns 16999.
    MATCH(MIN(B2:E2),B2:E2,0) returns 1
    INDEX($B$1:$E$1,MATCH(MIN(B2:E2),B2:E2,0)) returns Company A as column 1 in range B1 to E1 is B1.

    Note: The column range for index and match should be the same. Only the row numbers can be different. As match function returns relative position data, the column range should be same for Index function also.

    You can tweak this function according to your requirements. You might required to find the column name when you know the exact value in the row. In that case, you need to replace min function with required value.

  • Asus EeeBook X205T Frequently Asked Questions

    Asus EeeBook X205T is newly launched compact travel friendly device. I have already written a detailed review on this. You can read it in my post  pros and cons of Asus EeeBook 205. In this post I am giving you some of the useful information which is directly answered  by the ASUS product support team. Let us start the questions and answers on Asus EeeBook X205T.

    Asus X205T

    Asus EeeBook X205T Frequently Asked Questions

    Question: Is this device supports USB booting? If yes, how to enable USB booting?
    Answer: In USB Storage, there has to be a UEFI applicable OS or UEFI Shell , and Security Boot in BIOS SETUP has to switch to disabled.
    Question: How to reinstall the Windows 8.1 in Asus EeeBook X205T in case of OS gets corrupted because of Virus or some disc failure?
    Answer: When turn on the computer, Press F9 to enter recovery OS mode or start OS recovery in Windows.
    Question: Is Asus EeeBook X205T  compatible with Ubuntu Linux?
    Not Guaranteed.
    Question: How to install applications directly in to microSD card in Asus EeeBook X205T?
    Answer: When installed, if the .exe program ask you to choose the designated installing address and you can choose the address in Micro SD card. If not, than it has to be installed in build-in eMMC.

    Just to recap, Asus Eeebook X205T sports 11.6 inch screen with resolution of 1366 x 768 Pixels  and powered by 1.33 GHz with Turbo Boost Upto 1.83 GHz 4th Gen Atom Quad Core with 2GB of RAM. It has 32GB internal storage and supports microSD card upto 128GB. The Eeebook 205 runs on Windows 8.1. For connectivity it has Bluetooth, WiFi, 2 USB ports and micro HDMI port.

    Update: My Asus EeeBook X205 got updated to Windows 10 home edition. I have been using this from past 10 days and I have not faced any issues. All the features are working good. The performance is better than before. I will share a dedicated post on how to update Asus EeeBook X205T to Windows 10 in my next post.