Excel Is Fun

Excel Magic Trick 1313

August 14, 2017 0

DESCRIPTION Learn how to create an Array Formula to Create Sorted Unique List in Cell. This is a huge complicated formula that requires the Excel 2016 function TEXTJOIN. There are many interesting formula elements in […]

Excel Is Fun

Highline Excel 2013 Class Video 48

August 11, 2017 0

DESCRIPTION Topics in this video: 1. Conditional Formatting: Bar Chart with Data Labels 2. Formula to Define length of Bar WORKBOOKS

Excel Is Fun

Excel Magic Trick 1312

August 10, 2017 0

DESCRIPTION Learn: (00:08) Problem introduction. (00:33) How to use NETWORKDAYS.INTL to count the number of working days between a start and end date. NETWORKDAYS.INTL is in Excel 2010 or later versions. (01:46) Formula to count […]

Excel Is Fun

Excel Magic Trick 1311

August 7, 2017 0

DESCRIPTION See an Array Formula that can extract (from a proper data set) multiple invoice items for one lookup value & show total. See the functions: COUNTIFS, ROW, AGGREGATE, ROWS, INDEX, IF and SUMIFS. See […]

Formulas & Functions

Turning Off Error Checking

August 6, 2017 0

When Excel open it is constantly checking in the background for potential errors in your worksheets. If an Excel detects an error (or at the least what Excel thinks is an error) then the cell […]

Excel Is Fun

Excel Magic Trick 1310

August 3, 2017 0

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

Excel Is Fun

Excel Magic Trick 1309

July 31, 2017 0

DESCRIPTION Learn how to create an array formula to display a unique list in a single cell. This formula comes from Bill Szysz at YouTube. See the functions: MATCH, ROW, IF and the new Excel […]

Excel Is Fun

Highline Excel 2013 Class Video 46

July 28, 2017 0

DESCRIPTION Topics in this video: 1. Formulas for Min and Max values 2. Formulas for Chart Labels 3. COUNTIFS formula to count between upper and lower numbers. BETWEEN Criteria. AND Criteria. 4. Histogram Chart with […]

Excel Is Fun

Excel Magic Trick 1308

July 27, 2017 0

DESCRIPTION Learn how to Concatenate Items in Rows & Columns from Two-Way Table with TEXTJOIN (New Excel 2016 Function). WORKBOOKS