Putting Data Management into Context

Excel is a superb application. Its user interface is comfortable and effective—at least, you can make it match your own sense of comfort and effectiveness. The worksheet layout is flexible. You can make the rows and columns stand for whatever you want: records and variables, weeks and days, accounts and debits or credits, and so on.

Excel offers a huge selection of functions: prefabricated formulas that have already done the heavy lifting for you. Its charts help you visualize what's going on with your data. Its pivot tables make it a snap to synthesize and analyze large collections of records. You can even control its appearance so that other users can't tell that what they're looking at is an Excel worksheet. ...

Get Managing Data with Microsoft® Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.