Excel Is Fun

Excel Magic Trick 1146

July 27, 2015 0

Create ISO Dates using TEXT function and Custom Number Format DESCRIPTION See how to: 1. Create ISO Dates using TEXT function and Custom Number Format. Like; =TEXT(A5,”yyyymmdd”) 2. Compare two columns of formulas to check […]

Dueling Excel

Dueling Excel 027

June 10, 2015 0

COUNT w More Than 1 Criteria 10 Examples! DESCRIPTION See Mr Excel and excelisfun use 10 different methods for counting with more than 1 criteria. See the functions: SUMPRODUCT w multiplying, SUMPRODUCT w double negative, […]

Excel Is Fun

Excel Magic Trick 1128

April 28, 2015 0

DESCRIPTION See how to create an automated Accounting Ageing Accounts Receivable Reports On Multiple Sheets With Array Formula, Excel Table Feature and Formula Table Nomenclature (Structured References): (00:16) Overview of end result: Automatic Ageing Reports […]

Excel Is Fun

Excel Magic Trick 1118

April 18, 2015 0

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 […]

Dueling Excel

Dueling Excel 020

March 20, 2015 0

DESCRIPTION See Mr Excel and excel is fun summarise survey data with a Pivot Table (Grouping & Report Filter), COUNTIFS function (4 criteria), SUMPRODUCTS formula, SUMPRODUCTS & TEXT functions and DCOUNT database function. Adding Counting […]

Dueling Excel

Dueling Excel 015

February 26, 2015 0

DESCRIPTION See Mr Excel use a Pivot Table with Grouping and a Count function to create a Frequency Distribution. See excel is fun use the FREQUENCY function (upper limit is included in count) to create […]

Excel Is Fun

Highline Excel 2013 Class Video 15

February 14, 2015 0

DESCRIPTION Topics in this video: (00:33) IF Function to deliver numbers. (01:37) IF Function to deliver text. (03:19) IF Function to deliver formulas. (05:19) IF Function to deliver functions. (07:51) Nested IFs. (10:24) Null Text […]

Excel Is Fun

Highline Excel 2013 Class Video 11

February 10, 2015 0

DESCRIPTION Topics in this video: (00:12) OR Criteria. (00:55) OR Criteria for counting with 2 COUNTIFS (03:40) OR Criteria that does counts and yields incorrect answer (don’t double count) (04:30) OR Criteria for counting with […]

Excel Is Fun

Highline Excel 2013 Class Video 10

February 9, 2015 0

DESCRIPTION Topics in this video: (00:34) AND Criteria for SUMIFS, COUNTIFS, AVERAGEIFS (05:18) DSUM (07:53) SUMIFS with 3 criteria. (10:36) Use COUNTIFS or COUNTIF for 1 condition? (12:35) Use SUMIFS or SUMTIF for 1 condition? […]

Excel Is Fun

Excel Magic Trick 1097

February 4, 2015 0

DESCRIPTION See how to: (00:11) AND and OR Criteria. (01:14) Counting Formula with SUMPRODUCT and COUNTIFS and a function argument array operation (03:16) Adding Formula with SUMPRODUCT and SUMIFS and a function argument array operation […]