Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
When working with VBA in Excel, you may have a need to split a string into different parts based on a delimiter. For example, if you have an address, you can use the VBA Split function to get different parts of the address that are separated by a comma (which would be the delimiter in …
In this tutorial, you’ll learn how to find the last occurrence of an item in a list using Excel formulas. Recently, I was working on setting the agenda for a meeting. I had a list in Excel where I had a list of people and the dates on which they acted as the ‘Meeting Chair’. …
Microsoft applications such as Word, Excel, PowerPoint are used in almost every large organization as well as by millions of small businesses, freelancers, and entrepreneurs. For something that is so popular, it makes sense to have a decent knowledge on how to use these applications efficiently. In some job roles, a major part of the …
When you create or record a macro in Excel, you need to run the macro to execute the steps in the code. A few ways of running a macro includes using the macro dialog box, assigning the macro to a button, using a shortcut, etc. Apart from these user-initiated macro executions, you can also use VBA …
I recently had to get myself registered under Goods and Services Tax (GST) so that I can file for GST on my earnings. Once you have a GST number, you need to file your tax return every month (in India). So every month, my Charted Accountant would reach out to me asking for sales invoices …
With VBA, you can create a custom Function (also called a User Defined Function) that can be used in the worksheets just like regular functions. These are helpful when the existing Excel functions are not enough. In such cases, you can create your own custom User Defined Function (UDF) to cater to your specific needs. …
In this tutorial, I will cover the how to work with workbooks in Excel using VBA. In Excel, a ‘Workbook’ is an object that is a part of the ‘Workbooks’ collection. Within a workbook, you have different objects such as worksheets, chart sheets, cells and ranges, chart objects, shapes, etc. With VBA, you can do …
Apart from cells and ranges, working with worksheets is another area you should know about using VBA efficiently in Excel. Just like any object in VBA, worksheets have different properties and methods associated with them that you can use while automating your work with VBA in Excel. In this tutorial, I will cover ‘Worksheets’ in …
When working with Excel, most of your time is spent in the worksheet area – dealing with cells and ranges. And if you want to automate your work in Excel using VBA, you need to know how to work with cells and ranges using VBA. There are a lot of different things you can do …
©trumpexcel.com – Free Online Excel Training
