Lot of time many peoples facing these issue like computer crashes, power goes out, accidentally close any file without saving and many more. In that situation you may lost of your working data, and you need to know how to autosave Excel file. There are lot of ways to auto save Excel file either using Autosave feature or using the code. Read More
Lookup Multiple Fields of Data with Excel VLOOKUP
With the combination of Excel VLOOKUP function with the Column, Column and array function you can easily create a lookup formula which allows you to quickly lookup multiple fields of data with Excel VLookup function. Excel VLookup function with array or column function easily return multiple values from a single row of a database or array of table. Read More
How to save and extend your Android smartphone battery life
How to save and extend your Android smartphone battery life is one of the most important query raised by the smartphone users. Smartphone batteries don’t last forever and if you see overtime, we have seen many changes in the smartphone technology. In earlier Android smarpthone used either for calling or messaging. Read More
How to show an Emergency contact number on your Smartphone
Approx 80 to 90% smartphone users lock his smartphone due to different reasons. But sometime in case of emergency you must add or show an emergency contact number on your smartphone locked screen. But if you don’t setup emergency contact number on your phone then nobody call to your family members in case of any emergency. This is very essential and
helpful feature for us. We must add an emergency contact to our phone’s lock screen. Read More
OnePlus 6 OxygenOS 5.1.6 Oreo Stock Rom [Full Rom + OTA]
Hi, OnePlus launched OxygenOS 5.1.6 stock Rom for OnePlus 6. This is a OnePlus 6 OxygenOS 5.1.6 based Android 8.1 Oreo and here is an easy and safe tutorial for install OnePlus 6 OxygenOS 5.1.6 Oreo Stock Rom. Read More
How to divert mobile phone calls to any number
Sometime when you are on the tour and your phone battery is going to die in that situation there is no way to get the call on your phone. But in that case you can easily divert mobile phone calls to any number using the secrete codes. Many time when you are doing some important things and you will be disturb due to receive any call or downloading will be stop. Read More
How to use LEFT Function with Find Function
Sometime we need to extract few characters of a string with the help of Left function. In this guide we have to discuss how to use Left function with Find function to extract the worlds. Excel allows you to use a user defined function to split a text string as per your need. To quickly split text string at specific character then you must have to know how to use Left function with Find function. Read More
How to turn on or turn off scroll lock key
Sometime you feel that you can no longer moving around the workbook area properly due to the scroll lock key. Most of the person facing lot of issues to turn on or turn off scroll lock key at his system. During working on excel sheet When you press any arrow key you feel column or rows are moving at the place of cursor moving to another cell. Read More
How to root Huawei P20 with TWRP
Hi, This is a tutorial to Unlock Bootloader, Install TWRP and Root Huawei P20. In this guide you will find all steps with image, therefore it is safe and easy method of Unlock Bootloader, Install TWRP and Root Huawei P20. Read More
How to switch or flip name in Excel
Sometime you need to flip the first and last name within the cell. Mostly peoples use cut and paste method to easily switch or flip name in Excel sheet. You can also use retyping method of reverse the first name and last name within cells. These are the simple ways to reordering the first and last name. Now, in this guide we’ll discuss another way which quickly allows you to switch or flip name in Excel sheet. Read More