Today’s post introduces a Google-like search, with search-as-you-type suggestions. While it’s possible to run basic searches with VLOOKUP and other techniques, this VBA approach can provide immediate search suggestions or recommendations for the user.
We’re releasing another free item in the Excel Virtuoso Portfolio. This item is a basic excel based employee timesheet template, useful for small businesses or volunteer organizations. With a user friendly interface and simple navigation, employees can keep an accurate count of hours worked each day.
The aesthetic design of a spreadsheet, when done right, can add significant benefits in terms of usability and functionality.
While it’s usually obvious to a user how to add data in a spreadsheet, modifying data is often less obvious and an afterthought for many developers. By providing a clean and inutitive interface to modify data, inputs can be validated and controlled, ensuring datasets remain clean.
Many developers will admit that when it comes to creating a user friendly application, more effort is often committed to controlling user inputs than actual functionality and design. Excel’s data validation tools allow you to easily deploy validation features on any spreadsheet project.