The way you set up a workbook today could either save you hours or cost you hours and hours of frustration later. To save it, set up one work sheet for each type of data you will be collecting in the workbook. If you have customers and vendors, each one should be on its own work sheet. Create columns for each field that your data contains. So instead of listing Name, list First Name and Last Name. Instead of just Address, use Address, City, State and ZIP. Finally, for the most utility, ensure data for each record are collected on a single row.
Previous post: David beat Goliath, employers sometimes beat the DOL!
Next post: Court hints at MHRA ‘association’ bias cause