• Buffer
  • Sharebar
  • Buffer
jethro's picture

Back To Basics: Using Absolute References in Excel

Excel uses a powerful vector system for managing formulas. Each cell can be linked to many others using formulas. In a simple way of explaining this, 2 cells can be added together in a third cell using a formula that references them. The columns are named alphabetically and the rows numerically.

Thus the first cell is known as A1.

Here are two numbers in cells.

imageimageIt is easy to create a formula that adds 2 cells, E.g., =A1+A2. Entering this formula in cell A3 effectively sums the first 2 cells into the 3rd cell.

 

jethro's picture

The future revealed - on PsyJournal

JETHRO_spy_journalb2b-125Just kidding I don't have a crystal ball, and it should be SpyJournal - but I thought the accidental typo made a cool pun!

However what this post is about is revealing a plan to write a number of Back To Basics series. These will be written from two points of views, mine and Amanda's.

 

The reasons for the series.

jethro's picture

When it all goes wrong

I have had an extremely frustrating morning so far.

Last night I went to bed early (midnight)with a fair amount of work in my job queue intending to arise early and get stuck into it.

First thing I noticed when sitting at my desk this morning was the PC had restarted it self - strange I thought. I logged in and then noticed that the local PC backup had failed. On checking why I noticed that a hard drive was missing. Further checks revealed that  hard drive had failed in the night - maybe the cause for the mysterious reboot. This is 2 from a batch of 3 Western Digital 500GB drives that have failed inside a month - any bets on the last one going soon?

jethro's picture

Tag - you're it

After dinner the kids enticed me to come outside. The wife suggested that it would be a good idea if I saw the outside world, so I cautiously poked my head out the door. Fortunately the poisonous UV rays of twilight did not strike me with instant blindness, burning skin or even a faint sense of nausea. Soon I discovered that the dog is still alive (and remembers me), the grass has been mowed (by somone else) and the air smells different when it isn't pumped through an aircon.
Next thing I know 3 girls and I are involved in a mad game of Tag, you're it. I am sure the neighbours (whose house unfortunately hasn't drifted away with tectonic plate movements while I have been locked inside) thought that wild Indians were coming to scalp them.