1259 free courses & lectures available for Excel

Excel Magic Trick 297.5: Conditional Sum for Varying Columns

by ExcelIsFun on Youtube Youtube
Duration: 0.12 hours
Learn with formula is best from amongst five different formulas for conditionally summing from varying columns: 1.OFFSET formula 2.INDIRECT formula 3.
  
Details:
No Captions

About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...

Excel Magic Trick 297: Add Certain Column Only

by ExcelIsFun on Youtube Youtube
Duration: 0.15 hours
See how to select varying columns for summing adding with: 1.OFFSET function 2.INDIRECT function 3.INDEX function We will see that the INDEX method with ...
  
Details:
No Captions

About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...

Excel Magic Trick 296: Conditional Format Intersection Row & Column

by ExcelIsFun on Youtube Youtube
Duration: 0.1 hours
See how to add Conditional Formatting to a row, a column and the intersection of the two with three different colors. See three TRUE FALSE formulas for ...
  
Details:
No Captions

About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...

Mr Excel & excelisfun Trick #3: Wildcard Count

by ExcelIsFun on Youtube Youtube
Duration: 0.1 hours
See Mr Excel and excelisfun demonstrate three methods to count words that contain the letter D: 1) Filter & SUBTOTAL 2) Table & SUBTOTAL 3) COUNTIF and ...
  
Details:
No Captions

About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...

Highline Excel Class 10: VLOOKUP SUMIF & Percentage Increase

by ExcelIsFun on Youtube Youtube
Duration: 0.19 hours
Download Excel file: http://people.highline.edu/mgirvin/excelisfun.htm See how to create projections for sales numbers from a database using the SUMIF, ...
  
Details:
No Captions

About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...

Highline Excel Class 09: SUMIF Function Formula 3 Examples

by ExcelIsFun on Youtube Youtube
Duration: 0.16 hours
Download Excel file: http://people.highline.edu/mgirvin/excelisfun.htm See three examples for SUMIF function: 1)SUMIF where you want to add only a certain ...
  
Details:
No Captions

About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...

Highline Excel Class 07: VLOOKUP function formula 7 Examples

by ExcelIsFun on Youtube Youtube
Duration: 0.41 hours
Download Excel file: http://people.highline.edu/mgirvin/excelisfun.htm Learn about: 1)VLOOKUP to lookup an exact match 2)VLOOKUP to lookup an ...
  
Details:
No Captions

About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...

Mr Excel & excelisfun Trick #4: Comparative Charts

by ExcelIsFun on Youtube Youtube
Duration: 0.14 hours
See Mr Excel and excelisfun create charts to compare data values: 1) Bar Chart 2) Stacked Column Chart 3) Trendline to predict future data values MrExcel's ...
  
Details:
No Captions

About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...

Excel Busn Math 37: Bank Reconciliation

by ExcelIsFun on Youtube Youtube
Duration: 0.27 hours
Learn about Bank Reconciliation.
  
Details:
No Captions

About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...

Excel Magic Trick 304: Charts: Add Secondary Axis To Frequency Column Chart

by ExcelIsFun on Youtube Youtube
Duration: 0.05 hours
See how to Add a secondary axis to a chart so that you have axes on the left and right. See how to add axis labels to the left and right and how to link the label to ...
  
Details:
No Captions

About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...