Articles

No matter which profession you are in, one annoying enemy is always present — duplicates. They multiply themselves like clones, and no matter how many times you scroll and press Delete, they always seem to be never-ending. Today we’ll discuss simple and fast methods to find, count, delete and remove these duplicates from our Excel worksheets.

Do you know that Excel can perform calculations with dates? When you key in a date, Excel actually stores the date as a number behind the scenes. This number is the number of days since 0 Jan 1900. Let’s take a deeper look behind the curtains of Excel.

Recruitment, training & development, compensation & benefits, payroll, employee relations, staff retention, … HR professionals are often seemed to have the easiest jobs in the company. Or is it?

This has got to be one of the oldest, and yet hottest topic among the Microsoft Excel’s community. Currently there are about 1.43 million search results in Google just on this topic alone. And so, DefeatExcel has reached out to seek the opinions of Excel experts such as Microsoft MVPs and Excel community experts so that we can hear their views right here in a single article.