Introduction to tips and time savers in Excel
Entering and selecting data shortcuts and time savers
-
Worksheet time savers - Excel auto fill for quick data entry (4:43)
-
Using ctrl or shift or ctrl A to select data (2:38)
-
Keyboard shortcuts - Copy contents from neighboring cells (1:05)
-
Keyboard shortcuts - Enter today's time and date with typing (2:02)
-
Enter data on a second line in the same cell - keyboard shortcut (2:18)
Microsoft suite shortcuts (universal shortcuts)
Navigating in Excel worksheets shortcuts
Formulas and charts shortcuts
-
Keyboard shortcut - sum all your data at once (3:03)
-
Keyboard shortcut - create an embedded chart (1:37)
-
Keyboard shortcut - create a chart on a separate worksheet (0:46)
-
Create a named range (5:40)
-
Time saver - Save time selecting cells by using named ranges in formulas (2:49)
-
Keyboard shortcut - using named ranges in formulas (1:45)
-
Adjust your formulas to keep a cell constant - Keyboard shortcut (4:41)
Formatting shortcuts
Worksheet time savers
Data manipulation time savers
Reporting data time savers
Automation
Data Analysis
Student resources
