Let's look at some shortcuts that will help us with editing and error checking. If I go down to revenue to start off with and I want to work out where this is coming from I'll hit Alt + P and now I can see the blue arrows showing me what leads into here. It's last year's revenue and my revenue growth of 15%, but now I want to work out where revenue is going to. So I'll hit Alt + MD and I can now see Blue Arrows linking to next year's revenue, linking to operating costs and EBIT. So you see EBIT sums up revenues and many other items as well such as maintenance, CapEx, et cetera. I've now got blue lines going everywhere. Sorry, if I hit Alt + A and then I press A again, that will remove all of my arrows. I'd now like to do some error checking. for this, I'm going to need my circular turned on so I'm gonna go to the info tab, turn that circular switch I get the error warning and I'm going to press ALT + FT and turn my iterations on.

So I've now got interest going through the model. I'd really like to investigate this. I press Alt + MK, but I now realize I can't click on the C for circuit references because it's all grayed out. That's because you've got iterations on and if you've turned iterations on Excel assumes that you are okay with the iterations with the circular so it doesn't come up with the error. So I press ALT + FT again, turn off the enable iterative calculations. The error warning comes back and now if I press ALT + MKC, I can investigate it. It shows me all of the cells involved in just one circular. So if I go to F94, I can see this is involved and I can then follow the blue arrows and dots to go round through this circular. We won't investigate now 'cause I'm happy with this circular. So ALT + MA8 to get rid of those blue lines again and I'm gonna go back to the info tab and turn off that circular, there we go. We're now back at the income statements and I'd like to press ALT + MH to reveal my formulas. Excel now shows all of my formulas instead of the resulting numbers from the formulas. The great thing about this is, is as you go through those cells, it highlights the precedent cells. Very useful aid for helping you check that you've linked the right cells, Alt + EMH again, to turn it off. I'm now thinking I'd like to cycle through some of the component cells from my revenue. So I'm gonna press Ctrl + open square brackets and initially it just jumps me to the very first cell that was in the formula, so that's E24. If I go back into F24 again, I can see that was the first cell reference E24. So I'll do again, Ctrl + open square brackets. If I now press Enter, it's cycles and if I keep pressing enter, it cycles through the component parts of the formula.

If I do that for interest the first thing it's gonna link to here is the switch and that's a cell on the info tab. So let's do it, Ctrl + open square brackets. I've checked that. I'm happy with that now, but I'd now like to jump back where I just came from. I may have jumped through about 50 tabs that would take me a long time to scroll back through. So what I can do is I can press F5 and if I then press Enter, it takes me back to the last place I came from. So some very handy keyboard shortcuts there for editing and checking your model.