May - 2017

Note: screenshots and examples were taken using Microsoft Excel 2013, however older versions can be used.

Tags

No tags yet.

VLOOKUP VS INDEX-MATCH

I've covered how to use VLOOKUP and INDEX-MATCH and their limitations, if any. To recap, I've created a venn diagram to show the sim

INDEX-MATCH

INDEX-MATCH is more flexible and powerful than VLOOKUP as it doesn't have the limitations of VLOOKUP. It is a combination of two formula

COUNTIF

COUNTIF, in layman’s terms means COUNT the NUMBER of cells, IF it contains XYZ (text, number, etc). The key word here is criterion, referri

Mastering VLOOKUP

VLOOKUP is probably one of the most commonly used but hated formulas. Having broken down the formula for you, let's learn it right for o

Identifying Duplicates

Read on to find out how to use conditional formatting to identify duplicates and save you time!

Random date generator

Learn how to use Excel to generate random dates and dates between a range.

Freeze right there! - Freeze Panes

Freeze panes enables you to “freeze a portion of the sheet to keep it visible while you scroll through the rest of the sheet."

Did you know Excel can generate random numbers?

Let Excel do the work for you - generate random numbers!

If Only...

If only this is x, then it’s y. Read on to find out how to apply "IF" formulas to your data.

Combining & Splitting Text

Knowing how to combine two columns into one and vice versa quickly is so helpful. Read on and learn how to do it quickly!