LEFT RIGHT, LEFT RIGHT LEFT!LEFT and RIGHT functions are used to extract the FIRST (left) and LAST (right) characters in a cell. So, how can it be used and when do I u
Stop Moving! - Absolute Cell ReferenceCopied a formula to another cell and noticed the result is not the same as the cell that you just copied? Read on to see how $ signs can pre
How to remove table functionalityCreated a table and then later decided that you no longer want the “table functionality”? Learn how to remove a table's functionality at
SUMIFSUMIF is used to “sum the values in a range that meet a criteria that you specify” - Microsoft Support Office 2017. It refers to only one c
VLOOKUP VS INDEX-MATCHI'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-MATCHINDEX-MATCH is more flexible and powerful than VLOOKUP as it doesn't have the limitations of VLOOKUP. It is a combination of two formula
COUNTIFCOUNTIF, 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 VLOOKUPVLOOKUP 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 DuplicatesRead on to find out how to use conditional formatting to identify duplicates and save you time!
