Excel Magic Trick #113: Nested IF & Short Term Loans
by
ExcelIsFun
on
Youtube
Duration:
0.17 hours
Nested IF example. See how to use the TEXT function, concatenation using the Ampersand (&) symbol and the IF function to create labels and loan calculating ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #110: Partial Text Conditional Formatting
by
ExcelIsFun
on
Youtube
Duration:
0.12 hours
See how to use the MID, SEARCH, FIND and LEN functions in a TRUE FALSE formula for Conditional Formatting. See how to add formatting when only part of ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #111: Build A Questionnaire
by
ExcelIsFun
on
Youtube
Duration:
0.13 hours
See how to put the IF function inside a VLOOKUP function, add Data Validation, use an Array formula, unlock cells and protect the sheet all in order to create a ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #118: Reverse 2-Way Lookup Part 2
by
ExcelIsFun
on
Youtube
Duration:
0.1 hours
Watch Part 1 first. This Part 2 gets very complicated, but it is quite cool: See the functions, IF, INDEX, MATCH, SMALL, TEXT, ROW, ROWS, COLUMN and ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #121: Count With More Than 1 Criteria Condition
by
ExcelIsFun
on
Youtube
Duration:
0.13 hours
See how to Count With More Than 1 Criteria with four different formulas and functions: SUM, SUMPRODUCT, SUM & IF, COUNTIFS. See how to do it in a table ...
