Go to Master Data Analysis One of the great features that MS Excel has is the capability to restrict (validate) the input into certain cells. The name of this feature in MS Excel is Data Validation. A...

Go to Master Data Analysis If you have worked with MS Excel for a while I bet you have had the need to highlight/count unique or duplicate values. In this post I’ll cover all you need to know to deal...

Go to Master Data Analysis Have you ever asked yourself any of these Excel questions: How do I fill empty spaces on a table with the content above? Is there a way to automatically expand the source...

Go to Master Data Analysis This is the second part of the post “10 great examples to help you master date functions in Excel”. In the first part of this post I covered how Excel handles dates and 5...

Go to Master Data Analysis Have you ever wanted to create a drop down list in Excel to avoid data entry errors or to make the data entry process easier? In this post I’ll cover a whole range of tips...

Go to Master Data Analysis There are many ways of working with dates in Excel. In this first part I’ll cover 5 out of 10 great examples to help you master date functions in Excel. Before getting...