Quick, clean, and to the point

Accept function with autocomplete

Windows shortcut 
Mac shortcut 

This shortcut will accept a function suggested by autocomplete. On the PC, you can type Tab to enter the current "best match". On a Mac, you need to first use the down arrow key to select from the list of suggested functions, then press Tab to accept.

Related videos

The videos below demonstrate this shortcut.
In this lesson, we cover shortcuts you can use to create, list, edit, and apply named ranges.
In this lesson, we cover shortcuts you can use when working with Excel's functions.
In this video, we'll look at several ways to to enter Excel functions.
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course
Video training for Excel Tables