Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
\nDownload Excel Start & Finished File: http:\/\/ift.tt\/2y4I6Gm
\nDownload Full Written Notes: http:\/\/ift.tt\/2lgXWaO
\nClass web page link: http:\/\/ift.tt\/2kPyedk
\nIn this video learn these amazing Excel Keyboard Shortcuts:
\n1. Ctrl + Arrow Key == Jump to end. If all empty, jump to last empty
\n2. Ctrl + Home == Go To A1
\n3. Ctrl + Shift + Arrow Key == Select column or row (go until it sees an empty cell). Works in cells, formulas, dialog boxes.
\n4. Ctrl + Backspace == Jump Back to Active Cell
\n5. Alt, 1 == get first command in QAT
\n6. Ctrl + * == Select Current Region (go in all directions until it sees an empty cells)
\n7. Alt + = == SUM function
\n8. Tab = Insert “Blue” highlighted function from function drop-down list
\n9. F4 == puts dollar signs in cell references. And it jumps screen back in view.
\n10. Arrow == Put Cell Reference into Formula
\n11. Ctrl + Enter = to put item in cell and keep cell selected
\n12. F2 == Put Cell in Edit Mode
\n13. Alt, N, V == PivotTable dialog box
\n14. Alt, P, S, P == Page Setup<\/p>\n