Google Sheets is Google’s version of a spreadsheet like Excel. Google Sheets can be used online in a web browser and is great for sharing spreadsheets.
Some of the articles on this site cover both Excel and Google Sheets.
The MAX and MIN functions in Excel are used to find the largest and smallest values in a range of cells, respectively.
Read More The MAX and MIN Functions in Excel: Finding the Largest and Smallest ValuesThe COUNTIF function in Excel is used to count the number of cells in a range that meet a certain criteria.
Read More The COUNTIF Function in ExcelThe INT function in Excel and Google Sheets, is used to round a number down to the nearest integer, or give you a whole number.
Read More Using INT() in Excel and Google SheetsHere are five common Excel mistakes that people often make, that you should be aware of and how to avoid them.
Read More Common Excel MistakesVLOOKUP is a very powerful tool in Excel, when interviewing candidates for jobs, I would ask them about their English, Maths and VLOOKUP skill
Read More Using Vlookup in Excel (and Google Sheets)The ISERROR function in Excel is a useful tool that allows you to check if a value is an error, and return a specific value if it is. This can be especially helpful when working with large datasets, as it allows you to identify and handle errors quickly and easily.
Read More Using iserror in excelDuplicate values in a column can cause a variety of problems in Excel. For example, they can distort any statistical analysis you may be performing, or make it difficult to find unique values in your data. That’s why it’s important to check for duplicates and remove them if necessary.
Read More How to check if a column has duplicate values in excelCalculating the number of days between two dates in Excel is a relatively simple task, and can be done using the “DATEDIF” function. This function allows you to specify the start date, end date, and unit of time you want to use to calculate the difference. For example, to calculate the number of days between 1/1/2022 and 1/5/2022, you would use the following formula.
Read More How to calculate the difference between two dates in excelExtracting a first name and surname from a full name in Excel can be a useful way to organize and sort data. There are a few different approaches you can take to accomplish this task.
Read More How to separate first name and surname in excel