Excel SUM Between Dates

How can you sum values between two dates in Excel? What if you wanted the sum for a specific month? And what if you decided to add in multiple criteria to your existing sum? For example get the sum by month AND division AND

Expandable Conditional Drop Down Lists in Excel

Are you already using a drop-down list in Excel? If not, check out this post. It'll show you how to create a data validation drop-down list in Excel.  You'll also discover some other aspects of data validation in Excel which you might not be

Excel VBA FIND Function

Excel VBA FIND Function (& how to handle if value NOT found) Doing a CTRL + F on Excel to find a partial or exact match in the cell values, formulas or comments gives you a result almost instantly. In fact, it

Creative Infographics in Excel

Creative infographics in Excel (Male, Female icons) Using fillable icons on charts is a good way to visualize data. In this example, the male and female icons will be used. To do this: Set up data table Insert a clustered column chart

Lookup on Pictures

Dynamic Picture Lookup in Excel Just 5 easy steps - No VBA How can you lookup different pictures based on the value of a cell? Just to give you a heads up. This is a VBA-free tutorial! We saw the dynamic picture

Excel Custom Data Validation

Check for text, numbers & length Excel Custom Data Validation Custom data validation is especially useful when the normal data validation criteria options are insufficient, this way, formulas can be used to define the restrictions.   TIP: Since the formula text box in the

Data Validation in Excel

Should you include these in your files? Data Validation in Excel Excel’s Data Validation feature ensures that the data collected is clean and to minimize the errors and hence the time it takes to correct them.  This is especially helpful when multiple

How to create a Step Chart in Excel

This tutorial is a Step by Step approach to creating a Step Chart in Excel from Scratch. You can also download the template from the link below. What is a Step Chart? A Step Chart is great for visualizing variables that change on an

Infographics in Excel: NOT your Usual Bar Chart

In this tutorial you learn how to create a bar chart that includes the male/female icon in a dynamic way. Let's assume you'd like to show the percentage of male/female visitors to your store - and you'd like to show it, like the image