Excel Is Fun

Highline Excel 2016 Class 02

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 and Number Formulas for counting numbers above [Read More >>>]

Excel Is Fun

Excel Magic Trick 1310

DESCRIPTION Calculate Minimum Value Greater Than Zero. See the functions: SMALL, COUNTIFS and AGGREGATE (LARGE). WORKBOOKS

Dueling Excel

Dueling Excel 141

DESCRIPTION See Mr Excel and excelisfun in an epic back and forth duel (7 back and forths) try to figure out how to lookup three different items in three different tables and then multiply the [Read More >>>]

Dueling Excel

Dueling Excel 133

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 [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 24

Getting Top 5 Values With LARGE And Bottom 5 With SMALL DESCRIPTION Topics in this video: 1. Getting Top five values with LARGE and ROWS 2. Getting Bottom five values with SMALL and ROWS WORKBOOKS

Excel Is Fun

Excel Magic Trick 1271

DESCRIPTION Extract Top 20 Values & Dates: Formula, Array Formula or Power Query? Learn how to extract Top 20 values and dates for those values using Formulas when there are no duplicates, Array Formula for [Read More >>>]

Dueling Excel

Dueling Excel 88

Highlight Cumulative Top 70% DESCRIPTION See Mr Excel and excelisfun use two methods to Highlight Cumulative Top 70%. Two long winded methods to highlight, not top 70% values, but the values that make up 70% [Read More >>>]

Dueling Excel

Dueling Excel 78

Extract Top Two Customers In Each Industry with Formula (2 Examples) DESCRIPTION See Mr Excel and excelisfun Extract Top Two Customers In Each Industry with 2 array Formulas that use the AGGREGATE, IF, COLUMNS, INDEX, [Read More >>>]

Dueling Excel

Dueling Excel 58

Sorting Formula For Biggest Sales and Sales Rep Names with Ties DESCRIPTION See Mr Excel and excelisfun create formulas for sorting biggest to smallest (descending) numbers that can deal with ties, then sort the sales [Read More >>>]