Excel Is Fun

Highline Excel 2013 Class Video 27

March 17, 2017 0

DESCRIPTION Topics in this video: 1. List of possible errors in Excel. 2. 4 Steps to finding formula errors. 3. 3 Examples of how to use the 4 steps. 4. Cleaning Text data with the […]

Excel Is Fun

Excel Magic Trick 1277

March 9, 2017 0

DESCRIPTION Learn how to to Sort Logical Values Alphabetically: false, FALSE, False, true, TRUE, True, and mixed single word text. See how using a space at the end of text will work, but will cause […]

Excel Is Fun

Excel Magic Trick 1255

December 12, 2016 0

DESCRIPTION Formula to Convert Text Dates With Missing Year & Extra Spaces To Real Dates Learn how to Convert Text Dates With Missing Year & Extra Spaces To Real Dates (Serial Number Dates) with a […]

Excel Is Fun

Excel Magic Trick 1242

October 27, 2016 0

DESCRIPTION Transform Large Data Set to Final GDP Report: TTC, MATCH, Filter & Format Learn how to Take Large Data Set with Country Economic Data for the years 1970 to 2013 and filter, delete and […]

Excel Is Fun

Excel Magic Trick 1199

April 4, 2016 0

Formula to Extract Everything After Last Space: Two Formula Solutions DESCRIPTION See how to use Formula to Extract Everything After Last Space: (00:08) Problem Setup (01:05) Formula with TRIM, RIGHT, SUBSTITUTE, REPT, LEN and LEN […]

Dueling Excel

Dueling Excel 67

March 2, 2016 0

Extract Initials From Full Name: VBA or Formula? DESCRIPTION See Mr Excel and excelisfun Extract Initials From Full Name using: VBA and a Formula. See the Functions TRIM, REPLACE, LEFT, and SEARCH. WORKBOOKS

Dueling Excel

Dueling Excel 51

November 18, 2015 0

Extract Dates from Cell With Dates and Words DESCRIPTION See Mr Excel and excelisfun Extract Dates from Cell With Dates and Words using two different methods. See the functions: DATEVALUE, RIGHT, IFERROR, LEN, TEXT, SEARCH, […]