Dueling Excel

Dueling Excel 145

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

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1289

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, [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 30

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 [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 29

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 [Read More >>>]

GETTING STARTED IN EXCEL

What’s New in Excel 2013

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 [Read More >>>]

Excel Features

Using AutoFill In Excel

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1261

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