Articles and resources tagged “Excel”

Opening a CSV in Excel—without corruption: Comma Separated Values (AKA comma-delimited ASCII) are one of the most common formats used to exchange information. This is because they're compatible with applications on just about any operating system—going back to DOS days. On many computers, a .CSV file...; Read Article; BY: Ann Ray on February 5, 2007 | Last updated May 19, 2008; COMMENTS: 0; CATEGORIES: Data Handling | Technology; TAGS: Excel | Import & export
Stupid Excel data tricks: These days, most of us do more in Excel than the VisiCalc creators would have dreamed. Following are a few of my favorite tricks for working with data in Excel (the raw side, not the chart side). This article includes:...; Read Article; BY: Ann Ray on February 5, 2007 | Last updated May 30, 2008; COMMENTS: 0; CATEGORIES: Data Handling | Technology; TAGS: Excel | Import & export