Number 1 - Freeze Panes. Freeze Panes allows you to lock certain portions of the screen. In this example I have a large set of data. When I scroll to the right I lose the first column name information and if I scroll down I lose the header information. To solve this you can use Freeze Panes. Click on the corner where you want the rows above and the columns to the left to be locked. Go to View and click Freeze Panes and choose Freeze Panes from the menu. Now when you scroll right you can see the names in the left column and when you scroll down you can see the rows in the heading. To undo the freeze panes just click on it again and click Unfreeze.

Number 2 - Control Arrow Keys. Don't forget to hold down the Ctrl key when you're arrowing around a set of data. Ctrl right-arrow, down-arrow, left-arrow, up-arrow. It'll move to the end, beginning, bottom, or top of the data set that you're working within.

Number 3 - 3D References. If you're tracking data over a period of time it's often common to create a different month tab for each one of the sets of data and in this case I have September, October, and November. They are identical in terms of the format but the data is different in each. Let's say I want to create a total of all of those. I can hold the Ctrl key down and drag this tab and then rename it to get our Total tab. Let's say we want to add a heading to the top of each one of these charts. We can add it in and go into each one of the tabs one at a time but with 3D Referencing all you have to do is click on one on the end, hold down the Shift key, and click the other end. Now you've highlighted all four of these tabs. Go ahead and do your insert, put in your heading, make your changes, and now when you click on the individual ones you'll see that changes I made we're done on all four. Now let's take our total and let's use a 3D Reference to add the quantities from each one of these three tabs into this cell. I'm gonna hit the Sum. I'm gonna go to the first tab, choose that cell, hold down the Shift key and select all three and hit Enter. Now that you're on the Total tab you'll see that it's summed September through November. Now I'm going to just drag these down, copy them across and you have the total for all three. That is 3D Referencing.