Exceljet

Quick, clean, and to the point

Accept function with autocomplete

Windows shortcut 
Tab
Mac shortcut 
Tab

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.

These tutorials are fantastic. People like me learn faster by following along with the steps in the video. -Tim
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course