7 tips to deal with duplicates in MS Excel
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 with duplicate/unique values in MS Excel. After reading this post you’ll be able to: Highlight […]
10 great examples to master date functions in Excel (part 2)
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 applications of date functions such as: how to calculate number of working dates between two dates […]