Chapter 18. Importing Business Data into Excel
Chapter 3, “Valuing Inventories for the Balance Sheet,” discussed how a small retail establishment named Evans Electronics manages its inventory, both with regard to counts of different products and valuation. That case study mentioned that the company keeps its sales information in a true database file. Evans Electronics imports the information into Excel when it is time to close the books on an accounting period.
In choosing to bring data into Excel from a database, isn't Evans Electronics needlessly complicating things? After all, you can store data in Excel worksheets by means of structures that Excel terms lists. And Excel provides many approaches to extracting data from lists, from AutoFilter ...
Get Business Analysis with Microsoft® Excel, Second Edition 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.
