Using the keyboard will make you faster. Much, Much Faster. Mastering these keyboard shortcuts will let you zip around files. Keyboard Shortcuts for Navigation CTRL + HOME — Sends you to A1 CTRL + END — Sends you to the farthest cell (down/right) that's been used CTRL + Arrow Key: — If on a blank cell, sends you to the first filled cell in the arrow's direction — If on a filled cell, sends you to the last filled cell in the arrow's direction. CTRL + Page Down — Next Sheet to the Right CTRL + Page Up — Next Sheet to the Left SHIFT + Arrow Key — Expands the selection in the arrow's direction

Did you know there's a formula view where your cells will show what's in the formulas instead of the calculations? Keyboard Shortcut: CTRL + ` This toggles between the regular view and the formula view.

Just posted #007 in the classroom on line charts which can be found here. Starting with line charts, we'll soon jump into charts with 2 Y-Axes, Combo Charts that use multiple types (line, bar, bubble, area).

Expanding on Line charts, we're looking at how to show multiple lines when the data are in very different ranges (think one metric in the thousands, and the other between 0-10) Solution: Meet the Secondary Y-Axis here

This one may sound a bit boring, but you can set VBA procedures to run at a certain time, whether 10:05 am or 0.2 seconds from now. It's a little feature that can come in useful in many different cases. In the example file I left a few nuggets for you to find. The lesson is available in the Tip of the Day Classroom. Here: #006 Timers Enjoy!