Google-Like Search in Excel

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.

Free Excel Template: Employee Timesheet

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.

10 Tips for Great Spreadsheet Aesthetics and Design

The aesthetic design of a spreadsheet, when done right, can add significant benefits in terms of usability and functionality.

Modifying Data in Spreadsheets with VBA

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.

Data Validation with Excel’s Built-In Data Validation Tools

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.