Excel Magic Trick #122: Sum With More Than 1 Criteria
by
ExcelIsFun
on
Youtube
Duration:
0.15 hours
See how to Sum With More Than 1 Criteria with four different formulas and functions: SUM, SUMPRODUCT, SUM & IF, COUNTIFS. See how to do it in a table ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #126: Macro: Advanced Filter Extract Text
by
ExcelIsFun
on
Youtube
Duration:
0.15 hours
See how to create a macro that will do an Advanced Filter Movie Title Extract for a Movie Database. See how to create the TRUE FALSE formula for advanced ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #130: 3 Dimensional Database in Excel
by
ExcelIsFun
on
Youtube
Duration:
0.13 hours
See how to use the Table and List feature with data Validation to create a 3-dementional database (dynamic ranges) in Excel. Also see how to average with ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #131: Ranking w MIN IF OFFSET
by
ExcelIsFun
on
Youtube
Duration:
0.15 hours
See the functions COUNTIF, MIN, IF, OFFSET, VLOOKUP functions formula used in a table to complete a complex ranking. Other Excel concepts: 1) See how to ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #129: More than 7 Nested IF functions
by
ExcelIsFun
on
Youtube
Duration:
0.08 hours
See what to do if you must have more than 7 nested IF functions: 1) Use the Ampersand, Use different cells, buy Excel 2007, use VLOOKUP, or Use a Boolean ...
See how to import files with the extension .csv. See how to use the Text Import Wizard to import data into Excel. See how to use the Text To Column Excel ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #135: Find Last Row & Column Dynamic Range
by
ExcelIsFun
on
Youtube
Duration:
0.11 hours
Create a dynamic range when there are blanks in the data set. Use an array formula to find the Last row or column used in a data set. See the functions: ROW, ...
