Excel Magic Trick #394: IF Function and Conditional Formatting
by
ExcelIsFun
on
Youtube
Duration:
0.08 hours
See how to use the IF function and Conditional Formatting to show the words Warning with a red format when a cell value is too low. Learn about how the ...
See Mr Excel and excelisfun create formula that will take a dollar amount and count how many $100 bills, how many $50 bills, etc. are needed for the minimum ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 404: Quarterly Comparative Report SUMIFS function
by
ExcelIsFun
on
Youtube
Duration:
0.11 hours
See how to use the SUMIFS function to create a Report that shows the differences in Sales between Quarters. See a bunch of cool tricks with the EDATE and ...
See how to use a Pivot Table to create a Report that shows the differences in Sales between Months. See the Pivot Table tricks: 1.Group Dates by Quarter and ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 403: March End Quarterly Comparative Report - Pivot Table
by
ExcelIsFun
on
Youtube
Duration:
0.14 hours
See how to use a Pivot Table to create a Report that shows the differences in Sales between Quarters. See how to create quarters in a Pivot Table that have year ...
See how to use a Pivot Table to create a Report that shows the differences in Sales between Quarters. See the Pivot Table tricks: 1.Group Dates by Quarter and ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 400: Show List of Values In Cells After Using Data Validation Drop-Down
by
ExcelIsFun
on
Youtube
Duration:
0.12 hours
See how to use Data Validation Drop-Down List to show a list of values in cells not just one value in one cell, but many values in many cells. See the IF, ROWS, ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup ...
by
ExcelIsFun
on
Youtube
Duration:
0.08 hours
See how to use the VLOOKUP function when you have two lookup values for each record. Learn how to use the IFERROR function also, and how to join two ...
