Tutorial - Excel 2010 - 10 More Things you must know

[@connierivera7018]

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

[@kaulillian]

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

[@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

[@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

[@christinekirk3288]

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

[@carlorodrigues2]

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

[@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.

[@EarthtoRosita]

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

[@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!

[@marimayn716]

This tutorial is amazing! Thank you!

[@vougeot]

Thank you again, Ilan, very helpful!

[@debbiesolo]

Thanks Iian I love your tutorials

[@johndotes]

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

[@connierivera7018]

Looking forward to more videos!! :)

[@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

[@heathertreadway9733]

This is awesome, thank you!

[@austendepp1]

another awesome tutuorial :)

[@evelynagbasonu3096]

Awesome tutorial!!!!

[@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.

[@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?

[@JDK45ACP]

Very Nice! Thank you, Sir.

[@00tensonam]

Thank you very good stuff!!!

[@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

[@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..

[@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

[@snyderb7]

Thank You very much, 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?

[@sim-8200]

Thank you!

[@Cjstone99]

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

[@maryamaroo915]

thank you so much!!

[@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.

[@MutumboGeorge]

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

[@musicforfun994]

how to change name of A to onother

[@ralph9763]

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

[@alfredtan952]

Press Ctrl + F

[@awordisnotenough]

low resolution !!! but thank you very much

[@alexalexandru2745]

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

[@nkhader]

thank you

[@pavolvranka5879]

thank you IIan

[@natalyg2132]

It's blurry

[@RandomGuy7815]

yeah dat der deep web

[@padmabharti3100]

Good afternoon everyone Aryans international school Moradabad