In a financial model you often have different types of allocations that start at different times. Creating a short formula to handle this flexibility can be a challenge. Here is one solution.
Learn about Excel’s powerful Table feature that treats tables like little databases.
I ran this free live webinar in March 2021.
You can access the pdf manual and example file by clicking the button below the video.
In this short video I cover how to increment dates in long ranges.
It uses a little know dialog.
The wait is over
Well, the wait is finally over in the subscription version.
You can now unhide more than one sheet at a time – woohoo!
In my previous post I mentioned you should, as far as possible, keep data together in a single table rather than splitting it up between sheets. If you want to split it up for distribution purposes here is an easy way to do it.
In this short video I cover how to insert dates in long ranges.
Its simple and quick.
I have received a few questions recently relating to working with data spread across multiple sheets. In general, if the data is in the same layout, keep it in one table.
In this short video I cover how to insert automated subtotals.
Its a built-in feature, that is easy to use.
When you paste into Excel from other applications, sometimes the formats can be problematic. Here is a tip to ignore formats.
In previous videos I worked with duplicated entries.
In this video I demonstrate how to extract unique entries from a list.
Three different ways in 60 seconds.
Off we go!
Yes, you can create a cell drop down without Data Validation. It uses a built-in technique and is flexible.