• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part: IV Sales and Marketing > Importing Business Data into Excel

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 to the various Lookup functions to pivot tables.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint