Managing Data with Excel (eBook)

Conrad Carlberg (Autor)

eBook Download: PDF

2004 | 1. Auflage
Pearson Education (Verlag)
978-0-7686-6572-7 (ISBN)

Infos

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 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.

---

You have learned the methods to the madness of Excel. Formulas and functions are friends instead of foes. Yet you know there's something missing that could make your job even easier. That "e;something"e; is efficient and effective data management. Managing Data with Excel is the only book on the market that focuses on just that. Learn how to efficiently move data, automate data storage and import data into worksheets and pivot tables. Case studies are included in each chapter to illustrate real-world applications of these functions. Invest your time in learning this now so that you can stop wasting your time figuring out how to work around problems.

Produkt-Details

• Erscheint lt. Verlag: 10.5.2004
• Sprache: englisch
• Themenwelt: Sachbuch/Ratgeber
• Themenwelt: Informatik ► Office Programme ► Excel
• ISBN-10: 0-7686-6572-8 / 0768665728
• ISBN-13: 978-0-7686-6572-7 / 9780768665727