Highline Excel 2013 Class Video 09

Defined Names & Aggregate Functions

DESCRIPTION

(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.

WORKBOOKS

Download “Highline Excel 2013 Workbooks” Highline-Excel-2013-Video-Workbooks.zip – Downloaded 114 times – 21 MB




Be the first to comment

Leave a Reply