Excel Blog - Latest Excel tips, tutorials, and videos.

5 Excel VBA Autofilter: A Complete Guide with Examples

A lot of Excel functionalities are also available to be used in VBA – and the Autofilter method is one such functionality. If you have a dataset and you want to filter it using a criterion, you can easily do it using the Filter option in the Data ribbon. And if you want a more advanced version […]

11 Search and Highlight Data Using Conditional Formatting

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 a search functionality using Conditional […]

3 Highlight Rows Based on a Cell Value in Excel (Conditional Formatting)

All rows where name is Bob are highlighted

Conditional Formatting allows you to format a cell (or a range of cells) based on the value in it. But sometimes, instead of just getting the cell highlighted, you may want to highlight the entire row (or column) based on the value in one cell. To give you an example, below I have a dataset where I […]

3 How to Make a Histogram in Excel (Step-by-Step Guide)

A histogram is a common data analysis tool in the business world. It’s a column chart that shows the frequency of the occurrence of a variable in the specified range. According to Investopedia, a Histogram is a graphical representation, similar to a bar chart in structure, that organizes a group of data points into user-specified ranges. The […]

14 How to Compare Two Columns in Excel (for matches & differences)

Compare Lists in Excel - matches are shown as TRUE

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 […]

12 How to Create a Data Entry Form in Excel (Step-by-step Guide)

Excel has many useful features when it comes to data entry. And one such feature is Data Entry Form. This Tutorial Covers: Why Do You Need to Know About Data Entry Forms?Data Entry Form in ExcelAdding Data Entry Form Option To Quick Access ToolbarParts of the Data Entry FormCreating a New EntryNavigating Through Existing RecordsDeleting […]

1 Excel VBA MsgBox [Message Box] – All You Need to Know!

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, […]

« Previous 1 2 3 4 5 … 50 Next »