Steve Scott 
Mean Squared Error (MSE) is an important calculation in regression modeling. It is the mean of the squared difference between the actual values and the expected (forecasted) values. If you’re …
To concatenate in Excel is to combine data from multiple cells into one cell. Therefore, to do the opposite of concatenation or reverse concatenation is to split the contents of …
Autosave is a new feature in Excel 365 that automatically saves files stored online on OneDrive or SharePoint every few seconds as we work. The benefits of the Autosave feature …
AutoFill is a handy feature in Excel that automatically fills in data for you (given that Excel recognizes the pattern that you specified). This feature is turned on by default. …
Sometimes we need to convert measurements from one measurement unit to another measurement unit. Converting KG to lbs (Pounds) is very common in our day-to-day life. If you work with …
Sometimes we need to count cells that are not empty. While you may be able to do it manually with a small dataset, it could be quite difficult to do …
Dates in Excel are saved as serial numbers where the date January 1, 1900, is stored as the number 1, and each following day is stored as the following consecutive …
Microsoft Excel is a powerful tool for data management and analysis. Sometimes in Excel, we want to count cells that meet some predefined criteria, such as counting cells less than …
The coefficient of variation is one of the relative measures of dispersion. The ratio between the standard deviation and the mean is known as the coefficient of variation. This is …
One of the essential operations in Excel is summing numbers in a column. So, for example, we can calculate a column to determine the total tuition fees paid in by …
When working with Excel, most Excel users refer to cells/ranges in the same worksheet and sometimes may have to refer to other cells or ranges of cells in one or …
One of the essential Excel operations to summarize data is counting the number of cells in a dataset containing particular data types. It’s a common task for many Excel users …