Essential tips for data formatting Before you create a database in your Excel workbook, keep several tips in mind which will help you get the desired results.