IITCA Technology and Beyond

Monday, November 26, 2018

Index with Match and Double Match - Beyond Advanced Excel

IITCA Super Trick #32 | Quick Move by Right Mouse and Shift Key

Add a drop-down list in Excel!

Adding a drop-down list will not only save you a number of rows but also prevent users to fill up a wrong value. Here is a quick explanation of how you can insert a drop-down list in your excel sheet.
Step #1: select the cell where you want to appear your drop-down arrow.
Step #2: Now from “Data” tab click on “Validation”.
Step #3:  Here in the “Allow” field, select “List” and type the cell source from where you are taking data to list, in my case it is from A10 to A16.





Wednesday, November 21, 2018

What is the current plan/offer in JioGigaFiber?

The current offer is JioGigaFiber preview offer which gives you ultra high-speed internet up to 100Mbps for 90 days along with a monthly data quota of 100 GB and a complimentary access to a host of Jio's premium apps. Incase, you consume 100 GB of your data quota within a month you can continue to enjoy our high speed internet services by performing a complimentary data top-up of 40 GB via MyJio App or through Jio.com. As this is a preview offer, there are no installation charges levied but there is a refundable security deposit of Rs.4,500 taken for the ONT device (GigaHub Home Gateway). This amount needs to be paid through Debit card, Credit Card, Jio Money or Pay TM.

One plus 7T non pro version is here and it's specs

The OnePlus 7 series is all set to be unveiled on May 14, and there's a lot of hype around it, and that's mainly due to the upcoming...