Exceljet

Quick, clean, and to the point

Excel tips: productivity

These videos come from our Excel video training.
Tip: How to quickly fill in missing data - part 2
In this video, we look at a way to fill in missing data when the structure is not consistent, using formula created with IF and ISBLANK functions.
Run time: 2:56
Tip: How to quickly fill in missing data
An easy way to add missing values to data using a dead-simple relative formula and a few other tricks to select empty cells.
Run time: 3:24
Tip: How to select cells with your keyboard
Excel Pros use keyboard shortcuts to power though big worksheets with blazing speed. In this video, we look at some key shortcuts for selecting cells.
Run time: 2:09
Tip: Is the format painter worth your time? Yes.
A quick video overview of the Format Painter, which transfers formatting to one group of cells to another with a single click.
Run time: 3:13
Tip: How to use drag and drop to move things around
Did you know you can use drag and drop in Excel? It's true. Drag and drop is an alternative to copy and paste, and it can be really handy (and fun) in certain situations.
Run time: 1:51
Tip: How to select visible cells only
In this video, we'll show how to select visible cells only. This is useful when you've hidden rows or columns and want to work only with cells that are actually visible.
Run time: 2:35
Tip: Use the fill handle to enter data with patterns
In this short video, we show you how to use the fill handle to enter data that follows predictable patterns, like dates and numbers.
Run time: 2:05
Tip: How to quickly remove rows with empty values (Win)
In this tip, we look at a cool way to remove rows from a big list or table that contain empty values.
Run time: 2:29
Tip: How to quickly remove rows with empty values (Mac)
In this tip, we look at a cool way to remove rows from a big list or table that contain empty values.
Run time: 2:17
Tip: How to quickly remove blank rows (mac)
A really fast way to delete blank rows, even hundreds or thousands of blank rows, in record time. Excel does all the hard work for you.
Run time: 2:15
Tip: How to quickly remove blank rows (win)
A cool way to delete blank rows, even hundreds or thousands of blank rows, in record time. Excel does all the hard work for you.
Run time: 2:17
Tip: How to move around big lists fast
A handy shortcut for hopping around large lists or tables. Much faster than scrolling.
Run time: 2:37