Microsoft Excel Tutorial
Microsoft Excel, probably one of the most important software ever created. With more than one billion Microsoft Office users worldwide, it is hard to live without Excel these days. You can use Excel for so many things; organizing personal finance information, building customizez caulcuator, performing different types of analysis, making stunning graphs, and much more.
I hope from my blog, you will learn many new Excel skills to help you to work more efficiently.
Excel VBA Macro to Combine Worksheets in Excel
IF you use Microsoft Excel a lot, especially at work, it's a huge pain to combine multiple worksheets into a single master worksheet. Good thing we can automate just about any Excel work with VBA (aka Excel Macro). In this Excel tutorial, I will be sharing a VBA...
Replace drop-down by building a Userform in Excel | Full Tutorial
One of the biggest drawbacks with cell drop-down in Excel is the limitation of functionalities you can implement. For example, unless you are a Microsoft 365 subscribers, it is pretty difficult to implement the search functionality, as well as, increasing the...
How to create a VBA macro to export multiple worksheets to a new Excel file
In this tutorial, we are going to write a macro using VBA, to export multiple worksheets from an Excel file (let's call it the master Excel data file) to a new Excel file. Buy Me a Coffee? Your support is much appreciated! PayPal Me: https://www.paypal.me/jiejenn/5...
Create an Excel Userform to export worksheets – Step-By-Step
In this tutorial, we will be learning how to create an Excel userform to ease the manual labor of exporting multiple Excel worksheets to individual Excel file. We will be writing VBA to implement various of functions and automations, some experience in writing macros...
How to create a function to validate IP addresses in Excel with VBA
In this Excel VBA tutorial, we will be creating a User-Defined Function (aka UDF) to validate if IP addresses are valid. Assuming you have a spreadsheets with a list of IP addresses, and your job is to validate whether each IP address is valid. My personal experience...
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 Loan Calculator in Excel Step-By-Step | Excel Tutorial
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...
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...
