Custom fiscal year calendar (CFlex)
Fully customized Yearly Calendar to show certain dates with certain format using conditional formatting, like mark 8th business day each month with certain color, 1st workday after 15th of each …
Skills Grid
A small Excel file to show how we can create a chart-like Excel sheet Used in my Resume to show different skill sets and the level of expertise in each
State Abbr with Index+Match+Validation
Small file that will show how to do INDEX + MATCH formulas to get the abbreviation of the state based on its name or the name of the state based …
Multiple Dual-Validations
It is to demonstrate how to do multiple validations in the same sheet, or as we want to call it Mutliple-dual-validations that depend on each other. Checking out sheet “Data”, …
Multiple-Validations (connected to each other)
Here is the free file for a special request by a client He wanted to have multiple cells having Data – Validation to same list but minus the selected one …
Validation based on another Validation
Creating a Data Validation based on another Data Validation Meaning that when you select from a drop down from the first the second will be filled with the list that …
Excel Dynamic Drop-Downs that grow with you
This will help you do a dynamic name to use on a drop down, a Form Listbox or Form Combobox. The screenshot almost says it all. You need 4 steps: …