Excel Is Fun

Excel Magic Trick 1337

October 17, 2017 0

DESCRIPTION If you try to make X-Y Scatter Chart from PivotTable is will NOT work!!!!! See how to use Power Query to create the same output as a PivotTable in order to make an X-Y […]

Excel Is Fun

Excel Magic Trick 1333

October 11, 2017 0

DESCRIPTION Learn about Banker’s Rounding or Gaussian Rounding: (00:15) What is Banker’s Rounding? (02:30) Normal Excel ROUND Function (Arithmetic Rounding, NOT Banker’s Rounding) (03:18) Excel formula to do Banker’s Round using IF, MOD, MROUND and […]

Excel Is Fun

Excel Magic Trick 1328

October 4, 2017 0

DESCRIPTION See how to: (00:17) Introduction to Formulas for Counting and Adding with Case Sensitive Criteria (00:55) Power Query (Get & Transform) and Converting Proper Data Set to an Excel Table (01:38) Excel Filtering is […]

Excel Is Fun

Excel Magic Trick 1327

October 3, 2017 0

DESCRIPTION See how to create a Formula to Count Words in a Column with Mixed Data: Not COUNTA, but with COUNTIFS with the criteria “*?” (Count Text with One or More Characters) and NOT a […]

Excel Is Fun

Excel Magic Trick 1324

September 28, 2017 0

DESCRIPTION See how to extract records with a formula: (00:17) Problem Introduction (01:23) Use ROWS as the Number Incrementor in a Data Extraction Formula when the criteria does not change as the formula is copied. […]

Dueling Excel

Dueling Excel 150

July 12, 2017 0

DESCRIPTION See Mr Excel and excelisfun lookup the first value in column A when the first value in B is greater than 100: (00:13) Method 1: IF function and array operation inside MIN function inside […]

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

Excel Is Fun

Highline Excel 2013 Class Video 37

May 26, 2017 0

DESCRIPTION Topics in this video: 1. Advanced Filter: Cross Between Filter and Database Functions. 2. Advanced Filter 3 Areas: Criteria Area Data Set Extract Area: Be sure to keep area below CLEAR!!!! 3. Advanced Filter […]

Excel Is Fun

Highline Excel 2013 Class Video 26

March 10, 2017 0

DESCRIPTION Topics in this video: 1. Is Item In List 2 also in List 1? Use MATCH and ISNUMBER. Comparing a prospective customer sales phone list to the companies master customer list. 2. Sort Dialog […]

Dueling Excel

Dueling Excel 126

January 25, 2017 0

DESCRIPTION SUM Daily Totals from Text Dates with Text Day Criteria See Mr Excel and excelisfun use two methods to 1. Add up daily sales from a template that is not setup properly: multiple columns […]