Excel Magic Trick 628: VLOOKUP Data Validation IF Function Date Math Total After Discount Template

Great Excel Basics to Intermediate Video:
1. VLOOKUP to look up a price for a student course -- using Exact Match
2. VLOOKUP to look up a discount rate for days paid early -- Using Approximate Match
3. Date Math Formula to figure out the number of days the fee was paid early
4. IF function to hide a formula when it delivers an error in a template.
5. Formula for discount for paying early
6. Formula for total amount due after discount

Category:

Science & Technology

Tags:

• Excel
• 2007
• 2010
• VLOOKUP
• Exact
• Approximate
• Match
• IF
• Functions
• Discount
• Rate
• Percentage
• Price
• Formula
• For
• Days
• Paid
• Early
• Date
• Math
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College
• Basics
• Intermediate
• Data
• Validation
• List
• function
• to
• hide
• formulas

[1002vicky]

Hello Mr. Excel,

I wanted to know if you can create a pivot table in a new workbook an pull the data from from other source.

Means - Data in workbook1 and pivot in workbook2.

[ExcelIsFun]

Yes, in Excel 2007 / 2010 start in the workbook that you want the PivotTable to be in, then in step one click the dialog button that says "use external data source". In 2003 the dialog button says "External data source".

--excelisfun (not Mr Excel)

[DavidCIC11]

Hi Mike, seen a few of your YT vids - have to say, awesome stuff, really, really engaging. I'm having a few problems with something I'm trying to develop, which I guess would be pretty simple for you - would you have the time to answer a few questions? Thanks in advance

[ExcelIsFun]

I do not do consulting. Try THE best Excel question site:

mrexcel[dot]com/forum

[Noumenon72]

Oh man, I not only learned the trick I was looking for, but I also learned about F4, formatting percentage and decimal with the Home ribbon... it's the sub-tricks of day-to-day formula entry that make these videos so great for the Excel novice.

[ExcelIsFun]

I am glad that the video helps! That is why I put them out there!

[peeweecee]

You are amazing, but you go so fast. I'm really impressed, I thought I knew excel well until I watched you. Thanks for teaching me so much!

[ExcelIsFun]

You are welcome!!

[krn14242]

Review because I have been watching your videos and learning a great deal from them. Thank-you for all the great work. I pass your channel along to whomever is in need of Excel help.