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

Highline Excel 2013 Class Video 30

April 7, 2017 0

Custom Number Formatting & Text Functions, (33 Examples) DESCRIPTION Topics in this video: 1. 23 Examples of Custom Number Formatting. 2. Custom Number Formatting For Unit Price for Invoice. 3. Three TEXT function examples for […]

Excel Is Fun

Excel Magic Trick 1272

February 20, 2017 0

DESCRIPTION Max Value for Each Day Of The Week: AGGREGATE Function (2 Methods) Learn how to find the max value for each day of the week using the Excel 2010 or later function AGGREGATE. See […]

Excel Is Fun

Excel Magic Trick 1262

January 16, 2017 0

DESCRIPTION Convert Times Values to HHMM Text or Text HHMM Values to Time Values Learn how to use the TEXT function and custom Number Formatting to: (00:12) Convert Times Values to HHMM Text with TEXT […]

Excel Is Fun

Excel Magic Trick 1258

January 2, 2017 0

DESCRIPTION Add Spaces Between Digits: Custom Number Format & TEXT Function Learn how to use Custom Number Format in Excel to display numbers with spaces and to convert numbers to text with the TEXT Function. […]

Dueling Excel

Dueling Excel 119

November 16, 2016 0

DESCRIPTION Sorting For Plant List, Sort by Month and Day Only See Mr Excel and excelisfun use two methods to override the Sort feature’s default Date sorting technique so that we can sort just by […]

Dueling Excel

Dueling Excel 107

September 23, 2016 0

Count Between Words DESCRIPTION See Mr Excel and excelisfun use three methods to add a leading zero at front and a dash in middle of a number that may be of variable length: 1. Formula […]

Dueling Excel

Dueling Excel 73

April 13, 2016 0

Coax Time Value From Text: MOD, LEFT, RIGHT, TEXT, MOD Functions DESCRIPTION See Mr Excel and excelisfun use the functions MOD, LEFT, RIGHT, TEXT, TIMEVALUE, and MOD to coax a time value from a time […]

Excel Is Fun

Excel Magic Trick 1196

March 14, 2016 0

YYMMDD Text Dates To Serial Number Dates? 2 More Formulas & Other Tips… DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then […]

Dueling Excel

Dueling Excel 68

March 9, 2016 0

Count Dates in Column That Match Year and Month Criteria DESCRIPTION See Mr Excel and excelisfun Count Dates in Column That Match Year and Month Criteria with the functions: DATEVALUE, EOMONTH, LOOKUP, SUM, TEXT, COUNTIFS […]