Excel Topics

Excel 2013 Workbooks

September 11, 2017 0

Create A New Workbook The following guide will show you how to create a blank workbook. Click the File tab Select New from the left menu Click Blank workbook Add A New Blank Worksheet When […]

Excel Is Fun

Excel Magic Trick 1320

September 7, 2017 0

DESCRIPTION See how to use calculate Distinct Count with 1 Condition to create for How Many Unique Visitors To Site Each Day with Power Query. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1319

September 4, 2017 0

DESCRIPTION See how to use calculate Distinct Count with 1 Condition to create for How Many Unique Visitors To Site Each Day with Two PivotTables. WORKBOOKS

Excel Is Fun

Highline Excel 2013 Class Video 51

September 1, 2017 0

DESCRIPTION Topics in this video: 1. Macro Basics. 2. Format Variable Height Report with Absolute and Relative References. 3. Rearrange Records from Vertical Orientation to Proper Data Set with Relative References. Copy Code from Internet: […]

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