The GoTo feature in Excel 2007 is very useful to go to a referenced cell quickly, even a named range or cell. For, example the shortcut to open up the GoTo window is hitting F5 on the keyboard. Then in the Reference field type in a cell you want to go to like X1000 and click OK to be instantly taken to that cell reference. Now if you know how to name a cell or a range of cells you'll have the advantage. Once you learn how to name a cell or a range of cells with your own custom name like Q4_2008, it will appear in the GoTo Feature window for you to select and hit Enter or click OK to be taken to a cell that you recognize, because you've named it yourself! Learn this and more with our training videos...

Purchase the training video and you can see this in action for yourself!