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.
Tuesday, July 9, 2019
Monday, July 8, 2019
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.
Wednesday, July 3, 2019
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.
Subscribe to:
Posts (Atom)