Managing data with Excel

Even experienced Excel users have never learned how to manage data efficiently, and there are few books that provide this information for people who use Excel to do their jobs. Within Excel, efficient management includes designing the layout of data on the worksheet and knowing which functions to use to take advantage of that layout. When users need data that's maintained elsewhere (e.g., a database with G/L information or HR management software) they frequently resort to copying from the source and pasting to an Excel worksheet. There are more effective ways to move data. This book provides…