How to combine vlookup and average Videos

• 1. Create Excel Charts and Graphs
• 2. A 30 minute Excel learners guide to essential formulas, procedures and tips
• 3. Combining Sumproduct and VLookup function in Excel
• 4. Excel 2010 Tutorial 6 - Worksheet Function Example - Sum Average Median Maximum Minimum
• 5. Excel 2010 Class, Week 1: Part 2 of 3 (Excel Basics)
• 6. Conditional Formatting Excel 2007
• 7. Excel Magic Trick # 3: AVERAGE & Go To Blanks
• 8. Tutorial Excel 2007 - Aplicatie care combina functiile if, sum, min, max, average

Create Excel Charts and Graphs

A 30 minute Excel learners guide to essential formulas, procedures and tips

User Comments

Gopala Krishna commented on 01 Nov 2015

Thanks for explaining in a simple language. Good and Great work indeed. I thank on behalf of all my Xl Lovers/addicts/user to you and request to upload some more very useful and time saving tricks/tools. Is there any formula which converts automatically the number say for eg. If the sum result is 10 i.e. 5+5, then in words it should reflect as Ten. Please explain and show with an example.

Gopala Krishna commented on 02 Nov 2015

Sir, Thanks for the immediate response. I want the code. Please send it. I will try to enter the code and get result. I respect your scholarly knowledge. Please share so that it is very useful who are having passionate to learn Excel.

United Computers commented on 01 Nov 2015

+Gopala Krishna You can convert numbers to English text, but ONLY with a VERY long code of Visual Basic. I can send you the code if you want.

Combining Sumproduct and VLookup function in Excel

Excel 2010 Tutorial 6 - Worksheet Function Example - Sum Average Median Maximum Minimum

User Comments

Nagesh Patane commented on 27 Jul 2013

Your style of teaching is very clear cut & to the point. There are no unnecessary things & wastage of time on silly points. Yet it is very effective even for computer novices. The sound is also very good. Thank You.

Richiiiieeee commented on 03 Oct 2012

For whatever reason, I can't get the cell to show the answer, only the formula. Did step by step exactly what you have done on this video. Not sure what I need to do.

zhe wei commented on 12 Aug 2013

you could have had the data all typed out first instead of typing it out for us to see. quite a waste of time . but your instructions are clear. thanks

TheCrustyJuggler69 commented on 07 Sep 2013

i think its good that he started from scratch because you dont start a new spreadsheet with everything you want on it

Christopher Wolfe commented on 12 Feb 2012

Very informative and helped on my college assignment, thanks!

micelamicela commented on 24 Apr 2012

Thank you for your time! Excellent lessons!

ahmed butt commented on 24 Oct 2012

very helpful for me thanks

Ada B commented on 12 Nov 2012

Thanks SO much!!

Excel 2010 Class, Week 1: Part 2 of 3 (Excel Basics)

Conditional Formatting Excel 2007

Excel Magic Trick # 3: AVERAGE & Go To Blanks

User Comments

Aamer Ali commented on 25 Jul 2015

what if Ctrl + Enter is not working?

Aamer Ali commented on 25 Jul 2015

+Aamer Ali  it is working thanks a lot. after you inter the close parentheses, click on Ctrl + Enter

zamfir octav commented on 26 Jan 2015

OK, it's time to learn how to work efficient an excel. I'll check all your videos. 

ExcelIsFun commented on 26 Jan 2015

Do the Basic Series or the Highline Excel Class for a beginning to end approach:https://www.youtube.com/playlist?list=PL3FBEE51974F03CCForhttps://www.youtube.com/playlist?list=PLrRPvpgDmw0nh4BBxqjcsnbB4ME4JjzfJ

Tutorial Excel 2007 - Aplicatie care combina functiile if, sum, min, max, average