Excel Is Fun

Excel Magic Trick 1318

August 31, 2017 0

DESCRIPTION See how to use calculate Distinct Count with 1 Condition to create report and Chart for How Many Unique Visitors To Site Each Day with Two Methods: (00:13) Introduction (01:01) Excel 2016 Data Model […]

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 50

August 25, 2017 0

DESCRIPTION Topics in this video: 1. PMT function from Borrower point of view, End Payment. PMT with Begin Payment. 2. PMT function from Lender point of view. 3. PMT function with Balloon payment at end. […]

Excel Is Fun

Excel Magic Trick 1316

August 24, 2017 0

DESCRIPTION See how to use VLOOKUP when there are multiple Lookup Tables with these methods: (00:15) Problem Set up (01:48) IF Function (05:57) IFS Function (Excel 2016 Insider Program) (Formula from XLarium at YouTube) (08:47) […]

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