Dec 18, 2019 | Excel, Excel General
In this tutorial, we are going to learn how to build a simple loan calculator application in Excel. If you ever wanting to take out a car loan or a mortgage loan, it is always a good to figure out how much interest payment over the periods of time based on the amount...
Oct 28, 2019 | Excel, VBA
In this tutorial I am going to show you how to create a Folder Generator App in Excel. We will be writing some VBA to perform the folder creation. Download the template Download Download the final file Download VBA Code:
Aug 19, 2019 | Excel, VBA
Microsoft Excel Reporting AutomationExcel VBA makes a amazing tool to automate reporting. If you work in Accounting or Finance, then being able to create a macro to automate a reporting that usually takes half hour to merely just a minute, and you can re-use the the...
Aug 19, 2019 | Excel, VBA
Excel Progress Bar UserformA progress bar is a great way to presenting the current progress of something that is currently running. In Excel, the software does not come with a progress bar widget by default, but that does not mean we cannot create it on our own.In...
Jun 27, 2019 | Excel, Excel General
Believe or not, I have encountered this problem quiet many times – “How to get the count of unique items from a column from a table that has duplicate records or has multiple layers.In this tutorial I will show you how to use an array formula to get the...
Jun 19, 2019 | Excel, VBA
In this tutorial I will share a VBA Function (User-Defined Function) that can detect whether if a file is currently opened. data-ad-client="ca-pub-3255865697013143" data-ad-slot="2278613244" data-ad-format="auto" data-full-width-responsive="true"> VBA...
