1259 free courses & lectures available for Excel

Excel Magic Trick #188: Page Setup Across Multiple Sheets

by ExcelIsFun on Youtube Youtube
Duration: 0.11 hours
Page Set Up Across Multiple Sheets Or To Another Workbook. Headers and Footers. Highlight all the sheets you want to add Page Setup to and then add 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 185 Dynamic Formula Extract Data 1criteria

by ExcelIsFun on Youtube Youtube
Duration: 0.17 hours
Create a formula to extract part of a table from a larger table. Similar to a query in Access, but with a array formula in Excel that uses the functions: INDIRECT, IF, ...
  
Details:
No Captions

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

Excel Magic Trick #190: Rearrange First Last Name w Formula

by ExcelIsFun on Youtube Youtube
Duration: 0.07 hours
See how to rearrange three parts in a text string (Last, First, Middle name) using the RIGHT, FIND, LEN, & LEFT functions in one formula.
  
Details:
No Captions

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

Excel Magic Trick #193: Grade Book Based on Total Score

by ExcelIsFun on Youtube Youtube
Duration: 0.08 hours
Use the SUM and VLOOKUP functions to create a Grade Book Based on Total Score that will calculate grade for you automatically. VLOOKUP function ...
  
Details:
No Captions

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

Excel Magic Trick #194: Grade Book Based on Percentages

by ExcelIsFun on Youtube Youtube
Duration: 0.17 hours
Use the SUM, VLOOKUP and ROUND functions to create a Grade Book Based on Percentage Scores that will calculate grade for you automatically. See how ...
  
Details:
No Captions

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

Excel Magic Trick #195: Grade Book That Subtracts Lowest Score

by ExcelIsFun on Youtube Youtube
Duration: 0.08 hours
Use the SUM, MIN and VLOOKUP functions to create a Grade Book Based on Total Score minus the lowest score (lowest score removed) that will calculate ...
  
Details:
No Captions

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

Excel Magic Trick #196: Grade Book That Subtracts Two Lowest

by ExcelIsFun on Youtube Youtube
Duration: 0.13 hours
Use the SUM, SMALL and VLOOKUP functions to create a Grade Book Based on Total Score minus the two lowest score (two lowest score removed) that will ...
  
Details:
No Captions

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

Excel Magic Trick #199: Histogram w Conditional Formatting

by ExcelIsFun on Youtube Youtube
Duration: 0.04 hours
See how to use the New Excel 2007 Conditional Formatting for a Vertical Histogram based on a frequency distribution.
  
Details:
No Captions

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

Excel Magic Trick #198: 3 Formulas For Frequency Distribution

by ExcelIsFun on Youtube Youtube
Duration: 0.11 hours
Excelisfun is conducting a FAVORITE FORMULA SURVEY! Watch the 3 different Formulas in this video and then vote in the comment section for the one you like ...
  
Details:
No Captions

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

Excel Magic Trick #202: Calculate Vacation Days

by ExcelIsFun on Youtube Youtube
Duration: 0.07 hours
Create a formula that calculates the number of vacation days an employee gets based on hire date using the functions TODAY, YEAR and IF functions.
  
Details:
No Captions

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