1259 free courses & lectures available for Excel

Excel Magic Trick # 268: Conditional Formatting Max In Row

by ExcelIsFun on Youtube Youtube
Duration: 0.05 hours
See how to apply a conditional format that will highlight the maximum value in a row using a True False Formula. See the MAX function used with Conditional ...
  
Details:
No Captions

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

How To Post Questions At The Mr Excel Message Board

by ExcelIsFun on Youtube Youtube
Duration: 0.06 hours
The smartest Excel People In The World? Some of them hang out at the Mr Excel Message Board. See how to post questions so you can get answers from THE ...
  
Details:
No Captions

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

Excel Magic Trick # 278: Return Every 10th Value w Formula

by ExcelIsFun on Youtube Youtube
Duration: 0.08 hours
Use INDEX and ROWS functions in formula to Return Every 10th Value w Formula and place them in a column. Aladin at the Mr Excel Message Board gave us ...
  
Details:
No Captions

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

Excel Magic Trick # 283: Lookup Vendor Name With Low Bid

by ExcelIsFun on Youtube Youtube
Duration: 0.05 hours
See how to use the INDEX, MATCH and MIN functions to retrieve vendors name when they have made the low bid. Lookup Vendor Name associated 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 276 MoreFunc Excel add-in 66 New functions

by ExcelIsFun on Youtube Youtube
Duration: 0.11 hours
See how to download and install MoreFunc. See new functions like: EVAL evaluates a text string FILENAME gives workbook name FILENAME gives file path ...
  
Details:
No Captions

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

Excel Magic Trick # 272: Count Unique Or Duplicate Records

by ExcelIsFun on Youtube Youtube
Duration: 0.16 hours
See how to Count unique records and Duplicate records using the SUMPRODUCT, COUNTIF, COUNT, COUNTA, IF and SUM functions. See seven (6) different ...
  
Details:
No Captions

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

Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup

by ExcelIsFun on Youtube Youtube
Duration: 0.11 hours
See Mr Excel and excelisfun demonstrate two methods to do a two way lookup on a table array: Mr Excel: MATCH and INDEX functions in one formula to retrieve ...
  
Details:
No Captions

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

Excel Busn Math 32: Markup & Markdown Math Problems

by ExcelIsFun on Youtube Youtube
Duration: 0.2 hours
See how to solve Markup & Markdown Business Math Problems. Excel math formulas. Rate, Rate Of Change, Percentage Of Change, Increase, Decrease, ...
  
Details:
No Captions

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

Excel Busn Math 29: Rate Of Change Formulas

by ExcelIsFun on Youtube Youtube
Duration: 0.28 hours
See how to solve for Rate, Amount Of Change and Rate Of Change. Excel math formulas. Rate, Rate Of Change, Percentage Of Change, Increase, Decrease, ...
  
Details:
No Captions

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

Excel Magic Trick 295: DV Dropdown From Diff Workbook

by ExcelIsFun on Youtube Youtube
Duration: 0.18 hours
See how to create a data validation dropdown list in 1st workbook when source list is in 2nd workbook. See the IF function with workbook cell references.
  
Details:
No Captions

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