Excel Is Fun

Excel Magic Trick 1121

DESCRIPTION See how to: Calculate Compounding Rate/Geometric Mean with the new RRI function in Excel 2013 WORKBOOKS

Excel Is Fun

Excel Magic Trick 1120

DESCRIPTION See how to create a Logical Formula that will check whether an item in in all three lists using 2 MATCH functions and the ISNUMBER function. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1119

DESCRIPTION See how to: 1. Create formula for Conditionally Formatting a Date when 44 days have passed 2. Create formula to Conditionally Formatting the whole row when 44 days have elapsed after a given date. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1118

DESCRIPTION See how to Extract Word That Occurs Most Frequently: (00:07) MODE calculation for text. (00:57) COUNTIFS function for basic mode calculation (01:38) INDEX, MODE and MATCH function (with function argument array operation) to extract [Read More >>>]

Excel Is Fun

Excel Magic Trick 1117

DESCRIPTION See how to calculate an average for 12 different samples when numbers are in a single column: (00:25) PivotTable (average in one condition/criteria) (02:22) AVERAGEIFS Function (average in one condition/criteria) (05:37) AVERAGE, ROWS and [Read More >>>]

Excel Is Fun

Excel Magic Trick 1116

DESCRIPTION (00:37) INDEX and MATCH when we have a two fields (columns): Sample Number and Number To Be Averaged. Use MATCH to lookup first occurrence of each sample number with Exact Match, which only finds [Read More >>>]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 13

DESCRIPTION See how to improve spreadsheet performance (calculation speed) by replace a workbook with array formulas to do 3 way lookup for big data by using PowerQuery and PowerPivot: 1. Using PowerQuery import three data [Read More >>>]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 12

DESCRIPTION See how to create Student GPA Grade by Class for each High School, with each report on a new sheet, automatically using a PivotTable and Show Report Filter Pages. This feature is NOT available [Read More >>>]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 11

DESCRIPTION See how to: (00:47) Group By Date: Excel PivotTable: 1) Drag Date to Rows, Right-click Group, Years and Months (02:04) Group By Date: PowerPivot PivotTable: (02:07) Add Revenue Table to PowerPivot Data Model (02:46) [Read More >>>]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 10

DESCRIPTION Topics in this video: (00:34) Essence of PivotTable (01:08) Overview of Filter Context and CALCULATE (02:30) Look at how Filter Context works on a Calculated Field (03:53) COUNTROWS function to see “Filtered Table” Example [Read More >>>]