Custom Function to Reverse a String in Excel
When I started learning Python, I saw it had a Reverse function and thought, “I could do that in Excel.”
(more…)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.
(more…)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.
(more…)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.
(more…)