Excel Is Fun

Excel Magic Trick 1321

September 25, 2017 0

DESCRIPTION See how to use (00:14) Intro (01:36) MIN & MAX & IF & SEARCH solution (Any Version of Excel) (07:49) INDEX & MATCH & LEFT solution (Any Version of Excel) (08:35) AGGREGATE & ISNUMBER […]

Excel Is Fun

Excel Magic Trick 1317

August 28, 2017 0

DESCRIPTION See how to create formulas to calculate Insulin needed with the formula inputs: Total Carbs in grams, Carb Ratio, Blood Glucose Test, Blood Glucose Target, Correction Factor: (00:12) Problem Setup (00:25) Excel’s Golden Rule […]

Excel Is Fun

Highline Excel 2013 Class Video 40

June 16, 2017 0

DESCRIPTION Topics in this video: 1. Built-in Conditional Formatting. Conditional Formatting to cells: A logical test that comes out TRUE or FALSE. TRUE = get Formatting. FALSE = Not get Formatting. 2. Highlight Cell Rules: […]

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

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 1284

April 3, 2017 0

History of Excel Max or Min with Conditions / Criteria (5 Examples) DESCRIPTION Learn about 5 methods to make a Max or Min AND Criteria (AND Logical Test) Calculation with multiple Conditions / Criteria that […]

Dueling Excel

Dueling Excel 133

March 15, 2017 0

DESCRIPTION See Mr Excel and excelisfun use two methods to sum the three biggest values that match three criteria (3 conditions) 1. Advanced Filter and LARGE and MAX value 2. SUM and LARGE functions with […]

Dueling Excel

Dueling Excel 121

November 30, 2016 0

DESCRIPTION MIN and MAX Between Two Dates For Each Region See Mr Excel and excelisfun use two methods to calculate MIN and MAX Between Two Dates For Each Region (Minimum value and maximum value with […]

Dueling Excel

Dueling Excel 111

October 7, 2016 0

Slowest Time That Is Within 2 Seconds Of The Fastest DESCRIPTION See Mr Excel and excelisfun use two methods to find the Slowest Time That Is Within 2 Seconds Of The Fastest: 1) Mr Excel: […]

Dueling Excel

Dueling Excel 108

September 28, 2016 0

SUM, AVERAGE, STDEV.S, MIN, MAX: Three Methods DESCRIPTION See Mr Excel and Excelisfun calculate descriptive statistics: MIN, MAX, Standard Deviation, Average using three methods: 1) Data Analysis Toolpak Add-in, Descriptive Statistics 2) PivotTable 3) Functions […]