Tutorial - Excel 2010 - 10 More Things you must know

[@connierivera7018]

Great teacher! Love the videos. ...simple, easy to understand language, and examples are excellent!

[@noturaverageplayr]

Believe it or not I've been using Excel for 10+years in engineering and have learned things from both of your Excel videos. Thanks so much for taking the time to make these

[@kaulillian]

You are a blessing. Your tutorials are excellent and easy to understand.

[@christinekirk3288]

Thank you so much for these excel tutorials. You make things so much easier to understand!!!

[@EarthtoRosita]

this is just so beautiful. I've learnt so much in just less than an hour. Pleas make more!!!

[@carlorodrigues2]

Your videos are ALWAYS good and a pleasure learning new things.

[@sonuchacko]

Thanks for the videos, they were really helpful. Thought to mention a point here. From the list of topics you covered 5. Capitalise EVERY letter of the WORD in excel can be done using =upper() formula. where as 6. Capitalise only FIRST letter of the WORD can be done using = proper() formula

[@mardi8195]

Thank you Ilan!
You are a good teacher. Im re-familiarizing myself with Excel and yur videos are so helpful-and fun to watch.

[@dennislambert7776]

I'm trying to learn Excel, and your videos are so helpful!!!
Thank You Sir for taking time to do them.
God Bless You

[@love_zee]

Your videos are very helpful! Thanks! I look forward to a third installment.

[@diazericam86]

Thank you for your tutorials. They have been very helpful

[@losdog13]

you're a good man. I'll check in with you to let you know how much this has helped me.Thanks for the time

[@wentinggao3064]

love ur voice and ur way of explaining stuff! thx man!

[@vougeot]

Thank you again, Ilan, very helpful!

[@marimayn716]

This tutorial is amazing! Thank you!

[@milethdilig9332]

hi i want to know if this also works in excel 2007. i tried to get the sum of two cells from different sheets and my answer is zero. i did the correct formula don't know why i get the answer zero.. please reply.. thank you..

[@sandylaurence2726]

THANK YOU!!!! I hope this isn't a redundant question. I coach track and need to format for cumulative time rather than clock time. I've tried all the different number formats, but can't quite find the perfect fit. Can you help?

[@debbiesolo]

Thanks Iian I love your tutorials

[@50hawaiikai]

To: ILan Patao
I am totally new to Excel. I want to use it load up Google Keywords in a list in descending order of Average Monthly Volume.
Do you have a video that covers that?
Please advise .
Thanks
Dick

[@harisrahim7522]

Thx
and here's my question which is what if I wanted to do more than 2 IF functions like 3 or more logics?
thx again

[@NJDevils21]

=randbetween(0,100) will do whole numbers that you specifiy, in my example 0 -100 and =rand() will be a random number * your value, so it will include decimal vaules

[@connierivera7018]

Looking forward to more videos!! :)

[@johndotes]

More things! :D Thank you in advance, I'm still watching it :)

[@heathertreadway9733]

This is awesome, thank you!

[@evelynagbasonu3096]

Awesome tutorial!!!!

[@austendepp1]

another awesome tutuorial :)

[@islandmantraveler]

In regards to the RANDOM function where you were trying to copy and paste then REMOVE the DUPLICATES, but because they were not whole numbers you were having an issue. (I'm sure you just didn't have the time to go into detail on how to solve this). But some people, watching your video, might wonder how they can actually do this.
All you need to do is go to the B column, and in cell B1 use the formula =ROUND(A1,0) then drag that formula down. That will give you the whole numbers (numbers without fractions) for all the numbers in the A column, within the B Column.. Then you can copy and paste the B Column over to the C Column (make sure to only Paste Values). Then you can use the Remove Duplicates function in the C Column.
There might even be an easier way than this, but it's very quick this way.
By the way, I love your video. You explain everything in a very simple way, which is great for beginners.

[@Cjstone99]

Good video but what about count if formulas I am suck on them

[@JDK45ACP]

Very Nice! Thank you, Sir.

[@bradblack4]

I'm not so sure #5 and #6 are the same question. Is there a way to capitalize entire words (after they have already been typed in lower case)? Are you able to capitalize all of the letters in a cell, column, or row after they were written in lower case?

[@ralph9763]

How do I get to Find and Replace if I have no F1 key?

[@alfredtan952]

Press Ctrl + F

[@00tensonam]

Thank you very good stuff!!!

[@musicforfun994]

how to change name of A to onother

[@2130lena]

Thanks a lot - very cool.. One question though: what is an ! means?? (anyone, pls:-) When do you use it?
Many thanks

[@wavelee4335]

! means sheet.

[@sim-8200]

Thank you!

[@alexalexandru2745]

Why some formula,dosen't work ?!?! I put the exact formula,but it dosen't work,and i don't know why...

[@MutumboGeorge]

good video. 5 and 6 arnt the same though they say different things

[@snyderb7]

Thank You very much, sir !.........

[@maryamaroo915]

thank you so much!!

[@nkhader]

thank you

[@awordisnotenough]

low resolution !!! but thank you very much

[@pavolvranka5879]

thank you IIan

[@natalyg2132]

It's blurry

[@RandomGuy7815]

yeah dat der deep web

[@padmabharti3100]

Good afternoon everyone
Aryans international school Moradabad