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

2. Hacking Excel for Financial Analysis > Flexible Techniques for Referencing D...

Flexible Techniques for Referencing Data

A number of Excel functions can help you summarize data or retrieve specific values to use in a formula.

Excel is a natural choice for processing financial data; not only does it calculate numeric results from values in cells, but it also acts as a lightweight database management system that sorts, filters, and validates those same cell values. However, when you store a great deal of data in Excel, cell addresses might be hard to handle. If you move data around, formulas that use cell addresses might stop working properly. Worksheets are more flexible when you retrieve data using Excel functions that search for labels associated with the data you want. In addition, formulas are hard to understand and even harder to troubleshoot, because cell addresses don’t convey their purpose. You can make formulas easier to understand by using data retrieval functions to pull values into a summary workshee....


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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