When working with spreadsheets that contain names, keeping first and last names in separate columns is often convenient. This is because it makes filtering and querying easier. However, there may …
You may have come across situations where you needed to add a certain number of days to a date. Say, you have a company policy that allows you to dispatch …
Commas serve multiple purposes when working with spreadsheets. They make numbers more readable. For example, the number 1,452,346 is much clearer than the number 1452346. Commas also help delimit related …
Every software in the Microsoft Office package comes with its own purpose and application. Just like MS Word was built for word processing, MS Excel has been created to work …
Most people use spreadsheets software such as Microsoft Excel to process their data and carry out their analysis tasks. When performing an analysis of data, a number of statistical metrics …
Excel has some powerful Filter options (with inbuilt filter, advanced filter, and now the FILTER function in Office 365). But none of these options actually filter as you type (i.e., …
If you need to subtract a single value from a range of cells at the same time, there are multiple ways can do this in Excel. For example, suppose you …
If you’ve ever tried selecting alternate cells or cells in a particular pattern in Excel, you would know that this is not as easy as it seems. Well, if it …
The SUMPRODUCT function was always the go-to function for finding conditional sums, till the time SUMIFS was introduced in Excel 2007. A lot of people shifted to using SUMIFS instead …
When working with formulas, there is always a possibility that someone (or even you) may delete a cell (or clear the contents of a cell/range) that has formulas in it. …
If you work with data copied from the web into Excel, you would often get a dataset that has hyperlinks in it. For example, below is an example dataset where …