Excel Tips: Google Sheets

Edit

How to add prefix or suffix into cell values in Google sheets?

How to autofill weekdays exclude weekends in a list of Google sheet?

How to calculate currency conversion in Google Sheet?

How to change case to UPPER/lower/Proper in Google Sheet?

How to combine / merge multiple sheets into one sheet in Google sheet?

How to combine date and time columns into one column in Google sheets?

How to combine multiple columns into one single column in Google sheet?

How to concatenate multiple cells with line break in Google sheet?

How to copy row to another sheet based on cell value in Google sheet?

How to delete all rows containing specific text within a column in Google sheets?

How to extract first or first two words from text strings in Google sheet?

How to extract numbers only from text strings in Google sheet?

How to insert timestamp automatically when data is updated in another column in Google sheet?

How to reverse text strings within cells in Google sheet?

How to reverse the first name and last name within cells in Google sheet?

How to select random cells from a list in Google sheets?

How to split a cell vertically in Google sheet?

How to split cell contents into columns or rows based on newline in Google sheet?

How to split cell into columns in Google Sheet?

Insert

How to get list of sheets names in Google sheets?

How to insert an image in cell within a google sheet?

How to insert bullet points into cells of Google sheet?

How to insert multiple rows or columns quickly in Google sheets?

How to insert multiple rows or columns quickly in Google sheets?

Data

How to auto sort data alphabetically in Google sheets?

How to compare two columns and find the duplicate or missing values in Google sheet?

How to create a dependent drop down list in Google sheet?

How to filter data based on drop down list in Google sheet?

How to filter data by multiple conditions in Google sheets?

How to filter rows based on cell color in Google sheet?

How to insert date picker in Google sheet?

How to insert drop down list in Google sheet?

How to prevent duplicate entry in Google sheets?

How to sort date by month ignoring year in Google sheets?

How to sort full names by last name in Google sheets?

How to sort or shuffle data in a list randomly in Google sheets?

Calculation & Formulas

How to add number of years months and days to date in Google sheets?

How to calculate age from birth of date in Google sheet?

How to count number of occurrence in a column in Google sheet?

How to count or sum cells based on cell color in Google sheet?

How to count or sum cells based on cell color in Google sheet?

How to find the most common text value in a list in Google sheets?

How to reverse vlookup function in Google sheet?

How to sumif cell values between two given dates in Google sheets?

How to vlookup and return multiple matching values at once in Google sheet?

How to vlookup matching value from another google sheet?

Others

How to conditional formatting based on another sheet in Google sheet?

How to conditional formatting duplicate cells in a column in Google sheet?

How to highlight or conditional formatting the max or min value in Google sheet?

How to quickly convert a workbook to google sheet?

How to share only one specific sheet to others in Google sheet?