Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
<!– META H1: Excel VBA Autofilter: A Complete Guide with Examples Meta title (55 chars): VBA AutoFilter in Excel: Syntax, Criteria, and Examples Meta description (146 chars): Use the VBA AutoFilter method to filter by text, AND/OR, multiple values, top 10, and dates, plus Excel Tables, ShowAllData, and protected sheets. –> Excel VBA Autofilter: A …
Watch Video – Search and Highlight Data Using Conditional Formatting If you work with large datasets, there can be a need to create a search functionality that allows you to quickly highlight cells/rows for the searched term. While there is no direct way to do this in Excel, you can create search functionality using Conditional …
If you want to highlight an entire row based on the value in one cell, regular Conditional Formatting will not do it for you. That’s because Conditional Formatting normally looks at each cell on its own, so it colors that one cell and leaves the rest of the row alone. The fix is to write …
The one query that I get a lot is – ‘how to compare two columns in Excel?’. This can be done in many different ways, and the method to use will depend on the data structure and what the user wants from it. For example, you may want to compare two columns and find or …
Below is a detailed written tutorial about Excel Data Entry form in case you prefer reading over watching a video. Excel has many useful features when it comes to data entry. And one such feature is the Data Entry Form. In this tutorial, I will show you what are data entry forms and how to …
In Excel VBA, you can use the MsgBox function to display a message box (as shown below): A MsgBox is nothing but a dialog box that you can use to inform your users by showing a custom message or get some basic inputs (such as Yes/No or OK/Cancel). While the MsgBox dialog box is displayed, …
With Power Query, working with data dispersed across worksheets or even workbooks has become easier. One of the things where Power Query can save you a lot of time is when you have to merge tables with different sizes and columns based on a matching column. Below is a video where I show exactly how …
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 …
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 …
©trumpexcel.com – Free Online Excel Training
