ISBLANK function in excel
by In this lesson we will learn how the ISBLANK function works in excel. The ISBLANK function is used to check if any cell is empty …
How to Swap Rows in Excel
In this lesson we will learn how to move and swap rows in Excel. Move rows means the particular rows will be moved to the …
How to Swap Rows in Google Sheet
In this lesson we will learn how to move and swap rows in Google Sheet. Move rows means the particular rows will be moved to …
How to get last value in a column in Excel
In this lesson we will learn how to get the value in the last non empty cell of a column in Excel. We will understand …
How to share a Google Sheet
In this lesson we will learn how to share a Google Sheet. To share a Google sheet follow the below process. Click the ‘Share’ button …
LOWER function in Excel
The LOWER function converts the upper case texts to lower case in Excel. =LOWER(text) text: This is the string in which you want to convert …
UPPER function in Excel
The UPPER function converts the lower case texts to upper case in Excel. =UPPER(text) text: This is the string in which you want to convert …
RANDBETWEEN function in Excel
In Excel we can use RANDBETWEEN() function to generate the random number in a specified range. Like here in cell A2 we have used RANDBETWEEN() …
How to track changes in Excel
In this lesson we will learn how to track changes in Excel workbook. To track changes in excel click ‘Track Changes’ in ‘Changes’ group under …
How to share workbook in Excel
In this lesson we will learn the process of sharing an excel workbook. To share the workbook we need to click ‘Share workbook’ option available …