Set up your Excel workbooks correctly the first time — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

Set up your Excel workbooks correctly the first time

Get PDF file

by on
in Excel Training,Office Technology

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.

Leave a Comment

 

Previous post:

Next post: