Charts

Creative Infographics in Excel

Infographics in Excel - Creative Chart Ideas How about using the male & female icon instead of a column chart? That would grab people's attention: it would change things up a bit - don't you think? This was a question from one of my YouTube subscribers after I posted this video. There I showed

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 irregular basis. It can be used to visualize inventory or

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 on the left hand side. Can you set this

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 lookup in action towards the end of this video,

Find Multiple Matches in Excel & Create a Dependent Drop Down List

The aim of this tutorial is to create a dependent drop-down list that's based on a messy Excel Table. What do I mean by an unsorted Excel table? The categories for the first drop-down are not in a tabular format and they are not grouped together. You can see an example of the

Extract unique items for dynamic data validation drop down list

Excel Formula for dynamic drop-down lists Extract unique items for dynamic data validation drop down list How can you extract unique items from a list that contains multiple instances of each item, and use this list in a dynamic dropdown so that any time a new item is added to the

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 fun bets with family members or organize an office

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 window will not provide formula tips as

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 people input data into the spreadsheet.

Copy Excel Formulas Without Changing Cell References

Would you like to copy your Excel formulas from one place to another without the cell references changing? Excel default behavior is to adjust the cell references when you copy a cell and paste to another one. You can choose to fix the cell reference by using the dollar sign ($). A $

Excel IF Formula: Simple to Advanced

The IF function is one of Excel's most common Functions The IF formula performs a test and returns a value depending on the outcome of the test. The test it performs can be simple or complex depending on the problem at hand. It's one of those formulas that every Excel user should know.

Reset Week Number Every Month (start from Week # 1 every new month)

WeekDay & WeekNum Functions Explained Excel Reset Week Number Every Month In this tutorial I show you two ways to reset the week number to start from 1 at the beginning of every month. 1st case: We use Excel's WEEKNUM function to start from 1 every time we reach the 1st

VBA Copy Paste

Excel VBA Copy & Paste in Excel VBA (copy, pastespecial, resize & offset) This tutorial shows you how you can copy and paste with VBA. We use the copy method as well as the pastespecial method. The copy method in VBA, copies data, as well as formatting, formulas, comments etc. With

VBA Writing To Ranges

Excel VBA Referring to Ranges & Writing to Cells in Excel VBA (Range, Cells, Offset, Names) It's important to be aware of the different ways you can write to Excel cells with VBA. The macro recorder has its own preference when writing to ranges but it's not the only way. You'll

VBA Object Properties & Methods

Excel VBA tutorial for beginners: Object Properties & Methods Understanding Objects, Properties and Methods in VBA is really important if you'd like to write your own Excel VBA code from scratch or update the VBA code you find on forums. This Excel VBA tutorial for beginners includes two lectures from my

All Tutorials