Why you should use Excel and not a 10-Key
Simply put, you have to rekey everything when you make a mistake on a 10-key. Excel was designed for the specific purpose of making it possible to update complex calculations without having to recalculate an entire process. Of course it works real well for simple stuff too!
The Magic Box
Remember a few lessons back I made a magic box?
I didn’t really teach you how to make it. I just made it so we could play with some navigation basics.
Now we’re going to learn how to make one.
I am going to wipe out the one I made earlier, and we are going to make a new one together.
This lesson is interactive, so you need to have a spreadsheet open, and you need to have your finger on the pause button. This way you can pause and practice what I am doing to make sure that you understand it yourself.