Learn Excel from Bill Jelen with this daily 2 minute video podcast.
Episode 1048 will show you a cool way to speed data entry using a combination of the tab and enter keys. While I have discussed this before on the podcast, using shift-tab makes the trick a bit cooler.
Labels: keyboard shortcuts
posted by Bill at 9:00 AM
Dave from San Francisco suggests you should use Excel without the mouse and challenges you to convert a formula to values in three keystrokes. Episode 958 shows various attempts to solve the problem without using the mouse.
Labels: keyboard shortcuts, OnKey, VBA
posted by Bill at 9:00 AM
Sometimes, you want to enter a formula where one reference doesn't change when you copy the formula down. Episode 410 will show you the shortcut for creating absolute references.
Labels: Alt Keys, keyboard shortcuts, shortcuts
posted by Bill at 9:00 AM
Today's tip comes from Dave in Columbus, Indiana. Dave was at my Power Excel seminar last week and passed along a better way to invoke the Paste Special Values command. In the process of showing Dave's trick, I also talk about joining text using the concatenation operator, changing text from upper case to proper case, copying a formula by double-clicking the fill handle, using Ctrl+z to undo. Episode 394 shows you how.
Labels: Concatenation, keyboard shortcuts, Paste Special, shortcuts
posted by Bill at 9:00 AM
Sure, you probably know that the F4 key can be used to create absolute references in a formula. When you are not in formula entry mode, the F4 key also becomes a shortcut key for the last command issued. Episode 353 shows you how.
Labels: keyboard shortcuts, shortcuts
posted by Bill at 9:00 AM
If you have a lot of numeric data entry to complete, use the tips in this podcast to keep your fingers on the numeric keypad. Stop using the arrow, tab, and home keys using this simple trick. Episode 352 shows you how.
Labels: keyboard shortcuts, shortcuts
posted by Bill at 9:00 AM
