Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
If you want to remove blank rows from a dataset using a formula in Excel, you can do that by using the FILTER function. Below is an example where I have a dataset on the left, and then I’ve used the filter function to extract only those rows that are not blank on the right. …
Adding years to a date in Excel can be a bit tricky. This is because Excel stores dates as numerical values in the backend. So if I want to add one year to a date (say 1st January 2026), I have to ensure that I am adding the right number to my existing date, which …
In this article, I will show you some simple Excel formulas you can use to get the end-of-year date in Excel. Now if you’re wondering why you may even want that, and of course the end of the year date is going to always be 31st December of that year, here is the thing: Dates …
Sometimes you may have a large dataset that you are working with in Excel and you want to select alternate columns, or every third or every fourth column in your dataset. While there is no inbuilt feature to do this in Excel, there are some easy workarounds. In this article, I’ll show you three ways …
Pivot Tables come with a lot of in-built sorting options that allow you to structure your data the way you want. While you can use the regular sorting options (sorting A-Z / Z-A or Smallest to Largest or Largest to Smallest), there are also options to sort based on a custom list and even specify …
Thanks to some easy-to-use financial functions in Excel, it’s pretty easy to create a loan amortization schedule in Excel. In this article, I will show you how to create a simple loan amortization schedule, when you input the details (such as the principal amount, interest rate, and duration) in some cells, it instantly generates the …
If you work with phone numbers data in Excel, it would be useful to know how to properly format them. For example, if you’re working with phone numbers in the US, instead of just showing a 10-digit screen, you can format it to show in the following format: (123) 456-7890 If you are working with …
Do you know there’s a functionality to show a ruler in Excel that can help you align objects perfectly and set precise margins for printing? Just like you can show the ruler in Microsoft Word, you can also get that in Excel. Ruler is not one of the more used functionalities in Excel, which is …
If you work with Pivot Tables and also use slicers, you may sometimes wonder whether a slicer can be used to control multiple Pivot Tables. The answer is, of course, YES (otherwise I won’t be writing about it). This is useful when you have multiple Pivot Tables and you want all of them to update …
©trumpexcel.com – Free Online Excel Training
