Excel Magic Trick 416: Add Invoices w Same Prefix (Number v Text problem examined)
by
ExcelIsFun
on
Youtube
Duration:
0.09 hours
See how to look through a list of Invoice numbers and add only the ones that have a Prefix of 55 or 58 or 7E. Learn about how Excel treats numbers and text ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 415: Summarize Survey Results 2 Different Methods
by
ExcelIsFun
on
Youtube
Duration:
0.18 hours
See how to summarize survey results (Psychology test) with: 1) Array Formula with SUM, COUNTA and IF functions. 2) VLOOKUP and Data Validation Drop ...
Download file: http://people.highline.edu/mgirvin/excelisfun.htm This 50 minute video shows 15 examples of how to use Cell References: 1) Relative Cell ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 453: VLOOKUP for Commission Brackets Calculation (LOOKUP function also)
by
ExcelIsFun
on
Youtube
Duration:
0.13 hours
See how to calculate commission on sales when there is more than one level of commission incentive pay. See how to make the lookup table smartly to reduce ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 460: Transpose Range with INDEX, COLUMNS and ROWS functions
by
ExcelIsFun
on
Youtube
Duration:
0.05 hours
See how to transpose a range (switch rows and columns) using INDEX, COLUMNS and ROWS function. If you dont want to use TRANSPOSE function, this is a ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Dynamic Chart #11: Dynamic Area Chart with IF Function - Normal Distribution Char...
by
ExcelIsFun
on
Youtube
Duration:
0.12 hours
See how to use the IF function in a column to create a dynamic range for an area chart. Statistics Normal Distribution Area Chart with X values. Standard Normal ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Dynamic Chart #10: OFFSET Function Dynamic Range
by
ExcelIsFun
on
Youtube
Duration:
0.25 hours
Download Excel File here: http://people.highline.edu/mgirvin/excelisfun.htm (in "Excel Dynamic Chart Series" section, second to last at the bottom). See how to ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Mr Excel & excelisfun Trick 40: VLOOKUP to 3 Different Lookup Tables (3 table_arrays)
by
ExcelIsFun
on
Youtube
Duration:
0.15 hours
See Mr Excel and excelisfun show how to do a VLOOKUP to 3 different tables using these tricks: 1)INDIRECT and CHOOSE 2)CHOOSE alone 3)INDIRECT with ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Mr Excel & excelisfun Trick 42: Lookup Picture In Excel Formula or VBA?
by
ExcelIsFun
on
Youtube
Duration:
0.18 hours
See Mr Excel and excelisfun lookup a picture in Excel. See a VBA solution and a Formula Solution using the INDIRECT function and named ranges. See many ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 476: SUMPRODUCT Function for Weighted Average Cost From Transaction Data
by
ExcelIsFun
on
Youtube
Duration:
0.08 hours
Calculate Weighted Average Cost from a transactional data set using SUMPRODUCT function. If you have a huge database Excel Table / List of Purchase ...
