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

Dueling Excel

Dueling Excel 140

May 3, 2017 0

DESCRIPTION One cell has a security name, ticker symbol, then price. The complicated part is that the security name might have 3, 4, or 5 words. How can you extract the last 2 words into […]

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

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

Highline Excel 2013 Class Video 29

March 31, 2017 0

Flash Fill: Extract, Combine, Insert, Reverse Data (25 Example) DESCRIPTION Topics in this video: 1. Extract First Name. 2. Extract Last Name. 3. Formulas or Flash Fill?. 4. Extract First and Last Initial. 5. Flash […]

GETTING STARTED IN EXCEL

What’s New in Excel 2013

March 19, 2017 0

Welcome Screen The first thing you’ll see when you open Excel is a brand new look. It’s cleaner, but it’s also designed to help you get professional-looking results quickly. You’ll find many new features that […]

Excel Features

Using AutoFill In Excel

February 12, 2017 0

Introduction AutoFill can be used to enter text or numbers such as days of the week, dates, months, text or a series of numbers. Excel has some predefined lists like days and months but you […]

Excel Is Fun

Excel Magic Trick 1261

January 12, 2017 0

DESCRIPTION Flash Fill to Add Spaces to Credit Card Numbers Learn how to use Flash Fill to Add Spaces to Credit Card Numbers. WORKBOOKS