Recently I was working on a project where I had to filter all the cells that had strikethrough form…
Read moreSometimes you may want to write text vertically in Excel to save space and make your data more pres…
Read moreExcel has three types of worksheet views: In most cases, you will be working with the Normal view. …
Read moreWhenever you open a new Excel workbook, you will see that a default font type and font size have al…
Read moreThe P-value is an important concept in statistics that is often used in hypothesis testing and deci…
Read moreExcel has an in-built MEDIAN function, but there is no MEDIANIF function. But that’s not an issue. …
Read moreIn some situations, you may have the month name that you want to convert into the month number so t…
Read moreChoosing the right fonts for your Excel spreadsheets can make a big difference in readability and v…
Read moreRecently, I was working on a project where I had data in multiple rows, and I needed to combine the…
Read moreExcel worksheets are made up of cells with default heights and widths. In most cases, you will need…
Read moreIn this article, I will show you how to convert days to months in Excel using a couple of simple fo…
Read moreIt’s easy to add sheet names to header or footer in Excel. Once done, the sheet name will appear In…
Read moreIf your Excel application is crashing or causing issues, you can try opening it in the ‘Safe Mode’.…
Read moreNeed to find out which version of Microsoft Excel you have? It’s pretty easy to do and only takes a…
Read moreOne formatting option you can use when you want to highlight a specific text or cell is the underli…
Read moreRemoving duplicates is a common task for most data workers. While in most cases, you would be worki…
Read moreRemove asterisk (*) symbol In Excel is a little tricky as it’s a wildcard character and you cannot …
Read moreDates are stored as numbers in the backend in Excel and can easily be sorted. But what if you want …
Read moreIt’s not uncommon for many people to protect worksheets in their Excel files and then forget the pa…
Read moreConditional formatting in Excel allows you to format cells based on the values in the cells. The bu…
Read moreExcel is an amazing spreadsheet tool, but there are some things that drive me crazy. One such thing…
Read moreWhen you’re working with the data set that has hidden rows, and you select and copy the cells in th…
Read moreExcel has the SUMIF and SUMIFS functions that allow you to add a range of cells based on one or mor…
Read moreExcel add-ins are helpful when you want to enhance the functionalities in Excel and do things not a…
Read moreAmong the many awesome features in Excel, Name Box doesn’t get talked about enough. While it looks …
Read moreWhen doing data entry work in Excel, you may want to prevent entering duplicate entries in a column…
Read moreConditional Formatting allows you to add a visual layer to your dataset and make it easier to under…
Read moreMost of my work involves getting data from various sources, such as databases, webpages, or other p…
Read moreThere are multiple ways to calculate the square of a number in Excel. You can use the in-built POWE…
Read more
Social Plugin