Рет қаралды 295
50 EXCEL Shortcuts you NEED TO KNOW!
DOWNLOAD LIST HERE - www.essentialsexplained.com/s...
Advanced Playlist - • Excel - Advanced Formu...
Looking for more Excel Content
BASIC Formulas & Functions Playlist - • Excel - Basic Formulas...
ADVANCED Formulas & Functions Playlist - • Excel - Advanced Formu...
20 Excel Formulas - • 20 Excel Formulas for ...
Please check out our website at www.EssentialsExplained.com
...and follow us on LinkedIn: / essentials_explained
0:00 Introduction
0:24 #1 Open New Workbook
0:28 Ctrl+S #2 Save Workbook
0:56 Shift+F11 #5 Create New Worksheet
1:27 Ctrl+Drag #7 Copy Worksheet
1:44 Undo Previous Action
2:03 Copy Selection
2:13 Cut Selection
2:26 Paste Selection
2:31 Paste Special
3:31 Edit Cells & Formulas
4:21 Shift+F3 #18 Insert Formula Wizard
4:51 AutoSum
5:10 Erase All Contents
5:22 Outside Border
5:53 Change Font Size
6:30 BONUS Clear Formatting
7:09 Format Cells
7:30 Rename Sheet
7:39 Change Tab Color
7:52 Add Comment
8:07 Ctrl+Arrow Key #31 Move to End of Selection
8:39 Move Sheets
9:27 Shift+Space #35 Select Row
9:34 Select Column
10:18 Shift+Alt+Right Arrow #37 Group Rows/Columns
10:34 Ungroup Rows/Columns
10:47 Show Rows/Columns
11:50 Find Precedent Cell
13:20 Toggle Gridlines
13:45 Page Break Preview