Chapter 3. References: Point in the right direction
A formula is only as good as its references.
No matter how creative and brilliant your formula is, it won’t do you much good if it does not point to the correct data. It’s easy to get references right for short, individual formulas, but once those formulas get long and need to be copied, the chance of reference mistakes increases dramatically. In this chapter, you’ll exploit absolute and relative references as well as Excel’s advanced new structured reference feature, ensuring that no matter how big and numerous your references are, your formulas will stay tight and accurate.
Your computer business is in disarray
As the boss of Ace Computer Manufacturing, you know how critical it is to maintain your profit margins in the volatile and competitive business of selling computers.
You need to get on top of your supply chain: are you marking up your computers enough to make a profit? You need to take control of your data to figure it out.
Get Head First 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.
