Excel Is Fun

Excel Magic Trick 1475

DESCRIPTION In this video learn how to rearrange a product code using Excel Spreadsheet Functions and Power Query Functions. Also see that Flash Fill does not seem to work. Learn the Power Query equivalent for [Read More >>>]

Excel Is Fun

Office 2016 37

DESCRIPTION Topics in this Video: (00:01) Introduction to Power Query and the examples in this video (02:50) Difference between Data Ribbon Tabs in Office 365 Excel 2016 and Non-Office 365 Excel 2016 (04:32) Example #1: [Read More >>>]

Excel Is Fun

Office 2016 35

DESCRIPTION Topics in this Video: (00:01) Introduction about Data Analysis features (01:40) Sorting (11:45) Filtering (21:50) Flash Fill (29:01) Summary NOTES WORKBOOKS

Excel Is Fun

Highline Excel 2016 Class 18

DESCRIPTION In this video learn about: (00:13) Introduction (01:08) Find & Replace feature (Clean Data) (03:49) Flash Fill: Clean Data (10 Examples) (11:14) Text To Columns (TTC) (12:16) Text To Columns (TTC) to split data [Read More >>>]

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 >>>]

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