Excel Topics

Excel 2013 Workbooks

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1320

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

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

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: [Read More >>>]

Excel Is Fun

Excel Magic Trick 1318

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1317

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 [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 50

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. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1316

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) [Read More >>>]

Tricks & Tips

Highlight Duplicate Values

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 [Read More >>>]