Mr Excel & excelisfun Trick 27: COUNT w More Than 1 Criteria 10 Examples!
by
ExcelIsFun
on
Youtube
Duration:
0.18 hours
See Mr Excel and excelisfun use 10 different methods for counting with more than 1 criteria. See the functions: SUMPRODUCT w multiplying, SUMPRODUCT w ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 390: Increment Word & Number 2 Methods.
by
ExcelIsFun
on
Youtube
Duration:
0.06 hours
See how to do create a column of words and numbers quickly with two different formulas and a mouse trick for Paste Special Values. See how to increment a ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 388: Conditional Formatting and the Active Cell
by
ExcelIsFun
on
Youtube
Duration:
0.06 hours
Learn about why the Active Cell is so important when using a TRUE / FALSE formula with Conditional Formatting. See how to create your formula from any cell ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Mr Excel & excelisfun Trick 28: Find Earliest Date From List Of Dates Given 2 Criteria
by
ExcelIsFun
on
Youtube
Duration:
0.07 hours
See Mr Excel and excelisfun find the record with the earliest date given three criteria. See Filter and Sort, an array formula that uses the MIN and IF functions, ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #395: When ROUND function Must Be Used
by
ExcelIsFun
on
Youtube
Duration:
0.08 hours
Learn about when the ROUND function must be used: 1) Operation is multiplying or dividing 2) You are required to round (money only has pennies) 3) You will ...
