Top 25 Excel Shortcuts Everyone Should Know

preview_player
Показать описание
A method of increasing productivity when working with Excel is to use shortcut keys. These shortcut keys perform major functions that, when used instead of clicking in the toolbar, dramatically increases efficiency and speed. This video brings to you the following 25 shortcuts:
#Excel2021Shortcuts

00:16 Introduction to Excel shortcuts
00:37 Create an excel table
01:07 Steer within large data tables
01:45 Selecting a range of cells in one direction
02:15 Adding or removing filter function
02:44 Format cells in excel
03:11 Selecting all data in the current region
03:37 Insert a default table
03:56 Auto Sum
04:21 Add a new line in a cell
04:51 Autofill data
05:19 Move a cell or a row
05:44 Select entire row or column
06:06 Hide columns or rows
06:37 Find hidden cells
07:03 Adding fixed reference to a cell
08:07 Fill down/Fill right
08:32 Inserting date and timestamp
08:57 Creating a Pivot table
09:19 Hiding items in a Pivot table
09:39 Grouping items in a Pivot table
09:58 Insert Pivot chart on same spreadsheet
10:17 Insert Pivot chart on different spreadsheet
10:38 Adding comments to a cell
11:00 Edit a current cell
11:20 Pasting special

SKILLCURB TOP 5 EXCEL BOOK PICKS — For Beginners & Intermediate Levels

Subscribe to our channel for more videos and help us create more free content.
Рекомендации по теме
Комментарии
Автор

This is what I was looking for! It worked! 😄

storespring