Author: Aniruddh

  • Asus Zenfone Max Pro M1 FAQ Tips and Tricks Cons

    Asus Zenfone Max Pro M1 is specially developed for Indian consumer according to Asus.  Max series from Asus is known for having the large capacity battery. Zenfone Max Pro M1 offers a lot more apart from the large battery. Snapdragon 636 processor, dedicate microSD card slot, 18:9 ratio display panel, Dual camera setup, Pure Android and very competitive pricing are the key USP of this device. In this post, let’s have a quick look at Asus Zenfone Max Pro M1 FAQ Tips and Tricks and Cons.

    You may be interested

    Asus Zenfone Max Pro M1 Review

    Asus Zenfone Max Pro M1

    Asus Zenfone Max Pro M1 FAQ Tips and Tricks Cons

    What are the different variants of Asus Zenfone Max Pro M1 are available in India? What is the price of Zenfone Max Pro M1 in India?

    Currently. two variants of  Zenfone Max Pro M1 are announced in India. One with 3GB of RAM  and 32GB of internal storage which is priced at Rs.10,999 and other variant has 4GB of RAM and 64GB of internal storage.

    Does it has dedicated microSD card slot? What type of sim card does it support?

    Yes. It has dedicated microSD card slot. The device supports 2 nano sim cards.

    What are the key specifications of Asus Zenfone Max Pro M1?

    Specification summary:

    • 5.99 inch full HD plus display panel with 18:9 aspect ratio.
    • Android Oreo 8.1
    • Snapdragon 636 SoC.
    • 3GB RAM and 32GB of internal storage/4GB RAM and 64GB of internal storage.
    • 5000 mAh battery with fast charging feature.
    • 13MP and 5MP dual camera setup in the rear.
    • 8 Megapixel front-facing camera.

    What are the pros of Asus Zenfone Max Pro M1

    The merits of Zenfone Max Pro M1 are

    • Good build quality.
    • Best in the class display panel, in the price range.
    • Good performance.
    • Great value for money.
    • True dual sim 4G LTE support.

    How to take the screenshot on Asus Zenfone Max Pro M1?

    To capture screenshot on this device, just press and hold volume down and power button simultaneously. The screenshot will be captured. For detailed steps read how to take a screenshot on Zenfone Max Pro M1.

    Video Guide:

    What are the cons of Asus Zenfone Max Pro M1?

    Based on our initial impression, here are the list disadvantages of Zenfone Max Pro M1.

    Asus Zenfone Max Pro M1 Cons

    • No corning gorilla glass protection.
    • No Optical or electronic image stabilization for video recording.
    • Front Camera performance is not great.

    These are the most commonly asked question of Zenfone Max Pro M1. We will publish detailed Asus Zenfone Max Pro M1 review in the coming days. If you have any queries, please share it in the comment section below.

  • Vivo V9 Features FAQ Cons

    Vivo V9 new selfie centric flagship has been launched in India with some interesting features. A large 6.3-inch bezel-less display, 24MP front facing camera, dual camera setup in the back, AI integration on both camera, Android 8.1 Oreo are the key attraction of this smartphone. In this post, let’s look into Vivo V9 Features FAQ and Cons.

    Vivo V9 Features FAQ Cons

    What are the different color variant of Vivo V9 available in India?

    This new selfie centric flagship from Vivo will be available in Champagne Gold and Perl Black color variants.

    From when Vivo V9 will be available for purchase in India and where to buy?

    Vivo V9 will be available starting 2nd April 2018. It will be available in Flipkart, Vivo E-Store, Amazon, and Paytm mall.

    What are the specification of Vivo V9

    • Dual Rear Camera(16MP + 5MP).
    • 19:9 Full View 6.3 inch Full HD + Display.
    • Qualcomm Snapdragon 626 Octa Core SoC with 4GB of RAM and 64GB of internal storage.
    • Face Access 2.0 and Game mode.
    • 3260mAh battery.

    How is the display on this device?

    Vivo V9 sports a large 6.3 inch full HD +  bezel-less display. Except for a notch in the top center, the front is fully covered with the display screen. The company claims it has industry’s highest 90% body to screen ratio. With the limited usage, we felt display panel on the device has good brightness and offers decent viewing angles.The color saturation, sharpness are also decent.

    What are the features of Camera on this device?

    Vivo V9 has 24MP front-facing camera with f 2.0. In the back it has two camera setup. One has 16MP and another one is 5MP. This dual camera setup host of other features such as Ultra HD, Slo-mo, Live Photos, Retina Flash and AR Sticker.  The 24MP front-facing selfie camera coupled with AI Face Beaty feature is claimed to provide clear and beautiful selfies.

    What are the key advantages of Vivo V9?

    This is not a review. Based on our first impression at the launch event, here is the list of Vivo V9 pros.

    • The large display panel in a compact size.
    • 24MP selfie camera.
    • Dual camera setup in the back.
    • AI integration on both camera.
    • Dedicated microSD card slot.

    What is the price of Vivo V9 in India?

    Vivo V9 price in India is 22,990.

    What are the cons of Vivo V9?

    • There is no USB-C port.
    • No support for fast charging.
    • Price could have been more aggressive.
  • Excel Formula to Convert Date To Weekday Name Or Month Name

    How to convert a date to Weekday Name Or Month Name or Year? For example 13-03-2018 to Tuesday or March or 2018. This is one of the most frequently asked queries. So let’s learn an Excel Formula to Convert Date To Weekday Name Or Month Name.

    Recommended Reading

    Excel Tips

     

    Excel Formula to Convert Date To Weekday Name Or Month Name

    Excel Formula to Convert Date To Weekday Name Or Month Name or Year

    One of the frequently used EXCEL formula to convert date to Weekday Name Or Month Name or year is TEXT Function.

    The syntax of text function in excel

    TEXT( value, format )

    The TEXT excel function is the easiest formula to use for converting Date To Weekday Name Or Month Name. Let’s learn this with an example.

    We have a date in cell A2 has 13-03-2018(Date-Month-Year format)

    Now we will use TEXT Function

    =text(A2, “ddd”) will return “Tue

    =text(A2, “dddd”) will return “Tuesday

    =text(A2, “mmm”) will return “Mar

    =text(A2, “mmmm”) will return “March

    =text(A2, “yyyy”) will return “2018

    =text(A2, “m”) will return “3

    =text(A2, “d”) will return “13

    Summary of the examples mentioned above.

    A2 is the value or the reference to the cell where date is present.

    The second argument of TEXT function accepts format, You can use the format based on your requirement as mentioned below.

    1. “ddd” will return first three characters of the week name.
    2.  “dddd” will return full week name.
    3. “mmm” will return first three letters of the month name.
    4. “mmmm” will return full name of the month.
    5. “yyyy” will return year.

    Using TEXT function to convert Date To Weekday Name Or Month Name ideal in the scenario where you want the result to be shown in the different cell. If you just want to convert to the same cell, then format cell will be the best option.

     

  • Samsung Galaxy A8 Plus Cons- Reasons not to buy

    Samsung Galaxy A series smartphones are considered as the toned down version of the flagship. Galaxy A8 plus is not an exception to it. It borrows a lot of features such as infinity display,  best in class design, water, and dust resistance etc from Galaxy S8 and Galaxy Note 8. Priced at Rs.32,990, it is a premium mid-range smartphone. Hence we try to list down some of the key Samsung Galaxy A8 Plus Cons according to us in this post. This is based on the availability of feature on other smartphone at the same price range.

    Samsung Galaxy A8 Plus Cons- Reasons not to buy

    No Android Oreo update

    Samsung Galaxy A8 Plus launched in the month of Jan 2018. Therefore we expected it to ship with the latest version of Android, i.e Android Oreo. Unfortunately, Samsung opted to ship with Android Naugat. Considering the past experience, the device will take a long time to get the latest version of Android.

    Lacks 4K video recording support

    Priced at 33k, comparing with competition, lack of 4K video recording capability is a demerit of Samsung Galaxy A8 Plus.

    No Optical Image stabilization

    Touted as a camera-centric phone, it is surprising that Samsung omitted the optical image stabilization option. The lack of OIS will be felt while capturing photos in low light and artificial lighting condition.

    These are some of the cons of Samsung Galaxy A8 Plus. There are many things which are merits of this which we will list down below.

     Samsung Galaxy A8 Plus Pros

    • Best in class design and build.
    • Good performance.
    • Infinity Display.
    • Good battery life.
    • IP68 certification for water and dust resistance and Samsung Pay with MST technology.
    • Ample RAM and storage space.

    Galaxy A8 Plus is a promising premium midrange smartphone. Samsung has done a good job in most of the segment. Competetive pricing could have made this smartphone much more impressive.

  • Xiaomi Mi TV 4A Key Features

    After becoming India’s largest smartphone seller, Xiaomi is eying for capturing Indian TV market. It has launched affordable smart TV lineup Mi TV 4A in India on March 7 and the first sale will begin on March 13. The Mi TV 4A lineup consists of 43 inch and 32-inch smart tv.

    Below are the key features of the Mi TV 4A

    Mi TV 4A

    Xiaomi Mi TV 4A Key Features

    Screen

    Xiaomi Mi TV 4A base variant sports 32 inch HD display panel(720p resolution) and another variant has 43-inch full HD(1080p) display. Both variants claim to provide a viewing angle up to 178 degree.

    Hardware and Software

    The Mi TV 4A is powered by Amlogic 64-bit quad core chipset coupled with 1GB of RAM and 8GB of internal storage.  It runs on Android-based PatchWall UI. Patchwall is an AI-enabled TV system which helps to customize the content based on user preferences.

    Using the Patchwall, users can access content from several partners such as Voot, Sony Liv, Hungama etc. Some of them are free and some of the content is paid.

    It comes with  DTS and 20W dome speakers. The Mi TV 4A package has 11-button MI Remote.

    Connectivity

    Mi TV 4A has a lot to offer when it comes to connectivity. The 32inch variant of Mi TV4A has three HDMI ports, two USB ports, Ethernet port, WiFi and a headphone jack. The 43-inch variant provides one additional USB port and a S/PDIF port.

    Pricing

    The 32inch variant of Mi TV 4 A price in India is Rs.13,999 and 43-inch variant price in India is Rs.22,999. Like Xiaomi smartphones, these TV’s also will go on sale via flash sale starting from March 13. The flash sale will be held on every week Tuesdays and Wednesday. The new smart tv’s will be sold via mi.com, Mi Home, and Flipkart.

    Xiaomi entered Indian TV segment with the launch of Mi TV 55 inch at Rs.39,999. 4K Video support and Bluetooth connectivity are the additional features of it apart from larger screen size.