Search Results

Learn how to use ranges, cells property, offset, named ranges, difference between activecell and selection, and how to reference entire rows or entire columns and also how to use autofit in Excel VBA.

Understand Object Properties and Methods in VBA. It is a key skill if you’d like to write your own Excel VBA code from scratch or update the VBA code you find on forums.

See how you can use the macro recorder to copy data from one Worksheet to another sheet, appending data from two tabs. Also, learn how to insert a button and assign the macro to it.

Discover all the features, views and windows of the Visual Basic Editor – the place where all your VBA code resides.

In this tutorial, we will create a dependent drop-down list based on a messy Excel Table. For that purpose, we will extract all records for each category using the combination of INDEX and AGGREGATE. Next, we will fix the column referencing in the table. Finally, we will use a combination of OFFSET and COUNTIF to get a drop-down list restricted to non-empty cells.

How does Excel Filter & Advanced Filter work? In this quick tutorial I show you many examples. You’ll learn how to use wildcards in your filter criteria. How to use the criteria range in advanced filter. How to search for OR, AND or BETWEEN conditions and much more…

Would you like to copy your Excel formulas from one place to another without the cell references changing? In this step by step tutorial I show you a very simple trick that does that.

Find out how you can use Excel Macros to control the fill color of Word Art showing a percentage value connected to a cell with a formula. Pick up plenty of VBA techniques while you’re at it.

Learn how to have dynamic Word Art that is controlled with a formula and how to create bar-in-bar Excel charts. You don’t need VBA, you just have to get creative.

Learn how to use Excel’s IF formula in your Excel reports. We start with a simple example, followed by using IF with multiple criteria. You also learn how to use AND / OR conditions inside the IF function. Download the workbook to practice along.

In case you’re interested to visualize a KPI on a customized map in Excel which works on any version of Excel, then this tutorial is for you. I show you in easy steps how to find the right map and how to set it up properly.

Quickly learn how to conditionally format the result of your lookup value inside the original data set. If you conditional formatting formula is not working, it’s probably because of incorrect referencing.