Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
While Excel is mostly used for data entry and analysis, it also has some great chart types that you can use to make your reports/dashboards better. Apart from the default charts that are available in Excel, there are many advanced charts that you can easily create and use in your day-to-day work. In this tutorial, …
I recently got a question from a reader about combining multiple worksheets in the same workbook into one single worksheet. I asked him to use Power Query to combine different sheets, but then I realized that for someone new to Power Query, doing this can be tough. So I decided to write this tutorial and …
Sparklines feature was introduced in Excel 2010. In this article, you’ll learn all about Excel Sparklines and see some useful examples of it. What are Sparklines? Sparklines are tiny charts that reside in a cell in Excel. These charts are used to show a trend over time or the variation in the dataset. You can …
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. …
©trumpexcel.com – Free Online Excel Training
