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 1452

DESCRIPTION See two methods: 1) PivotTable Method, 2) Array Formula Method. The PivotTable Method is the easy way to accomplish this. The Array Formula method is a difficult Array Formula, but it can make all [Read More >>>]

Excel Is Fun

Excel Magic Trick 1451

DESCRIPTION Topics in This Video: (00:04) How to Download Files. (00:14) Introduction to building Data Model with Relationships and DAX Formulas without buying Power Pivot in Excel 2016. (02:47) Import Tables and Build Relationships using [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

Excel Magic Trick 1449

DESCRIPTION Video shows how to create DAX Formulas for Change & % Change formulas for both Month Over Month and Year Over Year. Extensive discussion about the hows and whys of how the formula calculates. [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 25

DESCRIPTION Topics in this video: (00:01) Detailed Introduction to the IF Function & Comparative Operators and Logical Tests (08:53) IF Example #01: Your Bonus: =IF(C6 Greater Than =C11,C10,0) (13:39) IF Example #02: In Balance?: =IF(B22=C22,”In [Read More >>>]

Excel Is Fun

Office 2016 19

DESCRIPTION In this video learn these amazing Excel Keyboard Shortcuts: 1. Ctrl + Arrow Key == Jump to end. If all empty, jump to last empty 2. Ctrl + Home == Go To A1 3. [Read More >>>]

Excel Is Fun

Office 2016 17

DESCRIPTION Topics in this video: (00:01) Introduction (01:46) Keyboard for PivotTable (04:00) Why a PivotTable is called a PivotTable (04:25) Cross Tabulated Report (Adding with 2 Criteria) (05:15) Calculations with Conditions or Criteria (07:40) Change [Read More >>>]

Excel Is Fun

Office 2016 16

DESCRIPTION Topics in this video: (00:01) Introduction (01:22) What Excel can do: 1) Calculations, Data Analysis (01:58 and 03:22) What is Data Analysis? (04:00) What is a Proper Data Set? (06:26) SUMIFS for Regional Sales [Read More >>>]