Excel Formula tips and tricks to make you a champion in Excel. A lot can be done when you know the right Formula hack.
Running total (also called cumulative sum) is quite commonly used in many situations. It’s a metric that tells you what’s the sum of the values so far. For example, if you have the monthly sales data, then a running total would tell you how much sales have been done till a specific day from the …
Sometimes, you may have a need to flip the data in Excel, i.e., to reverse the order of the data upside down in a vertical dataset and left to right in a horizontal dataset. Now, if you’re thinking that there must be an inbuilt feature to do this in Excel, I’m afraid you’d be disappointed. …
When working with data in Excel, you’ll often have the issues of handling outliers in your data set. Having outliers is quite common in all kinds of data, and it’s important to identify and treat these outliers to make sure that your analysis is correct and more meaningful. In this tutorial, I’ll show you how …
I was recently working on a project where I had dates in Excel and I had to find out what quarter of the year it was based on the date. For the purpose of this tutorial, let’s consider the following: In case you’re working with financial data where the quarter starts from April, then you …
Normally, when I use the word range in my tutorials about Excel, it’s a reference to a cell or a collection of cells in the worksheet. But this tutorial is not about that range. A ‘Range’ is also a mathematical term that refers to the range in a data set (i.e., the range between the …
Sometimes, you may need to know what’s the first day of the month based on a given date. When there is no dedicated function to get the first day of a given month, you can easily use a workaround to find it. In this Excel tutorial, I’ll show you some really simple formula that you …
Microsoft Excel stores dates and times as numbers, which allows the user to easily add and subtract days to a date in Excel. It also makes it really easy when you want to find out the total number of days between two dates, as you can simply subtract one from the other. In this tutorial, …
Excel stores date and time values as serial numbers in the back end. This means that while you may see a date such as “10 January 2020” or “01/10/2020” in a cell, in the back-end, Excel is storing that as a number. This is useful as it also allows users to easily add/subtract date and …
When working with text data in Excel, you may have the need to remove the text before or after a specific character or text string. For example, if you have the name and designation data of people, you may want to remove the designation after the comma and only keep the name (or vice-versa where …
©trumpexcel.com – Free Online Excel Training
