#text

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

Tags

No tags yet.

Flash Fill

What is “Flash Fill”? Flash fill "automatically fill in values" - Microsoft Excel. Once you've mastered it, it will save you

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

Identifying Duplicates

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