After your sales representatives have returned from pounding the pavement and getting the word out about your company's products, you can automate the sales-reporting process with Microsoft Excel ...

This workshop will teach you how to create a form in Microsoft Excel that allows others to fill in information without lines jumping around and text moving. Adding content controls like check boxes, ...

If you support users who have trouble entering data and printing an Excel sheet, use this eight-step approach to create a foolproof form. It’s just too easy to kvetch about how incompetent some end ...

A check mark box in an Excel spreadsheet is handy for ticking off items, but it can go much further. Excel check boxes can trigger calculations and provide visual indicators. For example, in addition ...

Create a UserForm containing a dynamic number of controls and make sure they are being triggered by certain events. To achieve this result, we will use a UserForm and a class module, and assign any ...

Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.