When I started learning Python, I saw it had a Reverse function and thought, “I could do that in Excel.”
Jean-Georges Vongerichten showed me the value in taking away, taking things off of a plate. … The more you put on the plate, the easier it is to hide. The more you take away, there’s nowhere to hide—it has to be good.
Chef Wylie Dufresne
Excel has a new keyboard shortcut for Paste Special Values.
Ctrl + Shift + V
Applying a date format before you drag with the Fill Handle may save you some time. See why.
Now is no time to think of what you do not have. Think of what you can do with what there is.
Ernest Hemingway (1899-1961)
In the previous post I created a custom function that creates a horizontal list of months based on three inputs. In this post I share a few ways that you can use this list.
It is common in reporting files, budgeting and forecasting files to create a list of months going across the page. The custom function in this post can automate the process.