Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
Excel is a great tool when it comes to data manipulation. There are many functionalities and functions in Excel that allow you to modify your data to get the desired result quickly. One common scenario is when you get your data with dashes/hyphens, and you want to remove them. For example, below, I have the …
While working with large datasets in Excel, you may need to clean the data to use it further. One common data cleaning step is to delete blank rows from your data in Excel. In this tutorial, I will show you how to remove blank rows in Excel using different methods. While there is no in-built feature …
Excel has so many unique features that sometimes, some of the features don’t get the credit they deserve. One such tool is the Status Bar in Excel. The Status Bar, as the name suggests, allows us to check the status of a few things (such as the cell mode or the macro recording status, or …
Coefficient of Variation (CV) is a common statistical metric used to understand the variability in your data set. While there is no inbuilt formula to calculate the coefficient of variation in Excel, it can easily be done by first calculating the mean and the standard deviation of the data set separately and then calculating the …
When I was working as a financial analyst a few years ago, we used to send our work as Excel files to our clients. One of the steps we were required to do before sending any file to the client was to mark it as final. When you mark a file as final, the file …
It’s common for Excel users to sort their data set when they’re analyzing. Sometimes, you may want to revert to the original data that you had before you did the sorting. In this tutorial, I will cover four techniques you can use to undo the sorting you have done on a dataset. The method you …
Sometimes, when working with a VBA code, you may want to put a pause on the code execution or delay the code running for a few seconds or tell a specific time. For example, if I’m using my VBA code to open a .exe file or any other format file (such as Word or PowerPoint), …
When working on an extensive Excel worksheet, you can avoid getting confused and overwhelmed by organizing columns into groups. This will enable you to easily show and hide different areas of the worksheet so that only relevant data is visible. In this tutorial, I will show you three methods to group columns in Excel. Note: …
As you scroll horizontally across a worksheet with many columns, the columns at the beginning of the worksheet scroll out of view. Usually, the first column (or the first few columns) has the headers for each row. And when you scroll to the right of your worksheet, it would be helpful if the headers in …
©trumpexcel.com – Free Online Excel Training
