Articles
I've helped many like you with their Excel questions.
How to Find, Count, Delete and Remove Duplicates in Excel
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.
Working with the Date Format (including how to convert a date to the day of the week)
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.
Excel for HR Professionals: 7 essential functions that will cut your work from hours to minutes
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?
VLOOKUP vs INDEX-MATCH? 28 experts share their opinions
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.