Sometimes data isn’t structured the way you’d like it to be. Separating delimited text into columns is easier than you might think.
Archive for June, 2010
Converting Text to Columns in Excel
Posted in Microsoft Excel 2007 on June 27, 2010 | Leave a Comment »
Excel drop-down lists for accurate data-entry
Posted in Microsoft Excel 2007 on June 12, 2010 | Leave a Comment »
Excel drop-down lists can be used in to make data entry more accurate or limit the selection of data to a pre-defined list.
Summarize data using 3-D references
Posted in Microsoft Excel 2007 on June 8, 2010 | Leave a Comment »
A 3-D reference utilizes the same cell, or range of cells, from multiple worksheets in a formula. 3-D references will work with a number of functions in Excel including: SUM, COUNT, and AVERAGE. Let’s look at an example.
