Highline Excel 2013 Class Video 09

Defined Names & Aggregate Functions


(01:03) Create Defined Name with Name Box.
(02:19) Name Manager. Keyboard = Ctrl + F3.
(03:23) Create Names From Selection. Keyboard = Ctrl + Shift + F3.
(04:12) Enter names into aggregate functions. Paste Name in formulas keyboard = F3.
(07:10) #NAME? error when Defined Name if Deleted.
(08:17) Create multiple Names From Selection.
(10:20) AGGREGATE function to add and ignore errors.


Be the first to comment

Leave a Reply