Latest Blog Posts

Excel VBA ComboBox with Control Source Property: 2 Methods

Method 1 - Using ComboBox Property Step 1: Creating VBA UserForm With ComboBox in Excel Create a UserForm with ComboBox. To create a Userform ...

How to Sort by Column Header Name Using VBA in Excel (5 Ways)

The video overviews this article, representing sorting by column header name in Excel VBA. Here, by double-clicking the “Company” and “Revenue ...

Guide To Excel VBA to Open Workbook from Path in Cell

How to Launch VBA Macro Editor in Excel Steps: Open the Developer tab. Select the Visual Basic command. The Visual Basic window ...

How to Create an Excel Slicer with a Search Box (Easy Steps)

Excel slicers with search functionality offer a user-friendly way to filter and navigate data within Excel. By incorporating a search feature, users ...

How to Use the Excel SUMIFS with Not Equal to Text Criteria: 4 Examples

Dataset Overview In this tutorial, we’ll explore how to use the SUMIFS function to exclude specific values based on criteria. Let’s consider a ...

How to Create Slicer Drop Down in Excel (with Quick Steps)

With the slicer drop-down, you can quickly and easily filter data by selecting one or more items in the drop-down list, which instantly updates the ...

3 Easy Ways to Press Enter Without Changing Cells

We can change in Excel’s settings for the Enter key to keep the selection from moving. There is also another shortcut- Ctrl+Enter to keep the ...

How to Insert the Double-Headed Arrow in Excel (4 Methods)

The double-headed arrow in Excel serves two purposes: it represents resizing and adjustment of columns or rows, and it can also be used for scrolling ...

How to Use Sales Run Rate Formula in Excel (3 Handy Examples)

The sales run rate is used to estimate a company's potential future revenue based on its present revenue. It is determined by dividing the total ...

How to Custom Sort Slicer in Excel: 3 Suitable Methods

Method 1 - Custom Sort Slicer with Vendor Names Go to Options from File. Click on Advanced and click on Edit Custom Lists. ...

Excel SUMIF Not Working (9 Possible Cases with Solutions)

This image depicts 3 reasons and their solutions when the SUMIF function is not working among the 9 reasons we will discuss in this article. You can ...

How to Use SUMIF Function to Sum Not Blank Cells in Excel: 5 Ways

Method 1 - Applying “Not Blank” Operator The Not Blank operator can be used to find out whether a cell or a range of cells is blank or not. The ...

Excel If Cell Begins with Certain Text Then Return Value

Consider the following dataset of products and their IDs. We can search for a specific product using a predetermined value or a given value in a ...

Excel VBA to Loop Through Named Range (6 Suitable Examples)

Looping through a named range is just like looping through a regular range.  The advantage is you can run a loop without having to explicitly ...

Activate Another Workbook with VBA in Excel: 6 Examples

Method 1 - Activate Another Workbook by Workbook Name in Excel VBA This example will help you activate another workbook by closing your existing ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo