Quick, clean, and to the point

Define name

Windows shortcut 
Mac shortcut 

In Windows, this shortcut now displays the Name Manager dialog, where you can click the New button, to create a new name. There is no actual shortcut for to create a single new name, except through the ribbon: Alt M + MD

On a Mac, this shortcut displays the Define Name dialog box, which offers to name a range based on the current selection.

Just a fantastic site. I have learned a ton in a short period. Your videos shaved about 4 hours off an assignment for work this past week. -Kurt
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