A common task in Excel often involves taking a set of data and tallying the number of occurrences that match certain...
How to use the COUNTIF function in Excel
read more
Spreadsheets articles
How to use the YEAR function in Google Sheets
Dates are a common type of data that most of us have had experience with using in our spreadsheet datasets. Nowadays,...
How to use the CONCATENATE function in Excel
Microsoft Excel is an extremely versatile tool that can be used for a wide variety of applications. When you think of...
How to use the IF function in Excel
The IF function in Excel is undoubtedly one of the most useful functions there is. It is used to perform logical tests...
How to use the INDEX MATCH Excel function combination
The INDEX and MATCH functions in Excel are both useful for a variety of purposes. But when you combine the two...
How to convert Google Sheets to Excel automatically
Do you routinely need to convert Google Sheets files to Excel? Often find yourself copy-pasting data from one file...
How to use the Google Sheets SPARKLINE function
If you want a quick way to analyze your spreadsheet data visually without building full charts, the SPARKLINE function...
How to use the VLOOKUP Google Sheets function
The VLOOKUP Google Sheets function is perhaps one of the most widely used functions in Google Sheets. It stands for...
How to use the LEN function in Google Sheets
With spreadsheets, you often find yourself dealing with text in addition to numbers. Google Sheets has a multitude of...
English 
Español 
Português do Brasil 
Français