About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #168: Cross Tabulation For a Survey
by
ExcelIsFun
on
Youtube
Duration:
0.11 hours
See how to summarize survey results with a Pivot Table (PivotTable) or a Formula. See how to create a Pivot Table in Excel 2003 or 2007. See how to create an ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #172: Running Total Formula or Pivot Table
by
ExcelIsFun
on
Youtube
Duration:
0.07 hours
See how to create a Running Total with a Formula or a Pivot Table. For formulas, the trick is to use the SUM function and lock one of the cells, but not the other.
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #171: MACRO Data Validation from 3 lists
by
ExcelIsFun
on
Youtube
Duration:
0.18 hours
Create a MACRO using Relative and Absolute cell references in order to create a Data Validation List from 3 separate lists on 3 separate (different) worksheets.
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #174: Smartest Excel People In The World
by
ExcelIsFun
on
Youtube
Duration:
0.12 hours
See an incredible Excel Trick From Aladin at the Mr Excel Message Board. See how to lookup up the last value in an unsorted list. Learn about the LOOKUP ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #173: Time Over or Under (Negative Time)
by
ExcelIsFun
on
Youtube
Duration:
0.13 hours
See how to show Negative time with the "Use 1904 date system". See how to create a formula that will show the time over or under a hurdle. The IF function uses ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #176 Get Last Item in Column on Diff Sheet
by
ExcelIsFun
on
Youtube
Duration:
0.15 hours
See how to get the last number or word from a column on a different sheet. See how to use the LOOKUP, OFFSET, MAX and ROW functions, as well as an array ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #182: Workbook References
by
ExcelIsFun
on
Youtube
Duration:
0.17 hours
See how to create formulas with workbook references. See how to make a formula that looks at a range of cells in another workbook. Learn about the syntax ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #177: Data Validation Trouble
by
ExcelIsFun
on
Youtube
Duration:
0.07 hours
See how to format a column with the Text Number Format to avoid Data Validation Trouble. Excel interprets 10-8895 as the date Oct, 8895 Excel interprets 0856 ...
