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
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
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
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 aware of yet. Now: what's a dependent drop-down list?
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,
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
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
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
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.
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 $
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.
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
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
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
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