Excel Magic Trick 303: VLOOKUP from middle of text-string
by
ExcelIsFun
on
Youtube
Duration:
0.1 hours
See how to use VLOOKUP function formula when the lookup item is in the middle of a product code (text string). See the VLOOKUP, REPLACE & LEFT functions ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Highline Excel Class 12: DATE functions & Formulas
by
ExcelIsFun
on
Youtube
Duration:
0.16 hours
Download Excel file: http://people.highline.edu/mgirvin/excelisfun.htm See how to use the functions: TODAY, NOW, DATE, YEAR, MONTH, DAY, EDATE. This is ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Highline Excel Class 13: Text functions & AMPERSAND
by
ExcelIsFun
on
Youtube
Duration:
0.33 hours
Download Excel file: http://people.highline.edu/mgirvin/excelisfun.htm See how to transform data into useful data using formulas and Text functions such as; ...
See Mr Excel and excelisfun try and create Horizontal Subtotals for a data set. See the IF, SUM and SUMIF functions as they try to solve this very difficult problem ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 302: Randomly Select Names No Repeats
by
ExcelIsFun
on
Youtube
Duration:
0.06 hours
See how to use the INDEX & MRAND functions to randomly select names without repeats. Learn about MoreFun (More Functions) add-in. Excel Magic Trick 276 ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Highline Excel Class 18: Subtotals
by
ExcelIsFun
on
Youtube
Duration:
0.14 hours
Download Excel file: http://people.highline.edu/mgirvin/excelisfun.htm See these 5 Subtotal examples: 1. Basics of the Subtotal Feature including Sorting before ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Highline Excel Class 17: Filter, Filtering 8 Examples
by
ExcelIsFun
on
Youtube
Duration:
0.13 hours
Download Excel file: http://people.highline.edu/mgirvin/excelisfun.htm See these 8 Filtering Examples: 1. Keyboard shortcut: Ctrl + Shift + L 2. See that Filtering ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Highline Excel Class 14: How To Setup Data in Excel
by
ExcelIsFun
on
Youtube
Duration:
0.08 hours
Download Excel file: http://people.highline.edu/mgirvin/excelisfun.htm See how to set up data in Excel so sorting, filtering, subtotals and PivotTables (Pivot ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Highline Excel Class 16: Sort, Sorting 10 Examples
by
ExcelIsFun
on
Youtube
Duration:
0.17 hours
Download Excel file: http://people.highline.edu/mgirvin/excelisfun.htm See these 10 Sorting Examples: 1. Sort 1 column with buttons 2. Add an order column to ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Highline Excel Class 15: Excel 2007 Tables 7 Examples
by
ExcelIsFun
on
Youtube
Duration:
0.18 hours
Download Excel file: http://people.highline.edu/mgirvin/excelisfun.htm See the Amazing Excel 2007 Tables do these things: 1. Keyboard shortcut to create table ...
