Book description
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 "something" 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.
Table of contents
- Copyright
- About the Author
- Acknowledgments
- We Want to Hear from You!
- Introduction
- Pitfalls in Data Management
- Managing Data Inside Excel
- Managing External Data from Inside Excel
- Managing Databases from Inside Excel
- Index
Product information
- Title: Managing Data with Microsoft® Excel
- Author(s):
- Release date: May 2004
- Publisher(s): Que
- ISBN: 0789731002
You might also like
book
Business Analysis: Microsoft® Excel 2010
ANSWER KEY BUSINESS QUESTIONS CONTROL COMPANY FINANCES FORECAST SALES PREPARE BUSINESS CASES MAKE BETTER INVESTMENT DECISIONS …
book
Exchanging Data From SAS to Excel
Microsoft Excel remains the leading spreadsheet application on the market; nearly every SAS user will need …
book
Pivot Table Data Crunching
Become a savvy Microsoft Excel user. Pivot tables are a great feature in Excel that help …
book
Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel
Prepare for Microsoft Exam 70-779 and help demonstrate your real-world mastery of Microsoft Excel data analysis …