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.
Automate Excel Pivot Table With VBA
In this tutorial series, you will learn how to automate Pivot Table in Excel using VBA. Pivot Table is probably one of the most useful and powerful features in Excel, especially for reporting and data analysis. Using pivot table, we can extract useful information that...
Source Code: How to combine Excel worksheets using Excel VBA (Excel Macro)
Buy Me a Coffee? Your support is much appreciated! PayPal Me: https://www.paypal.me/jiejenn/5 Venmo: @Jie-Jenn Source Code: Const MasterSheetName As String = "Movie List" Sub Combine_Movie_List() Dim wsMaster As Worksheet, ws As Worksheet Dim LastRow As...
Create an Excel Data Entry Form in Excel Source Code
In this Excel tutorial, I will be showing you how to create an Excel Data Entry Form Template from scratch using the built-in the built-in Userform editor. (The tutorial will be involving writing VBA code, but I will walk you through everything). Why build you own...
Excel macro to combine multiple CSV files (with Excel VBA)
In this Excel automation tutorial, I will show you how we can write a macro (using Excel VBA) to combine multiple CSV files. Imaging your boss asks you to combine 10 or 50 CSV files by the end of the day, and you only have couple hours left. If you are going to do...
Create a Macro To Spit a CSV File Into Multiple CSV Files with Excel VBA
In this video, I will be showing how to write a macro to split a CSV file into multiple CSV files using Excel VBA. Splitting a CSV file or an Excel file is probably one of the most common tasks in work places, and instead of manually doing it by hand to waste...
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...
