Tech2 Touch

Author: Aniruddh

  • Xiaomi Redmi 6 Pro Vs Asus Zenfone Max Pro M1- Which one is better

    Redmi 6 Pro is the latest budget smartphone launched by Xiaomi and it will compete with the likes of  Asus Zenfone Max Pro M1 and Realme 2 etc. In this post, we will have a  quick comparison between Xiaomi Redmi 6 Pro Vs Asus Zenfone Max Pro M1.

    Recommended Reading:

    Asus Zenfone Max Pro M1 Pros and Cons

    Xiaomi Redmi 6 Pro Vs Asus Zenfone Max Pro M1

    Xiaomi Redmi 6 Pro Vs Asus Zenfone Max Pro M1- Which one is better

    Display

    • Xiaomi Redmi 6 Pro: 5.84 inch Full HD + display.
    • Asus Zenfone Max Pro M1: 5.99-inch Full HD+ display.

    Both smartphones sport a good quality panel. Viewing angles, brightness, color reproduction are good. The key difference between the two is the size of the display and notch. Asus Zenfone Max Pro M1 comes with a slightly larger screen whereas Redmi 6 Pro has a notch.

    Winner: Subjective. Based on user preference.

    SoC, RAM, Storage

    • Xiaomi Redmi 6 Pro: Snapdragon 625 with 3GB/4GB RAM with 32GB/64GB storage.
    • Asus Zenfone Max Pro M1: Snapdragon 636 with 3GB/4GB/6GB RAM with 32GB/64GB storage.

    Zenfone Max Pro M1 has latest Snapdragon 636 which is a successor of SND 625. Snapdragon 625 is an efficient and powerful  SoC but older SoC. Though there is no much difference in day to day usage performance, choosing the latest version is a better choice.

    Winner: Zenfone Max Pro M1.

    Camera

    Xiaomi Redmi 6 Pro: Dual camera Setup. 12-megapixel Sony IMX486 (f/2.2 aperture, 1.25-micron pixel size) sensor and a 5-megapixel Samsung S5KE8 (f/2.2, 1.12 μm) depth sensor. 5MP front facing camera.

    Asus Zenfone Max Pro M1: Dual camera Setup. 13 MP (f/2.2, 1.12µm) + 5 MP (f/2.4, 1.12µm) lenses which offers phase detection autofocus, a 5 element lens, and a wide-angle 80-degree lens. 8MP 85.5-degree wide angle lens with f//2.2 aperture.

    After the series of OTA updates, camera performance of Zenfone Max Pro M1 improved significantly. The company recently announced that it will add EIS in the upcoming OTA updates. When it comes to still photography, the overall performance of the rear camera is more or less the same on both smartphones. However, front-facing camera on Zenfone Max Pro M1 performs better in terms of details. Video department too, we felt that this Zenfone Max Pro M1 performance is better.

    Winner: Asus Zenfone Max Pro M1.

    Battery

    Xiaomi Redmi 6 Pro: 4000 mAh battery.

    Asus Zenfone Max Pro M1: 5000 mAh battery

    In our loop test, the screen on time on Redmi 6 pro was around 6 and a half hours. Whereas Zenfone Max Pro M1 gave us around 8 hours.  It is also worth noting that, both devices do not come with fast charger out of the box. So Zenfone Max Pro M1 takes a longer time to charge compared to Redmi 6 Pro.

    Winner: Asus Zenfone Max Pro M1.

    Price and Availability

    Xiaomi Redmi 6 Pro:Rs 10,999 and Rs 12,999.

    Asus Zenfone Max Pro M1:Rs 10,999, Rs 12,999, Rs 14,999.

    Availability is one of the key difference in this segment. Buying Zenfone Max Pro M1 is much easier. It is available through the open sale. However, Redmi 6 Pro available through the open flash sale. This means one needs to wait for the sale time and buy quickly.

    Winner: Asus Zenfone Max Pro M1.

    Summary of Xiaomi Redmi 6 Pro Vs Asus Zenfone Max Pro M1 comparison: According to us  Asus Zenfone Max Pro M1 is much better value for money device compared to Redmi 6 Pro.

  • Take Screenshot on Samsung Galaxy J6 and Galaxy J4

    Samsung J series smartphones are one of the successful smartphone series from past couple of years. Samsung Galaxy J6, Samsung Galaxy J4, Samsung Galaxy J6 Plus, and Samsung Galaxy J4 Plus are the latest release from this series. In this post, we will have a quick look into how to take screenshot on Samsung Galaxy J6 and Galaxy J4. The same method of capturing screenshot works with Galaxy J6 Plus and Galaxy J4 Plus as well.

    Capturing screenshot is the simple way to share the content on Galaxy J6 or Galaxy J4 with others or save it for future reference.

    Take Screenshot on Samsung Galaxy J6 and Galaxy J4

    Both Galaxy J6 and Galaxy J4 smartphones run on Android Oreo with Samsung own custom skin Experience 9.5 UI. This is the same OS version used in Galaxy J6 Plus and Galaxy J4 Plus. For all the 4 phones, the method to perform print screen remains same.

    Take Screenshot on Samsung Galaxy J6

    Take Screenshot on Samsung Galaxy J6 and Galaxy J4 using hardware Keys

    • First, go to the screen on which you want to capture a screenshot.
    • Press and hold volume down and power button simultaneously.
    • You will observe a shutter sound and screen flickering.
    • This confirms screenshot is taken.

    Take Screenshot on Samsung Galaxy J6 and Galaxy J4 using Google Assistant

    • On the screen on which you want to capture the screenshot, launch Google Assistant.
    • Just say or type “Take Screenshot”
    • The screenshot is taken.
    • Do remember, in this method screenshot is not saved by default. You need to save manually or you can directly share.

    You can access the taken screenshots from the Gallery folder.

    These are the two built-in methods to capture screenshot on Samsung Galaxy J6, Samsung Galaxy J4, Samsung Galaxy J6 Plus, and Samsung Galaxy J4 Plus. Long screenshot option is not available on these devices. Palm swipe gesture to take the screenshot on these Galaxy J smartphones not available.

  • Realme 2 Pro Review- Pros and Cons

    RealMe 2 Pro is the latest smartphone with powerful internals at the attractive price tag.   Large display panel with slim bezels and dew drop notch, Snapdragon 660 SoC, up to 8GB of RAM are the main USP of this device. So how does it fares in real time usage? Let’s explore in this Realme 2 Pro Review with pros and cons.

    Realme 2 Pro Review

    Realme 2 Pro Review- Pros and Cons

    Key Specification

    • Octa Core Snapdragon 660 SoC.
    • 4/6/8GB RAM and 64/128GB internal storage.
    • 6.3 inch Full HD+ IPS LCD screen(19.5:9 Aspect Ratio).
    • Dual rear camera -16MP with f/1.7 and  2MP depth.
    • 16MP front facing camera.
    • 3500 mAh battery.

    Realme 2 Pro Pros

    DewDrop notch and Good display panel:

    Realme 2 pro sports 6.3 inch Full HD+ display with Corning Gorilla Glass protection. Notch design is becoming a norm on many smartphones nowadays. “crystal-like dewdrop effect” is what Realme calls for the notch design this display has. It takes a small portion of the screen and looks aesthetically beautiful.

    The display panel used on this device is good. It provides good color saturation and viewing angles. The brightness is good enough to be legible in direct sunlight.

    Powerful Performance

    The device comes with Qualcomm Snapdragon 660 which is a powerful Octa-core Chip. For RAM and storage, the user can choose between 4GB of RAM with 64GB of storage; 6GB of RAM with 64GB of storage or 8GB of RAM and 128GB of storage. There is no complaint about the device regarding the performance. Whether it is multitasking or playing heavy games, it does without any issues.

    Good Camera

    The RealMe 2 Pro comes with a 16-megapixel main rear camera with a f/1.7 aperture and 2MP depth sensor. The images taken in good daylight came out well. The snaps had good dynamic range and colors. Considering the price, overall camera performance is good.

    Decent Battery

    3500 mAh battery on RealMe 2 Pro last one day without any issues with moderate to heavy usage.

    Realme 2 Pro Cons

    • Body attracts lots of smudges.
    • No stabilization for 4K video recording.
    • Slow charging.
    • No NFC and FM RAdio.

    Realme 2 Pro Review summary: Overall RealMe 2 Pro stands out in front of the competition. There are few drawbacks which can be ignored considering overall package it offers for the price.

     

  • Samsung Galaxy A7 (2018) Cons – Top 5 uninspiring Features

    Samsung Galaxy A7 2018 edition finally available to Indian consumers. Triple camera setup and fingerprint scanner integrated power button in the side are the unique features of this device among the Samsung Galaxy smartphones available today. The price of  Galaxy A7 (2018) starts from INR 23,990. Though it has many good features, considering the price, we felt a few things are not great on this device. Here is the Samsung Galaxy A7 (2018) Cons or demerits based on our first impression.

    Samsung Galaxy A7 (2018)

    Samsung Galaxy A7 (2018) Cons – Top 5 uninspiring Features

    • Lack 4K Recording Option: Video recording is restricted to full HD resolution. Even though  Samsung Galaxy A7 2018  is a camera-centric phone, it is sad to see no 4K video recording.
    • No Option Image Stabilisation: Though there is an EIS for the rear camera, the device lacks optical image stabilization.
    •  No NFC: This means, you can use Samsung Pay mini and not the full version of Samsung Pay. Hence you will not be able to use offline tap-and-pay using credit and debit cards on this device.
    •  Lack of USB-C type port and fast charger:The Galaxy A7 2018 comes with microUSB port. The bundled charger is not a  fast charger. Also, it does not support wireless charging.
    • No LED Notification Light.

    These are the uninspiring features or Samsung Galaxy A7 (2018) Cons according to us based on the first impression. However, we will be doing the in-depth review in the coming days and update these points if required.

    Samsung Galaxy A7 (2018) has many good features. So here is the quick list.

    Samsung Galaxy A7 (2018) Pros

    • Large 6 inch good AMOLED Display panel.
    • Ample storage and RAM.
    • Dual SIM with Dual VoLTE support and Dedicated microSD card slot.
    • Triple camera setup with 1 wide angle camera.
    • Impressive looks and design.

    Samsung Galaxy A7 (2018) is available in 2 variants. 4GB RAM/ 64GB storage variant price is Rs. 23,990 and 6GB RAM/ 128GB storage variant costs Rs. 28,990.

  • Conditional VLOOKUP in Excel with Match Function

    VLOOKUP in Excel is a powerful function. Simple vlookup does search for the value in the left most column in the table and returns the value in the same row from column number provided. If the requirement is to search for both row and column, then we need to use a conditional VLOOKUP in Excel. This needs clubbing of match function with vlookup.

    Recommended Reading:

    VLOOKUP in EXCEL tips and Tricks

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

    Conditional VLOOKUP in Excel with Match Function

    There are many ways to do conditional VLOOKUP in EXCEL. In this post we will learn one of the simple method to achieve this. For that, we need to use MATCH Excel function.
    By default, we need to enter the column number in the VLOOKUP syntax. To do conditional vlookup which does checks for both row and column, replace column number with match function. The syntax will look like below.
    VLOOKUP( lookup_value, table_array, MATCH (lookup_value, lookup_array, [match_type]), [range_lookup] )

    Explanation on how it works

    Lets a take a simple example. Refer the table below. The row has store details and in column has categories. To return corresponding value by matching  both row and column, this conditional vlookup formula will help.

    Conditional VLOOKUP in Excel

    Formula used here is 

    =VLOOKUP(A10,A1:D5,MATCH(B9,A1:D1,0),FALSE)

    In this example, instead of hard coding the column number, we have used match function. MATCH function return the relative position of an item in an array that matches a specified value in a specified order.  In our example it return the column number of the row header Store 3.

    Syntax for Excel MATCH function is

    =MATCH(lookup value, lookup array, [match type])

    This can be achieved through combination of match and index formula too. However, personally for me this is the most convenient way to do row and column vlookup in excel. If you have any specific queries on VLOOKUP in excel, feel free to write to us in the comment section below.