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
Predictive Analytics: Microsoft® Excel
Excel predictive analytics for serious data crunchers! The movie Moneyball made predictive analytics famous: Now you …
book
Microsoft® Excel Data Analysis and Business Modeling
Well known consultant, statistician, and business professor Wayne Winston teaches by example the best ways to …
book
Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More
This condensed syntax reference presents the essential Excel function syntax in a well-organized format that can …