Microsoft Office 365 (Excel) Supported Exchanges List

Microsoft has been constantly improving its Stocks feature as well as adding more exchanges. Below is the latest supported exchange list as well as additional information related to the exchange. Buy Me a Coffee? Your support is much appreciated! PayPal Me:...

How to split an Excel file into multiple files using 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...

Building a folder generator app in Excel

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...

Reporting Automation For Beginners (Code Included)

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...

How to create a progress bar userform with 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...