The FAIR data principles are a set of guidelines aimed at improving the ability to make use of your data. Here I want to evaluate how these principles can be of value in a small business setting.
Defining dependent dropdown lists in Excel
Data validation drop down lists are an excellent way to ensure data consistency. This becomes even more important when you have hierarchical, dependent data. This article describes one way to establish dynamic drop down validation lists.