Defined Names & Aggregate Functions

Topics: AND and OR Criteria. Important Functions like: SUMIFS, IF, AND, OR, and more…

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)

Download Excel File (contains notes, class projects, video projects, homework, and homework solutions):
Busn214-Week03.xlsx