When I started learning Python, I saw it had a Reverse function and thought, “I could do that in Excel.”
Monthly Archives: September 2023
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
A Conversation with Wylie Dufresne
Paste Special Values Shortcut
Excel has a new keyboard shortcut for Paste Special Values.
Ctrl + Shift + V
Formats Affect Excel’s Fill Handle
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)
The Old Man and the Sea
Using the Custom Month List Function
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.
Excel Month List Custom Function
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.