Dealing with duplicates
Jun 15

How to Find 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.

Arrggh!

Today we’ll discuss simple and fast methods to find and remove these same values from our Excel worksheets.

Exterminate these pesky identicals, you will!

Here’s how…

Continue reading

VLOOKUP vs INDEX-MATCH
May 16

VLOOKUP vs INDEX-MATCH: 27 Excel experts share their opinions

VLOOKUP vs INDEX-MATCH. Which is better?

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. 

VLOOKUP vs INDEX-MATCH
Continue reading
Excel for HR Professionals - 7 Essential Functions
May 06

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?​

In reality, what goes behind the scenes are the endless amount of human resource information system (H.R.I.S.) inputs, preparing reports for the management, and spending face-time with employees just to get the day-to-day work done.

Here's some Excel magic to help you cut your day-to-day HR work from days and hours to just MINUTES.

Excel for HR Professionals - 7 Essential Functions
Continue reading
Mar 01

Creating an Excel Gantt Chart

Creating an Excel Gantt chart. #free #Gantt #Excel #MSExcel | DefeatExcel.com

Recently at work, we just started on a new project and wanted to map out all the tasks in a Gantt chart format. For those of you who are not familiar with Gantt charts, a Gantt chart simply illustrates a project schedule in a visual form, making it easier for users of the Gantt chart to follow the task summary.

Continue reading