Video
Shortcuts for file commands
In this lesson, we cover shortcuts you can use when working with files.Read more
Search results
Looking for more? Try chatting with the Exceljet Chatbot.
Video
Shortcuts for editing cells
In this lesson, we review shortcuts you can use to edit cells more efficiently.Read more
Video
Shortcuts to cut copy paste
In this lesson, we cover shortcuts you can use to cut, copy, and paste. We also cover drag and drop options.Read more
Video
Shortcuts to undo, redo and repeat
In this video, we cover shortcuts you can use to undo, redo, and repeat actions.Read more
Video
Shortcuts to enter data
In this lesson, we cover shortcuts you can use to enter data in one or more cells at a time. Knowing these tips can really speed up editing in Excel.Read more
Video
Shortcuts to find and replace
In this video, we'll look at the shortcuts you can use for find and replace in Excel...Read more
Video
Shortcuts for paste special
In this lesson, we cover shortcuts you can use for the many features provided by Paste Special.Read more
Video
Shortcuts to navigate worksheets
In this lesson, we cover shortcuts you can use to navigate worksheets.Read more
Video
Shortcuts to navigate workbooks
In this lesson, we cover shortcuts you can use to navigate workbooks.Read more
Video
Shortcuts for selecting cells
In this lesson, we cover shortcuts you can use to select cells.Read more
Video
Shortcuts to move the active cell
In this lesson, we cover shortcuts you can use to move the active cell in a selection.Read more
Video
Shortcuts for extending selections
In this lesson, we cover shortcuts you can use to extend selections.Read more
Video
Shortcuts for Go To Special
In this lesson, we cover shortcuts you can use to select special cells with Go To SpecialRead more
Video
Shortcuts for drag and drop
In this lesson, we cover shortcuts you can use for drag and drop in Excel.Read more
Video
Shortcuts for formatting
In this lesson, we cover shortcuts you can use to format cells and other objects.Read more
Video
Shortcuts for number formats
In this lesson, we cover shortcuts you can use to apply key Excel number formats: General, Number, Currency, Date, Time, and Percentage.Read more
Video
Shortcuts for borders
In this lesson, we look at the shortcuts you can use when applying or removing borders.Read more
Video
Shortcuts for formulas
In this lesson, we cover shortcuts you can use when building, editing, or entering formulas.Read more
Video
Shortcuts for functions
In this lesson, we cover shortcuts you can use when working with Excel's functions...Read more
Video
Shortcuts for named ranges
In this lesson, we cover shortcuts you can use to create, list, edit, and apply named ranges.Read more
Video
Shortcuts to insert/delete rows and columns
In this lesson, we cover shortcuts you can use to insert or delete cells, rows, and columns.Read more
Video
Shortcuts to hide/unhide rows and columns
In this lesson, we cover shortcuts you can use to hide and unhide, rows and columns.Read more
Video
Shortcuts to group, ungroup, and outline
In this lesson, we cover shortcuts you can use to group and outline data.Read more
Video
Shortcuts for charts
In this lesson, we cover shortcuts you can use when working with Excel charts.Read more
Video
Shortcut recipe: delete blank rows
In this lesson, we demonstrate a shortcut recipe you can use to remove blank rows quickly.Read more
Video
Shortcut recipe: fill in missing data
In this lesson, we demonstrate a shortcut recipe you can use to fill in missing data from other cells.Read more
Video
Introducing Excel shortcuts
There are hundreds of shortcuts in Excel! In this video, we look at how shortcuts are organized in Microsoft Excel. Read more
Video
Excel shortcuts on a Mac
In this video, we'll talk about using Excel shortcuts on the Mac...Read more
Video
How to find missing values with COUNTIF
In this video, we'll take a look at how to use the COUNTIF function to solve a common problem: how to find values in one list that appear in another list...Read more
Formula
Most frequently occurring number
The MODE function is fully automatic and will return the most frequently occurring number in a set of numbers. For example:
=MODE(1,2,4,4,5,5,5,6) // returns 5
In the example shown, we give MODE the range B4:K4, so the formula is solved...Read more