Excel Is Fun

Highline Excel 2013 Class Video 33

April 28, 2017 0

DESCRIPTION Topics in this video: 1. Most sorting is done on a Proper Data Set. 2. Click in single cell and use Sort Button. 3. Whole data set is sorted, not just selected column. 4. […]

Excel Is Fun

Excel Magic Trick 1291

April 27, 2017 0

DESCRIPTION Learn how to Score Myers-Briggs Assessment (Test) in Excel with Two Formulas: (00:13) Problem Introduction (01:50) Formula 1: Lookup correct letter for each answer. An array Operation, COLUMN function, SUMPRODUCT function and INDEX Function. […]

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

Highline Excel 2013 Class Video 32

April 21, 2017 0

DESCRIPTION Topics in this video: 1. Essential definition of array formula: operation on an array of items rather than single items. 2. Example of operation on single items: subtracting 2 cells. 3. Example of operation […]

Excel Is Fun

Excel Magic Trick 1289

April 20, 2017 0

DESCRIPTION Why Doesn’t =ROW(1:LEN(A1)) Work? Learn 6 methods to remove “USD” from a column of values such as $ 1.23 USD, $ 56.34 USD, etc. that resulted from multiple downloaded CSV Files, including Replace feature, […]

Dueling Excel

Dueling Excel 138

April 19, 2017 0

DESCRIPTION NETWORKDAYS.INTL Amazing New “Any Weekend” Argument Learn about amazing new feature in the NETWORKDAYS.INTL function for counting workdays that will accommodate any weekend scenario. See counting workdays and Conditional Formatting for weekdays or weekend. […]

Excel Is Fun

Excel Magic Trick 1288

April 17, 2017 0

DESCRIPTION Why Doesn’t =ROW(1:LEN(A1)) Work? Learn the formula =ROW(1:LEN(A1)) does not work. See that the INDIRECT Function comes to the rescue to create a formula that does work: =ROW(INDIRECT(“1:”&LEN(A1))) Work. Alos learn about the robust […]

Excel Is Fun

Highline Excel 2013 Class Video 31

April 14, 2017 0

Date Functions: EDATE, EOMONTH, DATE, YEAR, MONTH, DAY, More DESCRIPTION Topics in this video: 1. TODAY function to put in today’s date so that it updates each day. 2. NOW to put in today’s date […]

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