Quickly Remove Blank Rows

When you get a table of data sometimes it's got some blanks cells. For those records in the row where there's any cell that is blank, you may not need that record...so you want to get rid of them. To delete some record rows manually is not hard if you have just a few rows, but if you've got a lot, there's any easier and faster way to do this.

Clear All Formatting - Excel

Sometime you get all sorts of formatting on your spreadsheet like bold, underline, some funky magenta cell fill and just need to start over. You don't want to go into each cell and find and "find" the multiple types of formatting that might be there. Let's just do it one and done.

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.