17
Importing Business Data into Excel
Chapter 3, “Valuing Inventories for the Balance Sheet,” described how a small retail establishment named Evans Electronics keeps track of the number of units and the value of different products in its inventory. 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.
Isn’t Evans Electronics needlessly complicating things by choosing to bring data into Excel from a database? After all, you can store data in Excel worksheets by means of structures ...
Get Business Analysis with Microsoft Excel, Fifth 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.
