Tricks & Tips

Highlight Duplicate Values

August 22, 2017 0

In this example I will show you how to highlight duplicate values in a column or row in less than 20 seconds. Here we have a list of names in Column A which contains some […]

Excel Is Fun

Excel Magic Trick 1315

August 21, 2017 0

DESCRIPTION See how to create a unique sorted list with Power Query WORKBOOKS

Excel Is Fun

Highline Excel 2013 Class Video 49

August 18, 2017 0

DESCRIPTION Topics in this video: 1. Formulas for Units, Sales, Variable Costs, Contribution Margin, Fixed Cost, Total Costs and Net Income. 2. X-Y Chart for Break Even Analysis. 3. Formulas and Chart label for Break […]

Excel Is Fun

Excel Magic Trick 1314

August 17, 2017 0

DESCRIPTION See Excel Formula To Create Sorted Unique List On Mixed Data: (00:08) Problem set up (01:26) Essential logical behind Sorting Formula (04:38) Unique Count Formula For Mixed Data (08:27) Formula to Extract a Sorted […]

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