Cover of Managing data with Excel

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.

Read more

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 advice on using Excel's data management to get the results readers want. This is the only book that focuses on managing data in Excel. Covers Excel 97 - 2003.

The Business Solution series was created to provide professionals with books that are focused on a specific use or application of a software product. They don't want general software information, but need specific features and functions related to their particular productivity use. This series is for those who need to go farther with the software to specifically solve complex applications and uses. They want a book that addresses their immediate needs, and is likely to answer any additional questions they might have in the future.

Audience
adult
Length
epic · 4366 pages

Click a tag to see books like this one that share it. Point at it (on a phone, tap it) for less of it instead.

Read it? Sign in to help tag it.

Liked Managing data with Excel? Here’s where I’d start.

These suit anyone who liked Managing data with Excel. Sign in and mark a few books for picks shaped around your own taste.

  1. Excel 2007 Data Analysis for Dummies Shares computer technology, computer programs, business
  2. Excel 2007 miracles made easy Shares computer technology, computer programs, business
  3. Microsoft Office Excel 2007: The L Line, The Express Line to Learning (The L Line: The Express Line To Learning) Shares computer technology, computer programs, business
  4. So That's How! 2007 Microsoft® Office System: Timesavers, Breakthroughs, & Everyday Genius: Timesavers, Breakthroughs, & Everyday Genius for 2007 Microsoft Office System Shares computer technology, computer programs, business

“If you want more of the same (business), start with these.”

  1. Marketers Are From Mars, Consumers Are From New Jersey
  2. Launching a successful eBay store
  3. Twitter Marketing For Dummies
  4. Suits: A Woman on Wall Street

“If it was the computer technology that hooked you, try one of these.”

  1. Microsoft Office 2003 All-in-One
  2. Professional InfoPath 2003
  3. Excel 2007 For Dummies Quick Reference
  4. Office 2000

“These start from a similar idea, even if they go somewhere else with it.”

  1. Clojure Applied: From Practice to Practitioner
  2. MySQL Crash Course
  3. Programming Pig
  4. Seven Databases in Seven Weeks: A Guide to Modern Databases and the NoSQL Movement