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

Dueling Excel

Dueling Excel 146

June 14, 2017 0

DESCRIPTION Excel Truel: This is a simple Excel task: multiplying, but for a kid, its seems amazing! See Isaac Excelisfunner Girvin, Bill Mr Excel Jelen and Mike excelisfun Girvin try to multiply in Excel. WORKBOOKS

Excel Is Fun

Highline Excel 2013 Class Video 39

June 9, 2017 0

DESCRIPTION Topics in this video: 1. Import Commas Delimited Data From Word Document with Copy and Paste then do Text To Columns. 2. Import CSV File and Txt File. 3. Import Proper Data Set into […]

Dueling Excel

Dueling Excel 145

June 7, 2017 0

DESCRIPTION See Mr Excel and excelisfun convert YYYYMMDD Numbers To Dates: 1. Text To Columns 2. Formula with DATE, LEFT, RIGHT, MID functions 3. Flash Fill 4. Text Function with custom Number Format 0000\/00\/00 WORKBOOKS

Excel Is Fun

Highline Excel 2013 Class Video 38

June 2, 2017 0

DESCRIPTION Topics in this video: 1. Split Text with Delimiter = Space. Split First and Last Name and Skip a column. Text To Columns keyboard: Alt, A, E or Alt, D, E. 2. Split Text […]

Dueling Excel

Dueling Excel 144

May 31, 2017 0

DESCRIPTION See Isaac Excelisfunner Girvin, Bill Mr Excel Jelen and Mike excelisfun Girvin have mirror fun in Excel. Copy stuff like it was a mirror with: Relative Cell Reference Paste Special Picture Link View New […]

Excel Is Fun

Excel Magic Trick 1300

May 29, 2017 0

DESCRIPTION Learn how to list all modes in single cell with TEXTJOIN & MODE.MULT. learn about the three different mode functions: MODE, MODE.SNGL and MODE.MULT. WORKBOOKS

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

Excel Magic Trick 1299

May 25, 2017 0

DESCRIPTION Learn how to: create Automatic Calendar Table in Data Model, New in Excel 2016. This ability was not in earlier versions of Excel. WORKBOOKS

Dueling Excel

Dueling Excel 143

May 24, 2017 0

DESCRIPTION See Mr Excel and excelisfun create two solutions for looking up and calculating a percentage commission that does not exceed the max amount for some of the products. See the functions: VLOOKUP, MIN, and […]