How to Insert Square Root Symbol in Excel (5 Easy Ways)
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 …
Formulas
How to Calculate Standard Error in Excel (Step-by-Step)
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 …
How to Filter as You Type in Excel (With and Without VBA)
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., …
How to Subtract Multiple Cells from One Cell in Excel
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 …
How to Select Every Other Cell in Excel (Or Every Nth Cell)
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 …
SUMPRODUCT vs SUMIFS Function in Excel
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 …
How to Auto Format Formulas in Excel (3 Easy Ways)
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. …
How to Extract URL from Hyperlinks in Excel (Using VBA Formula)
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 …