Exceljet

Quick, clean, and to the point

Toggle extend selection mode

Windows shortcut 
F8
Mac shortcut 
FnF8

With extend selection enabled, you don't need to press Shift to extend the current selection.

I've watched three of your videos this morning and while I would consider myself somewhat advanced, I thought the tutorials were helpful and extremely well done.
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