Search Results

Learn one of the most useful statements in VBA (or any programming language, really): If Then. Once you master If, Then, Else, Elseif and And, you will be able to write Excel macros that are dependent on multiple conditions.

Excel’s SUMIFS function makes it super easy to sum values that fall between two dates. You’ll also learn how to sum by month and also add in multiple criteria.

Quickly create dynamic drop-down lists in Excel that are dependent on another list. Automatically exclude blank cells and allow the drop-down to expand as new values are added.

Find out how to use the FIND function in Excel VBA. This can be more effective than looping through large data ranges. VBA also results in error if the value is not found. How can you overcome this error? Find out in the article.

Download the infographics Excel template for a quick start. I’ll show you how to create this with male, female icons. Update it easily for your needs.

Create impressive Excel reports by adding a dynamic lookup to your image. This way, every time a cell value changes, your image changes. Download the Excel Workbook and use it to quickly get started.

Grabbing random team names from a hat is boring. Do it the smart way. Download the Excel template and make your predictions for the all the games. Play with your office mates or with your family. The one with the most points wins.

Learn how to create data validation rules with formulas for custom conditions, such as alphanumeric codes or ids that have to follow a specific pattern. With formula, you can check for text, numbers & length of the entered text.

Learn how to properly set up data validation in Excel. It’s especially useful when you’re preparing a data input form, where you require the entered data to meet certain criteria.

Quickly create a Step Chart in Excel. You can download the Step Chart Template to get a quick start. To understand how it works and to be able to create one from scratch make sure you watch the steps in the video.

If you’d like to modernize your Excel reports, check out this tutorial which shows you some simple chart tricks to create a bar chart that doesn’t quite look like a bar graph. It uses icons and shapes in a dynamic way.

This tutorial shows you how you can copy and paste with VBA. You will learn the copy and pastespecial methods, as well as resize and offset properties in order to fully control what you copy and paste from ranges.