Excel Basics 7: Keyboard Shortcuts Are Fast!

Показать описание

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
In this video learn these amazing Excel Keyboard Shortcuts:
1. Ctrl + Arrow Key == Jump to end. If all empty, jump to last empty
2. Ctrl + Home == Go To A1
3. Ctrl + Shift + Arrow Key == Select column or row (go until it sees an empty cell). Works in cells, formulas, dialog boxes.
4. Ctrl + Backspace == Jump Back to Active Cell
5. Alt, 1 == get first command in QAT
6. Ctrl + * == Select Current Region (go in all directions until it sees an empty cells)
7. Alt + = == SUM function
8. Tab = Insert "Blue" highlighted function from function drop-down list
9. F4 == puts dollar signs in cell references. And it jumps screen back in view.
10. Arrow == Put Cell Reference into Formula
11. Ctrl + Enter = to put item in cell and keep cell selected
12. F2 == Put Cell in Edit Mode
13. Alt, N, V == PivotTable dialog box
14. Alt, P, S, P == Page Setup

Рекомендации по теме

Комментарии

You’re amazing and your videos are genuinely helpful… a student from Nigeria…. I appreciate you.

chinonyeremethelbertanyana

Hi, Sir. I try to learn two or three videos everyday from your channel because I am sure that this is a life changing habit.

carmenchen

You are simply a legend. Never seen such instructor before

sadmanshahriar

Following your tutorials makes me feel like a little kid watching a magic show. It's a constant stream of and :)

andreacarr

The Ctrl+Backspace shortcut is really helpful. It was very tough to enter data ranges in long data sets without that shortcut. Thanks!

tvts

Nothing is less in your teaching so like in a lucid way. You keep the subject really fun and enjoyable

pitamghosh

Thank you so much for this, for a first time excel student you make it seem easier.

valentinedlamini

These videos are insanely good. Thank you Mr Excelisfun, you are doing a great service for the community.

alannahmilton

The HOW of WOW~~ Interned at Deloitte, saw auditors working on their excel without touching the keyboard, I was like that is amazing.

leejohnny

0:30 "ctrl" + "down arrow" to JUMP to the bottom (stops when it runs into an empty cell)
1:20 "ctrl" + "shift" + "down arrow" to highlight to the bottom (you can do this for up arrow, left arrow, and right arrow too)
1:56 "ctrl" + "backspace" to JUMP back to the active cell
2:32-3:24 "alt" key will pop up screen tips and your customized
3:25 "ctrl" + "shift" + "8" to highlight entire table
5:35 "ctrl" + "enter" to enter in the formula you just typed while keeping the cell selected
7:00 "F2" key to edit the selected cell's formula (edit mode)
7:18 "alt" + "N" + "V" to create a pivot table
7:24 "alt" + "P" + "S" to open up page setup

marcousgoose

Sir,

Your every video is more than excellent. I am so confident that there is no other advanced tutorial and trainer like you. I am not interested to follow any other trainer's tutorial if you have tutorial in which I am interested to learn. If it is possible, I will give a lot of Thumbs Up in every of your videos. We need trainer like you to make the world more better. I usually suggest to download and follow your videos whoever want to learn excel meeting with me. Thanks a lot to keep love and patience in your teaching field.

MonirulIslam-zjve

At 6:46, using a trick I learned from you (of course!), if you highlight the cells you want to copy a formula into and go into edit mode to create the formula when you hit control+enter the formula is instantly copied into the active cells. It saves you from having to double-click the "angry rabbit" ! Thanks for another great video.

RobMichaels