Want to keep yourself up to date with the latest news from Excelmaster101?
Subscribe using the "Follow" button below and we provide you with customized updates, via topic or tag, that get delivered to your email address, your smartphone or on your dedicated news page on follow.it.
You can unsubscribe at any time painlessly.
Title of Excelmaster101: "MS Excel Master 101"
Is this your feed? Claim it!
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 ... title="Get End of Year Date in Excel (Easy Formula)" class="read-more" href="https://trumpexcel.co...
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 ... title="Select Every Other Column in Excel" class="read-more" href="https:...
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 ... title="Sort Pivot Table in Excel" class="read-more" href="https://trumpexcel....
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 where everything is fixed, and also give you a template where you can make pre-payments or change the interest rates. Click ... title="Loan Amortization Schedule in Excel (...
