Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
When working with dates and making project plans in Excel, you may come across a situation where you want to know how many weeks there are between two dates. While there is no built-in function to do this in Excel, this can easily be done using other simple functions. In this short article, I will …
Sometimes, when working with text data in Excel, you may want to add parentheses around the text in a cell or range of cells. For example, below, I have a data set with the region name in column A, and I want to put these names in parentheses or brackets. As always, Excel offers multiple …
Sometimes, in my work, I have to check if a cell or a range of cells contains the partial text I’m looking for. For example, suppose I want to check whether a cell contains the text string “ABC” or not. The cell may have additional strings or characters, but as long as it has the …
The Pi symbol (Ï€) represents a mathematical constant that is used when calculating the area circumference of a circle. I’m sure you must have seen and worked with the Pi symbol in your geometry and math classes, and it also has a lot of practical applications in the real world. In this article, I will …
Interquartile Range (IQR) is often used in statistics to identify outliers and understand the spread of the middle 50% of the data set. Interquartile Range allows you to analyze data without it getting skewed by outliers and extreme values. This helps us get a better view of the variability of the data as compared to …
If you want to get the highest value in a column or a range, you can easily do that using the built-in MAX function in Excel. But what if you want to get the second largest value, the third largest value, or the nth largest value from the same data set? In this scenario, you …
Once you’re done using formulas to get the desired results, you may want to remove the formulas and keep the data you got as a result of these formulas. This is often done to remove formulas you no longer need and save processing power (as formulas recalculate every time you make a change in the …
Sometimes, when you’re organizing data, creating charts, or analyzing information, you may need to swap two cells (i.e., change the position of two cells). While there is no built-in feature in Excel to swap cells, this can easily be done using a simple mouse drag-and-drop technique or the old and traditional Cut-Paste method. In this …
Most of the time, the data in Excel is arranged in columns, and it is more common to split the text in a cell into multiple columns rather than rows. But in some cases, you may want to split the text into multiple rows in Excel. For example, if you have multiple names in a …
©trumpexcel.com – Free Online Excel Training
