Mar 10, 2020 | Excel, VBA
In this tutorial, we are going to write an automation script to split a table in Excel using VBA. Using VBA, you can break down a source worksheet to multiple Excel file based on the values in the selected key columns, and doing so, will keep your data secure without...
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. Buy Me a Coffee? Your support is much appreciated! PayPal Me: https://www.paypal.me/jiejenn/5 Venmo: @Jie-Jenn Download...
Aug 19, 2019 | Excel, VBA
Microsoft Excel Reporting Automation Excel 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...
