Excel Magic Trick #147: Dynamic List from Table #2
by
ExcelIsFun
on
Youtube
Duration:
0.16 hours
See how to how to extract records from standard table and put a record in a column. See how to use the functions; VLOOKUP, IF, ROWS functions. See data ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #154: Personal Budgets and VLOOKUP
by
ExcelIsFun
on
Youtube
Duration:
0.13 hours
See how to create a personal budget based on past data, contract numbers, the SUM function, cell references, subtraction and the VLOOKUP function. Formulas ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #149: Reverse 2-Way Lookup No Duplicates
by
ExcelIsFun
on
Youtube
Duration:
0.15 hours
See how to take a value in a table and then return the row or column value when there are no duplicate values. See how to do a reverse two-way lookup when ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #148: Dynamic List from Table #3
by
ExcelIsFun
on
Youtube
Duration:
0.18 hours
See how to how to extract records from non-standard table and put a record in a column. See how to use the functions; IF, ROWS, INDEX, MATCH, COUNTIF ...
Format Formatting Spreadsheets. Learn how to apply formatting efficiently and with eye-candy effectiveness. Learn about basic guidelines for formatting and ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #151: DATEDIF function (between two dates)
by
ExcelIsFun
on
Youtube
Duration:
0.1 hours
Calculate the days, months or years between two dates. See how to use the undocumented Excel DATEDIF function. See how to: 1) Calculate the number of ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick # 155: VLOOKUP & TRIM function
by
ExcelIsFun
on
Youtube
Duration:
0.07 hours
When the VLOOKUP function should work and it does not, try the TRIM function to get rid of extra spaces. Use VLOOKUP & TRIM together in one formula when ...
Solve Duplicate VLOOKUP function problem with COUNTIF formula that creates a column of unique values for the first column in the lookup table. COUNTIF ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick # 164: CEILING function in Price Formula
by
ExcelIsFun
on
Youtube
Duration:
0.07 hours
See how to how to use the IF and CEILING functions in one formula to calculate the Price for shipping. The CEILING function is a great solution when you need ...
