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
FIFA World Cup 2018 Excel Template for Predictions & Play
FIFA world Cup 2018 is approaching fast and I thought to share an Excel template that adds to the fun and excitement of the World Cup month. Use it to keep track of the dates & times of the games, input your predictions, make
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