Get a List of Filenames from Windows Directory into Excel

This video shows how to copy file names from windows explorer to Excel for further modification. You would think it would be as easy as performing a copy and paste with mouse clicks, but it doesn't work that way.  There is a workaround by using the command prompt and redirecting the output to a text file.

Sum Positive and Negative Numbers with the SIGN (and SUMIF) Function

If you get a file with positive number, performing calculations is not hard, but if the values are mixed with positive and negative numbers it might be a problem depending on how they're arranged. This video show how to sum up positive and negative numbers with the SIGN and SUMIF functions.

Create a Waterfall Chart

When you want to create a column chart the sort of shows how the data flows from one column to another either through time or through a process, you may want to think about creating a waterfall chart.  It visually show this type of behaviour and in this video I'll show you how to create a basic waterfall chart.