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 24

DESCRIPTION Topics in this video: (00:01) Introduction (00:30) Different Types of Formulas (02:07) Formula Elements – what you can out into a formula. (04:55) Formula 01: Goal: Add calls made a service centre last week.: [Read More >>>]

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

Excel Is Fun

Highline Excel 2016 Class 08

DESCRIPTION In this video learn about: (00:12) Introduction (00:46) Text Formulas: Ampersand to Join Items together (01:38) Text Functions to extract partial text items from a larger text item. (02:57) Extract State with LEFT function [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 02

DESCRIPTION In this video learn about: (00:13) Introduction (01:09) Excel’s Golden Rule (04:31) Look at list of Formula Types and Formula Elements (06:29) Number Formula Examples (08:24) Text and Number Formulas for counting numbers above [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 01

DESCRIPTION In this video learn about these Excel Fundamentals for Excel Highline Excel 2016 Class: (00:33) Prerequisites for class (01:04) Excel Professional 2016 (01:50) Install Com Add-in Power Pivot (02:54) Examples of Effective and Efficient [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

Excel Is Fun

Excel Magic Trick 1274

DESCRIPTION Learn how to avoid long formula with multiple IF Functions by using the lookup functions: VLOOKUP or LOOKUP. Also see a “Partial Text Lookup” Situation where we have to lookup just part of a [Read More >>>]

Dueling Excel

Dueling Excel 110

3 VLOOKUPS Calculate Cost Based on Product, Packaging, Discount DESCRIPTION See Mr Excel and excelisfun use two methods to calculate the total costs when there are three factors that go into calculating costs: Product Name, [Read More >>>]

Dueling Excel

Dueling Excel 107

Count Between Words DESCRIPTION See Mr Excel and excelisfun use three methods to add a leading zero at front and a dash in middle of a number that may be of variable length: 1. Formula [Read More >>>]