Excel Magic Trick 292: Reverse Last & First Name Tricks
by
ExcelIsFun
on
Youtube
Duration:
0.1 hours
See how to Extract First and Last Names and rearrange them using a formula. For example, go from Smitty, Sioux Z. to Sioux Z. Smitty and from Radcoolinator, ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 294: Filter Pie Chart w Formula & Pivot Table
by
ExcelIsFun
on
Youtube
Duration:
0.2 hours
See how to filter a Pie Chart so that only the Account Manager's Sales Reprentatives show up in the Pie Chart Graph. See how to do this with: 1) Pivot Table and ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 285: Markup On Sell Price Formula
by
ExcelIsFun
on
Youtube
Duration:
0.08 hours
See how to calculate Sales Price given Cost and Markup On Sales Price. Sells Price = Cost/(1-Markup On Sales Price) Base = Part1/Rate1 Base = Part2/Rate2 ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 288: Count Character or Nums. In Text String
by
ExcelIsFun
on
Youtube
Duration:
0.15 hours
See how to count the number of characters or numbers in a text string with a formula that is case sensitive. For example 1) there are three letter a in string: ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 286: MOD function & Time Calculations (Time For Night Shift, or Negat...
by
ExcelIsFun
on
Youtube
Duration:
0.13 hours
See how to calculate hours worked for a night shift where workers start at 9 PM and end at 5 AM. See how to use the MOD function and learn the algorithm that ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #247: Add Leading Zeroes w Formula
by
ExcelIsFun
on
Youtube
Duration:
0.04 hours
See how to add leading zeros to a text string with an array formula. See the functions IF, LEN, MAX and REPT in one array formula. The LEN function counts how ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 301: 1900 Date Problems and Fixes
by
ExcelIsFun
on
Youtube
Duration:
0.14 hours
See how to enter 1900 dates into cells. See how to change Regional Settings to force Excel to accept 1900 dates. See three amazing formulas to convert 1900 ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 299: Date & Time Number - Total Days & Hours Formula
by
ExcelIsFun
on
Youtube
Duration:
0.09 hours
Use the INT function to calculate total days worked and the TEXT function to calculate total hours worked. See the custom number format for total hours past a 24 ...
