Named Ranges 0:03 Creating Named Ranges from Selection 5:24 Named Ranges (Continued) 8:31 IF Functions 11:15 Formula Auditing Tools 19:26 IF Functions (Continued) 26:05 Nesting Functions 30:51 VLOOKUP 38:42:19 Autofill VLOOKUP & IFERROR 47:20 VLOOKUP Range 54:01 VLOOKUP Range with Nested Functions 59:31 HLOOKUP 1:07:27 SUMIF 1:11:17 AVERAGEIF 1:19:20 SUMIFS 1:23:12 Date Functions 1:27:47 Text Functions 1:34:27 Consolidating Data 1:41:00 Consolidating Data Without Structure 1:45:28 Complex Solver Tool 1:48:27 Solver Tool 1:54:09 Scenario Manager 2:02:11 Data Table 2:09:38 Turning on the Developer Tab 2:16:08 Recording Macros 2:18:18 Editing Macros in VBA & Recording a Second Macro 2:23:46 Adding Macros to the QA Toolbar 2:31:27 Adding Macro Buttons to the Worksheet 2:33:46 Conclusion 2:36:52