### Office 2016 32

DESCRIPTION Topics in this video: (00:01) Introduction (01:51) Review of PivotTables we have already completed in this class. (03:15) What is Data Analysis in one sentence (03:34) What’s is Proper Data Set in Excel? (03:50) [Read More >>>]

### Excel Magic Trick 1450

DESCRIPTION Learn how to use Relationships in Excel 2016 (or later versions) rather than the VLOOKUP Function when you are making PivotTable Reports from multiple tables. See how to create a Product / Region Yearly [Read More >>>]

### Office 2016 27

DESCRIPTION Topics in this video: (00:01) Introduction (01:15) Example 1: Excel Table feature for VLOOKUP & Data Validation List (07:10) Example 2: Excel Table feature for Chart (09:45) Example 3: Excel Table feature for PivotTable [Read More >>>]

### Office 2016 26

DESCRIPTION Topics in this video: (00:01) Introduction (01:10) Should we use IF or VLOOKUP? (02:12) What does VLOOKUP do? (03:22) Examples of Lookup Tables (06:14) What does “V” in VLOOKUP mean? (06:41) Formula 1: Exact [Read More >>>]

### Excel Magic Trick 1431

DESCRIPTION See how to: (00:10) Introduction (00:52) XNPV, OFFSET and VLOOKUP formula to calculate the Net Present Value for each Project (10:45) XIRR, OFFSET and VLOOKUP formula to calculate the Net Present Value for each [Read More >>>]

### Excel Magic Trick 1428

DESCRIPTION See how to create a formula that will calculate the Current value of an investment for each row of the table. The table has the yearly Growth Rate and Asset Name. See how to [Read More >>>]

### Excel Magic Trick 1417

DESCRIPTION See how to use Excel Spreadsheet Formulas to rank profits and profits per unit for both All The Products and Products Within Manufacturer. Also see throughout the video various ways to copy a formula [Read More >>>]

### Excel Magic Trick 1410

DESCRIPTION See how to Calculate Closing Balance for Each Month from Balance Transaction Table: (00:10) Introduction (01:20) SUMIFS and MAXIFS method (03:45) SUMIFS and AGGREGATE method (06:07) SUMIFS and VLOOKUP method (07:35) SUMIFS and MAX [Read More >>>]

### Excel Magic Trick 1409

DESCRIPTION In Excel 2016, see how to create a relationship between two tables so that the PivotTable dialog box will list two tables that we can drag and drop fields from both tables to create [Read More >>>]

### Excel Magic Trick 1391

DESCRIPTION See how to create a formula to perform Case Sensitive Lookup: (00:10) Introduction (00:16) VLOOKUP by itself will NOT work. (01:19) Formula #1: SUMPRODUCT & EXACT functions to lookup Numbers based on a Case [Read More >>>]