Beginner's Guide to Excel Functions and Formulas

[@pearl6837]

I just want to thank you for providing practical steps for learning Excel. I paid for courses and couldn’t understand. I learned and understood four of videos in less than 2 hrs. Much gratitude. Great intuitive teacher!

[@pearl6837]

I’m developing dashboards in 2 hrs. I barely knew how to use Sum function- Such a useful tool. The formatting and other fxs were well instructed . I have subscribed and will land on your page for all my computer needs. Do you have formatting videos for Word and other 365 products?

[@reneejaramillo6222]

For years I had major anxiety over using Excel. Thanks to your method of teaching, I have lost my fear and have learned so much from your videos. Thank you!

[@cindychristensen944]

I've gone through the W, O and PP playlists. Now working my way through E. I am SO grateful I found these. Your tutorials are by far the most clear and easy to follow on KZbin. I would suggest changing your account name from Tech for Teachers and Students to something more broad, because these are helpful for anybody. I'm not a student or teacher, and I'm learning for office work. I think maybe people who would benefit from your videos might not find them, because seeing the name of your channel they'd think it wouldn't apply to them. I'm seeking employment now, but once I have an income I'll surely donate to your Patreon. I paid a lot of money for an online course that was not nearly as helpful. Your channel is of great value and I hope many more people find it.

[@emadali4833]

As usual the best one who makes anything simple , cheer

[@juliegoncalves6827]

What an amazing tutorial!!! I have adhd and usually have to rewind these a million times then give up… I wish school was taught like this …thank you

[@brianwilson9800]

Marvellously presented,thank you

[@wazmink2459]

I learned by the way you explained, words that comes from your mouth is very clear, unlike others youtuber that teaches Excel. Their words are not Clear. Yours are easy to understand. Feature more about excel. God bless you

[@DK-kk3bt]

Your videos are clear and easy to follow. Thank you!

[@bashorunbunmi6807]

If possible to like ur videos a zillion times, I will definitely do so. Thanks for making ms office easy to understand. 👌👌👌👍👍

[@Maguraj1]

You make data inputting fun & even existing. Thank you

[@EduFocusConnect]

Oh wow! I love this. I just started a youtube channel for teachers and will most defs refer my peeps here. Respect to all teachers at this time!❤💯

[@steveruisi9435]

Very useful, as always. Thanks.

[@gaillastof837]

Thank you so much. I find that I'm depending on a lot of primary lessons that I studied at school to run my household expenses lately. (This was a great reminder).

[@wenbintan2676]

Love all ur videos. Very detailed

[@tlk2348]

You are an amazing teacher. I am actually enjoying learning this! Thank you!

[@sherris.2402]

Thanks!

[@techteachersandstudents]

Sherri, thank you for your kind gift! I'm glad you found my video to be helpful.

[@sherris.2402]

I found it tremendously helpful in trying to learn basic excel to keep track of invoices for a garden club annual meeting. Your teaching style is the best! Good pace and clear instructions.....thank you so much.

[@mercedesa.3885]

Very useful, thank you!

[@ndelpurg]

great videos simple to the point - many thanks

[@777VIBRANT]

Thank you for making this tutorial

[@doloresmundee7783]

please do another excel functions video on sum average, max , min etc this was great but I would like to know more about this

[@nsobundulawretta8319]

Where have I been? Am your new student, thanks for all your teachings.

[@Angela_1106]

I love ❤️ you so much!!!!! Thank you so much!!!!

[@maemaumeow]

Great content! I am also creating MS Excel tutorials. MS Excel is such a powerful tool that almost 90% of businesses nowadays use. Happy Excel - ing😉😉😉

[@wayneintila8433]

Thank you so much sir

[@s.m.alamin1328]

Ctrl+down arrow to go all the down of the row or columns. =sum(range)

[@salmaalaa6158]

very good thank you

[@nathanieldolan5544]

It would be highly useful to see a tutorial on calculating discounts by percentage in Excel. You are the best instructor I've encountered for Excel. However, I scored only a barely passing grade at 70% on an Excel eval today for a prospective employer. They claimed that it was going to cover only basic features. I studied your vids up through Advanced; however, I encountered questions not represented in your vids and we're CLEARLY advanced. Just thought I'd put in my two cents.

[@nadyarashid]

Hello, may you please do an automated duty roster video. I like how you explain and zoom in. I haven't found any video on how to make an "automated duty roaster" that explains it like you. Hopefully you find this comment. Thank you in advance. Stay blessed.

[@zaksav]

Looking forward to the intermediate guide n advanced guide

[@firstnamesecondname5341]

👍 helpful for sure 😁

[@kamarasiakarifa6359]

Thanks very much for the presentation, please I would like to ask a question.the 1701 is the total number for the profit or from and other columns?

[@SediMashinini]

Soooo helpful!

[@mettepetersen3280]

Thank you

[@tomrocks6442]

I’m hooked , excel is about to go from my Achilles heel to my strength .. question i was making a sum and all the numbers went to 2 decimal places ( no decimals before ) how do I change this to who,e numbers please ,, keep up the good work ✅

[@ysf5152]

Pleas do an intermediate tutorial because you do tutorials for these functions and formulas but thanks for your effort

[@paulvanobberghen]

If you would have made this an Excel table, you wouldn’t have to freeze the pane to keep first line in sight. Then, the header line would occupy the column headers (A, B, C, D,...) when scrolling down. One of the many wonders of using Excel tables. Also MIN, MAX, AVERAGE are also directly available as sub item of the Sigma button you clicked for SUM.

[@hoochone3225]

....any chance of a tut. on vlookup please

[@ron6837]

How do you email a spreadsheet?

[@ultimatebeast1941]

I like it

[@denniskarl5252]

Wow that is... pretty big

[@dallast21]

I've been using Excel for well over 20 years. I item I've never been able to solve. My default font color is Red. I change it to black, and the next time I open Excel, it is Red again. Advice please.

[@borissh1453]

Hello, if you could help me out with this. I am trying to make a formula, i am a begginer. So what i need is for exampl: I have 2 coloms 1: Apple,Orange,Carrot 2: XX,XXXX,XXXXX. I would like it to be : If you choose apple then it must be 2-XX, if choose carrot it must be XXXX-4xs.

[@maemaumeow]

=IF(R1C1="Apple", "XX", IF(R1C1="Carrot", "XXXX", "XXX")) R1C1 is the cell reference you want to evaluate, If it is True, meaning if R1C1 value is "Apple" then Apple = Apple, is TRUE, it will return the value XX, if not then it will move on to the next IF condition, is R1C1 equal to Carrot? If Yes, then it will return XXXX, but if it is false, it will return XXX. Enter the formula above in Column 2, the result should be like the one below COLUMN 1 COLUMN 2 Apple XX Orange XXX Carrot XXXX

[@excelmarketingdigitalandot1425]

Yh, very good i liked

[@IbraheemTaiwo]

Yes o

[@gurleengupta5367]

This is Ishaan guys like my comment lol hahahahahaha Ishaan in ur classy bro like it lol hahahahahah

[@gurleengupta5367]

Never gonna give u up Never gonna let u down Never gonna turn around and leave u Nevr gonna make u cry never gonna say goodbye woooooaaaaaaaa

[@kittych0w]

I need a little more time at the end of your videos to click like, it often goes to the commercial before I can do that.

[@mo8282]

I usually hate Execl too much, but I am sure no more.