Excel Is Fun

Highline Excel 2013 Class Video 32

April 21, 2017 0

DESCRIPTION Topics in this video: 1. Essential definition of array formula: operation on an array of items rather than single items. 2. Example of operation on single items: subtracting 2 cells. 3. Example of operation […]

Excel Is Fun

Highline Excel 2013 Class Video 31

April 14, 2017 0

Date Functions: EDATE, EOMONTH, DATE, YEAR, MONTH, DAY, More DESCRIPTION Topics in this video: 1. TODAY function to put in today’s date so that it updates each day. 2. NOW to put in today’s date […]

Excel Is Fun

Excel Magic Trick 1285

April 6, 2017 0

OR Criteria & AND Criteria for Max & Min Calculations (5 Examples) DESCRIPTION Learn how to calculate the MIN and MAX values when there is complex criteria that mixes OR Logical Tests and AND Logical […]

Excel Is Fun

Excel Magic Trick 1251

November 28, 2016 0

DESCRIPTION SUMIFS & Table Formula Nomenclature (Structured References) to Add Invoices Learn how to use SUMIFS function and Table Formula Nomenclature (Structured References) to add amounts for Invoices. WORKBOOKS

Dueling Excel

Dueling Excel 120

November 23, 2016 0

DESCRIPTION Summarize By Week and Month, Monthly Totals, Weekly Totals See Mr Excel and excelisfun use two methods to Summarize By Week and Month: 1. See two methods that use SUMIFS, EOMONTH, WEEKDAY and other […]

Excel Is Fun

Excel Magic Trick 1237

October 10, 2016 0

DESCRIPTION Add with “Contains Criteria” or Partial Text Criteria: SUMIFS & Wildcard Learn how to add with “Contains Criteria” or Partial Text Criteria using the: SUMIFS function and the Wildcard, Asterisk, which stands for zero […]

Excel Is Fun

Highline Excel 2016 Class 02

July 24, 2016 0

Excel Fundamentals: Comprehensive Formula Lesson (15 Examples) DESCRIPTION In this video learn about: (00:13) Introduction (01:09) Excel’s Golden Rule (04:31) Look at list of Formula Types and Formula Elements (06:29) Number Formula Examples (08:24) Text […]

Dueling Excel

Dueling Excel 87

July 20, 2016 0

Positive Subtotals Only: PivotTable or SUMIFS DESCRIPTION See Mr Excel and excelisfun use two methods to add only the subtotals that are positive (ignore negative Subtotals using PivotTable Pivot Table or SUMIFS or SUMPRODUCT functions. […]

Excel Is Fun

Excel Magic Trick 1188

January 18, 2016 0

SUMIFS with Wildcards to Do Approximate Criteria or “Fuzzy” Criteria DESCRIPTION See how use asterisk wild card to add all the cells that contain the word “Red”. SUMIFS with Wildcards to Do Approximate Criteria or […]

Dueling Excel

Dueling Excel 52

November 25, 2015 0

Lookup Two Criteria: SUMIFS, DGET, or Array Formula? DESCRIPTION See Mr Excel and excelisfun lookup a value given two criteria. You will see three formulas: SUMIFS formula, DGET formula, and an array formula that uses […]