In the most simple terms… Logical functions are used to determine whether to perform an action or not perform the action by making comparisons and returning True or False as the result of a simple comparison. However using logical functions in practicality is much cooler… Use them to determine whether to apply a conditional format […]
Easily find, edit, add and delete records in an Excel data table using the forms tool. Excel’s Form tool simulates a database user interface when working with structured tables holding multiple records in Excel. It’s super simple to use and requires absolutely NO setting up. The Form tool isn’t available in Excel’s default ribbon though, […]
A drop down list in Excel can be used to restrict entries in a cell or cells, or simply to guide users and make it easier for them to complete entry of records or form items and they’re easier to create than you might think. Activity File Download the following activity file, then watch this […]