Excel Is Fun

Office 2016 33

DESCRIPTION In this video learn about how to use Excel Tables, One-To-Many Relationships and the Data Model as a substitute for a VLOOKUP Function Helper Column for a Large Data Set. Discuss pros and cons. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1458

DESCRIPTION Learn how to lookup the price for PVC Pipe in three different tables using VLOOKUP and INDIRECT Function and Defines Names. Defined Names allow us to assign a Named Reference to a lookup table. [Read More >>>]

Excel Is Fun

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 Is Fun

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 >>>]

Excel Is Fun

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 >>>]

Excel Is Fun

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 Is Fun

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 Is Fun

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 Is Fun

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 Is Fun

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 >>>]