Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
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 …
Want to convert a PDF to Excel? Here is a tool that you can use to extract data from PDF to Excel with a high accuracy and format. You also don’t need to give your email address or upload your PDF files anywhere. This tools is completely secure and convert PDF to Excel in seconds.
Even if you’re a complete newbie to the world of Excel VBA, you can easily record a macro and automate some of your work. In this detailed guide, I will cover all that you need to know to get started with recording and using macros in Excel. If you’re interested in learning VBA the easy …
In Excel VBA, IF Then Else statement allows you to check for a condition, and perform an action accordingly. This is extremely valuable in many situations as we will see in the examples later in this tutorial. To give you a simple example, suppose you have a list of grades in Excel and you want …
To get the most out of Excel and VBA, you need to know how to use loops efficiently. In VBA, loops allow you to go through a set of objects/values and analyze it one by one. You can also perform specific tasks for each loop. Here is a simple example of using VBA loops in …
In this tutorial, I’ll show you how to unpivot data using Power Query (Get & Transform). Pivot Table needs the data in a specific format so that it can analyze it and create different views from it. In case you don’t have the data in a Pivot Table ready format, you can use Power Query to unpivot the data set.
One of my friends works in a healthcare analytics company. He often connects with me on some of the real-life issues he faces while working with data in Excel. A lot of times, I convert his queries into Excel tutorials on this site, as it could be helpful for my other readers as well. This …
©trumpexcel.com – Free Online Excel Training
