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

Dueling Excel

Dueling Excel 137

April 12, 2017 0

DESCRIPTION Start and End Date, What is Total Pay Over Period Given Month Salary? See Mr Excel and excelisfun use two methods to calculate Start and End Date, What is Total Pay Over Period Given […]

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 116

October 26, 2016 0

Extract Individual Letters From Cell and do Lookup Adding, then… DESCRIPTION See Mr Excel and excelisfun use two methods to do lookup adding from a cell and then show one of three categories: ‘Under Zero”, […]

Excel Is Fun

Excel Magic Trick 1231

September 19, 2016 0

DESCRIPTION VLOOKUP to 36 Different Tables: CHOOSE, OFFSET or INDIRECT function? Learn how to: (00:12) Introduction to problem we want to solve. (01:52) CHOOSE Function Solution, with VLOOKUP and MATCH functions and the asterisk wild […]

Dueling Excel

Dueling Excel 97

August 26, 2016 0

Determine Quarter For column of Dates: CHOOSE or CEILING function? DESCRIPTION See Mr Excel and excelisfun use two methods to create a formula that can take any date and determine what quarter it is. See […]

Tricks & Tips

Display Day Name From A Date

February 23, 2016 0

If you need to get the day name (Monday, Tuesday, Wednesday etc.) from a date there are several options depending on your needs. In this article we will show you a few examples on how […]

Excel Is Fun

Excel Magic Trick 1174

November 2, 2015 0

Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods) DESCRIPTION See three methods for lookup situations where you have two lookup values: (00:10) What to do if you have two look values […]

Excel Is Fun

Excel Magic Trick 1170

October 19, 2015 0

VLOOKUP To Different Table In Each Column: CHOOSE & COLUMNS Functions DESCRIPTION See how to: (00:09) Problem Setup (01:40) COLUMNS Function with expandable range to get Sequential Numbers across the columns (02:17) CHOOSE Function to […]