Separate / Extract Data Flash Fill

Flash Fill was introduced in Excel 2016 and give you an easy way to split or extract text or values from one column cell to another. A common use is to split out a column with full name (i.e. first name last name like John Smith) to separate first and last name columns. Before you might have used LEFT, MID or RIGHT functions, but now with Flash Fill, there's no need to use those functions.

Millionaire Calculator NPER- Excel

f you're got a mutual fund or some kind of investment vehicle that lets you put in an initial investment and give you the chance to put in additional investments, how long will it take to get to a million bucks? Use the NPER function to find out.

Sort Column by Cell Color

Sorting columns are a common occurrence and usually done via ascending or descending based on A to Z or Z to A with text or number values. But did you know you can sort by color? The use case maybe that you've done some conditional formatting for the cell color and you want to sort on blue, yellow and green in that order. It can be done with the custom sort feature.