Product Description:

ISBN: 81-7635-733-2

Book wriiten by : Conrad Carlberg

Published By : BPB Publications

ISBN 13 : 9788176357333

Total Pages : 366

Binding : PaperBack

TypePriceStock Availability
This Item is currently out of stock. Please enter your email address in the box below for getting an automatic notification when the item is available in stock.

Share on:

ISBN: 81-7635-733-2

Description Of The Book:
Excel is a great analysis engine but it's no database manager.True databases provide good ways to store and retrieve data but they're relatively weak at analysis and graphic display. Managing data with Excel shows you how to leverage the strength of each.
If you want to store data in Excel, you'll see how to set up your worksheet to take best advantage of Excel' s worksheet functions, pivot tables, charts, and list management tools.

Table of Contents

Part I: Pitfalls in Data Management
Chapter 1. Misusing Excel as a Database Management Tool


Part II: Managing Data Inside Excel

Chapter 2. Excel's Data Management Features
Chapter 3. Excel's Lists, Names, and Filters


Part III: Managing External Data from Inside Excel

Chapter 4. Importing Data: An Overview
Chapter 5. Using Microsoft Query
Chapter 6. Importing Data: Further Considerations


Part IV: Managing Databases from Inside Excel

Chapter 7. VBA Essentials Reviewed
Chapter 8. Opening Databases
Chapter 9. Managing Database Objects
Chapter 10. Defining Fields and Records with ActiveX Data Objects and Data Access Objects
Chapter 12. Controlling a Database from Excel Using ADO and DAO

If you are not happy with the product, you may return this within 15 days of receipt of the item with original packing and unused condition. Full refund or store credit will be issued against genuine returns.

We make sure all products sold by us are meeting the quality and does not have defects.
Any product found defective will be replaced free of cost.
We make sure that all products listed here are of the best quality available for that product/ price range.
We do not sell fake brands, cheap imitations or factory seconds.
All products are first quality products from the respective manufacturers.


Be the first to review this item.

To review this item, Please Sign In