Excel Is Fun

Highline Excel 2013 Class Video 40

June 16, 2017 0

DESCRIPTION Topics in this video: 1. Built-in Conditional Formatting. Conditional Formatting to cells: A logical test that comes out TRUE or FALSE. TRUE = get Formatting. FALSE = Not get Formatting. 2. Highlight Cell Rules: […]

Dueling Excel

Dueling Excel 143

May 24, 2017 0

DESCRIPTION See Mr Excel and excelisfun create two solutions for looking up and calculating a percentage commission that does not exceed the max amount for some of the products. See the functions: VLOOKUP, MIN, and […]

Excel Is Fun

Highline Excel 2013 Class Video 35

May 12, 2017 0

DESCRIPTION Topics in this video: 1. 3 Reports with Formulas. 2. What is a PivotTable do? a. Summarise data b. “Calculation with criteria” c. Create Reports that contain calculations with conditions/criteria 3. Proper Data Set. […]

Dueling Excel

Dueling Excel 141

May 10, 2017 0

DESCRIPTION See Mr Excel and excelisfun in an epic back and forth duel (7 back and forths) try to figure out how to lookup three different items in three different tables and then multiply the […]

Excel Is Fun

Excel Magic Trick 1292

May 1, 2017 0

DESCRIPTION Learn how to Score Myers-Briggs Assessment (Test) in Excel with Two Formulas based on a proper lookup table created with Power Query (Excel 2016 Get and Transform): (00:12) Problem Introduction (00:50) Use Power Query […]

Dueling Excel

Dueling Excel 139

April 26, 2017 0

DESCRIPTION Tom would like to do a VLOOKUP to pull all employees for a given department. While VLOOKUP can not return multiple results, Bill and Mike come up with formulas to simulate the request. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1290

April 24, 2017 0

DESCRIPTION Learn how to create dynamic ranges using OFFSET or INDEX functions for an unusual multiple lookup table situation where the multiple tables are in a single table and the source data from a database […]

Excel Is Fun

Excel Magic Trick 1287

April 13, 2017 0

DESCRIPTION SWITCH Function: How to Lookup Formulas, References, or Anything Else Learn how to: (00:11) Intro to Exact Match lookup SWITCH Function, including a default value. SWITCH in a New Excel 2016 function. (01:13) SWITCH […]

Excel Is Fun

Excel Magic Trick 1286

April 10, 2017 0

DESCRIPTION Excel 2016 IFS Functions (9 Examples: Compare & Contrast IF & IFS Functions) Learn all about the new Excel 2016 IFS Function for situations where you have three or more items to put in […]

Dueling Excel

Dueling Excel 136

April 5, 2017 0

DESCRIPTION Variable Rent Calculation Based On Days: VBA, IF or VLOOKUP? See Mr Excel and excelisfun use two methods to calculate the total rent for a container based on a sliding scale: 1. VBA with […]