Download workbook: [ Ссылка ]
This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel.
Topics in this video:
1. Create Defined Name with Name Box. (01:03 min)
2. Name Manager. Keyboard = Ctrl + F3 (02:19 min)
3. Create Names From Selection. Keyboard = Ctrl + Shift + F3 (03:23 min)
4. Enter names into aggregate functions. Paste Name in formulas keyboard = F3. (04:12 min)
5. #NAME? error when Defined Name if Deleted. (07:10 min)
6. Create multiple Names From Selection. (08:17 min)
7. AGGREGATE function to add and ignore errors. (10:20 min)

свернуть