Skyneel – Android guide, driver, root, ROM update, excel, review, App

Lookup Multiple Fields of Data with Excel VLOOKUP

| In: Office Guide | Last Updated:

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 show an Emergency contact number on your Smartphone

| In: Tech Guide | Last Updated:

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

How to divert mobile phone calls to any number

| In: Tech Guide | Last Updated:

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

| In: Office Guide | Last Updated:

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

| In: Tech Guide | Last Updated:

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

| In: Root Guide | Last Updated:

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

| In: Office Guide | Last Updated:

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