How to use Microsoft Excel - Beginner to Intermediate Class (with sample files)

[@MrAloha]

Chandoo rocks! I know because I teach Excel Basics and I learned a lot from him! Thanks, Chandoo! 💪😁🌴🤙

[@mariasansanna3937]

Sir I have a huge problem to sit and listen to videos. But your pacing, your voice, the way you teach and everything has kept me focused. Thank you for the video. ❤

[@mercyrn35]

I have never seen a better ,more clear tutorial for Excel. Thank you for sharing your knowledge.

[@chandoo_]

You are welcome!

[@girijavarma5271]

This is the best source to learn Excel. pls, continue this series. I have recently started watching your videos sir.

[@chandoo_]

Thank you.

[@jBartolo]

You are a gifted instructor, everything from your demeanor, your voice, your presentation, etc, is just so easy to follow and understand. Please continue the excel course, I learned more in 32 minutes than I have in the previous 10 videos I tried from other content creators. You rock…. Thank you Sir. MORE PLEASE….

[@chandoo_]

Wow, thank you!

[@ericaoforka8964]

This video is 2yrs ago and it’s the BEST that has taught me so far! Thank you Chandoo🤗

[@danieloghenebrorhie2590]

Thank you Chandoo, You are the best Excel teacher I have listened to. I am almost addicted to your Excel videos now. Thank you

[@chandoo_]

Thank you Daniel 😀

[@shriidharkulkarni6648]

I have not come across better teacher than you for teaching Excel skills. I am grateful to you Sir,

[@SVSingam273]

@Chandoo. Please continue this series. I hope you begin to cover more advanced aspects of EXCEL. This can include a more beginner to advanced tutorial using Power Pivot and also using EXCEL to compute Simple and Multiple Linear Regression.

[@itzmesunita]

Best excel class ever.. I just finished my crash course and really excited to finish all the videos from beginner to advance... Thank you so much for this

[@sarwathashmi3697]

hi, did you purchase the full course?

[@anishhamal9927]

This is the best Excel Beginners Video I have ever watched.

[@bmcmails]

Please share the answers to your questions...This is the best tutorial I have ever gone thru..so please continue with the series !!

[@nautiyaladarsh]

"Just watched the very first video on your channel, and I absolutely loved it! I'm excited to see more!"

[@pjaviation9268]

By far , the Best place to Learn Excel...Thank you for sharing this knowledge. Blessings 🙏

[@wayneedmondson1065]

Thanks Chandoo! Never hurts to review the basics. Always something new to learn :)) Thumbs up!!

[@chandoo_]

YES!!!

[@sindimahlangu5457]

I am battling to solve the quartile, I even tried using the quartile formula. Overall, I am really impressed with this course. Very helpful in my work environment.

[@classicemmaeasy2292]

Use excel percentile

[@DEBRASUSSMAN]

Thank you! I am 51 years old and I just got a job that requires me to use excel. This video totally got me started!

[@chandoo_]

You got this!

[@minakshilute8515]

Your teaching is completely excellent . Thank you

[@offbeatnever9611]

Thank you, Sir. This is going to make me dangerously more capable with my current evidence collecting, paternal tracking, and many other things to be managed.

[@chandoo_]

Excellent!

[@canirmalchoudhary8173]

Very helpful...I always recommend your channel to every excel learner.

[@chandoo_]

Thanks Nirmal for the love and support. :)

[@umepervaiz1488]

Hi Chandoo! I am new subscriber and already in love with your teachings method! Now,I feel that I am I right direction! Stay blessed!

[@cricketcrazy143]

One of the best channel in KZbin for Msexcel Tq sir

[@chandoo_]

Thank you Sairam 😀

[@shahtajp4379]

You are really superb, highest teaching skills.So crystal clear concepts. Learning from basics to advance with ease.

[@savesoil8549]

tysm .....i already recommended to my circle ....they r glad i did.....its so true there are no students only bad teachers 😅😅😅😅😅😅😅

[@rkkk3941]

Dear Sir .....well explained looking forward to completing it, thanks for making it so simple ...

[@tolulopesubair2597]

This is outstandingly beautiful. Thank you for taking your time to do this🙏

[@rahulrdj]

i am attend your screen first time, i am happy to attend this it is put more knowledge for me

[@natureisbest7632]

Thanks a lot sir, it really helps !

[@ifejayeola8497]

Wow, this is actually fantastic. I have learned a lot today. Thank you Chandoo

[@tomjun8945]

Excellent video like always. Thank you!!

[@chandoo_]

Thanks again!

[@devildj3311]

I loved the video, the way you delivered and made it. Just nailed it. So far you are the best teacher i found.❤

[@hasanmehdi7219]

You have explained in a very good way

[@sholariamah7682]

This was really really helpful. The sub-total button didn't work until I converted table to range and I used it to get the amount and boxes. The sort button worked fine

[@mrinaliniraj5391]

For q1 I used Sumif function Sumif(,,) .... Then drag this Q2. To do double sorting select entire dataset click on advance filter and then apply sorting on diff levels ) Q3.amount /boxes and drag the formula. Is my approach right for the h.w?

[@onepunchman00]

Thank you Chandoo I found a new inspiration to learn things by myself 🤗.

[@sadafanwer8531]

you have a very clear way of explanation I really like

[@aparimitapati4322]

Thank you so much Chandoo for this very useful session! It's really helpful, I'm going to watch and learn from your other videos! God bless you abundantly!

[@rahmatullaziyae7836]

Please arrange your excel playlist from beginners to advance level one by one Iam confused which i should see first But your teaching method is beautiful

[@chandoo_]

Hi Rahmatulla.. you can create such a playlist. I won't be doing it as I am not creating them in a sequence. Alternatively, you can join the Excel School program if you want to learn things in one place without distractions. Visit chandoo.org/wp/excel-school-program/

[@libanwarsame9291]

@@chandoo_ I have a problem in joining the class. It says the safari can't open the page. I really want to join your class man.

[@7dx549]

Definitely I will recommend this to my friends. Thank you sir .

[@jagatkrishna1543]

🙏 Thanks Sir God Bless You and Madam. Kindly make outdoor You n Madam videos on real-time project with important topic or concept , we all waiting to see both of you once again.

[@chandoo_]

You are welcome Jagat. Thanks for your love and appreciation.

[@kapilshinde8672]

Very informative sessions helps a lot to understand, keeps us focussed throughout the sessions Thank you sir😊😊

[@obagusunday701]

Dear chandooo I have solved the homework, alsome video, Solve number 1 using pivot table, Puting the dates in rolls and amounts and boxes in the calculate session using sum 2. I used the sorting dialogue box to add two levels of sorting 3. I added a new column and calculated the amount per box by dividing the total amount by the number of boxes. I hope am correct

[@abinaya9538]

Woah...i owe you my excel skills bro! The way you explained and the presentation is just so good and clear!! Very helpful

[@ratikamundewadi3487]

Thank you so much Sir your video is very helpfull for me. I want to be freelancing and there is too much data entry work. I learnt excel sheet for your videos

[@SVSingam273]

@Chandoo. Love your videos. Also a complete tutorial from Beginner to Advanced on how to prepare EXCEL Dashboards would be much appreciated. Your videos have helped me so much in learning to love and master EXCEL.

[@chandoo_]

Thanks Sasitheran. I have recently done a masterclass on KPI dashboards. See it here (2+ hours) - kzbin.info/www/bejne/oYaWhJeKbciiq80 You can also join my online class for complete Excel training. Visit chandoo.org/wp/excel-school-program/ for that.

[@SVSingam273]

@Chandoo. There is a comment that copies my initial comment on your videos. Something sexual. I reported it but it appears to be still in the comments section. Just letting you know, that I didn’t write that comment😀

[@durlavdas9107]

Sir ,I have watched your maximum videos . Here I request you . Please make video on "hands on peoject " how to use SQL and BI Tools.

[@ebierealexandria]

Thanks Chandoo, This is the best channel ever.

[@nomanjaved3560]

Awesome it has been great learning for all of us.

[@sathyaspace]

Chandoo You are the best man... the way you expound the concepts,seriously very clear and meticulous ....lots of love to you ...please keep up the great work. And a small request from my side can you please upload Business analyst course playlist that will be of great help to me Cheers:) Best wishes -Sathya💙

[@saymaakhterjafrin7007]

Thank you!

[@CricketLivejavwad]

Hi thank you for the video sir, For homework questions I tried a pivot table to solve the first question Is it the correct approach? Q.1 calculate totals by each date - for amount and box columns

[@mulikinatisiddarthasiddu8245]

Instead use sumif

[@abhilashparmar8431]

Hi Chandoo, I am in love with the Tutorials, the way you simplify the formulas is amazing. Do you have any Discord where we can post our doubts?

[@sairamadaboina8257]

Thank you sir you're explanation was very nice, please upload more and more videos with tips and tricks.

[@TheTravelDiaries486]

Hi Chandoo dear many thanks i was thinking what is microsoft excel today i am learning from yours video really appriciated Waheed UK

[@आम्हीअभ्यासू]

Thanks a million 😊 I have learnt a lot from this video, and looking forward to learn more and become Pro in Excel. 🤘 I have completed 2 homeworks, 1)Total of amounts and boxes by date. [ Pivot Table] 2) Amount per box. [ =([Amount]/[Boxes sold])] But not able to do the 3rd, i.e. Sort by date and amount. As, the dates and amounts are different, they can't be sorted at a time. Didn't find any option to do it. Please help me with this !

[@kavyayarra808]

In the ribbon, go to sort&filter->Custom sort, thereby adding a level you can do sorting to different columns

[@LetsEat93]

Homework 1: used Sumif() function homework 2 : Sort option inside Data, selected multiple column to sort homework 3: =amount/boxes sold

[@ismailbenz2193]

i have gone sparatly through each day by sum function (the hard way hahaha) i used sumif after reading your comment it is better and practical

[@mulikinatisiddarthasiddu8245]

After sumif what to type?

[@AhmadSoomro-je8cd]

Great bro, thanks for teaching, it's very useful for the employees who are working in an organization or in Offices , Thank you bro 💟

[@keshavkrishna2723]

Thank Bhai it is really very helpful, and i really appreccite my friends for suggesting me tih channel.

[@whitestacey7]

Thank you so much for this class! Best excel class I have ever taken! 🥳

[@chandoo_]

Wow. so glad to hear that.

[@amitmishra8101]

I cant explain chandoo how easily you explain the things in excel marvolus.

[@sarthakjaiswal7732]

is there sollution for homework questions given ??

[@ashanii66]

This is absolutely a very good video.

[@onyangoochcich3809]

Chandoo is the real deal .Thanks alot

[@jaded.9915]

Chandoo, you are amazing! Do you have the video to show the answer for the homework problems. I am dying to know the answer. Thanks!!!

[@ukeodah3291]

Nice tutorial Am having problems with sum (sales(amount).. its showing me #NAME?

[@earthtomoon3314]

You r the, great sir G. really appreciated

[@jasminebanu3264]

thanks bro, I learned a lot from this video

[@irfanmohammad9023]

thanks dude ......im starting learning data analyst in your tutorial

[@chandoo_]

All the best

[@farhanarizwan5305]

Amazing thanks alot❤

[@ankitpandey3543]

Sir thanks .I want this type of video a very long time. It's very helpfull for beginner.

[@chandoo_]

Most welcome

[@yedieotaka3332]

Thank you Chandoo. This tutorial is so detailed.

[@Akshay-vq1uv]

Chandoo you are a Legend! Bless You

[@naveenbattaa6534]

Thank you chandoo. your teaching is so easy to understand😉 .

[@chandoo_]

Glad to hear that

[@ericassan]

Chandoo you are great… am glued to your channel.. am new to excel and hope to move up the scale soon…

[@lakbaylaboy2644]

You are my favorite Teacher really Chandoo sir

[@chandoo_]

Thanks Lakbay... :)

[@habibaakther1727]

Hello, I want to learn your Excel course completely as a beginner because I want to grow my career in data analysis sector. Can you please provide the instruction about how to purchase your complete excel course ?

[@pouvoirsonghai187]

Thank you! Excellent for beginners

[@tonymurphy9112]

Thank you, great beginners video

[@TheodoreStanley]

Why my total and averaged table doesnt automatically update like the chart? Anyone can help

[@loknathp9952]

Great video. Request you please do similar video with powerbi.

[@chandoo_]

Thank you. I already have a few on Power BI. Check out them here 1️⃣ Power BI with a full & short example (10 mins) - kzbin.info/www/bejne/bJ3dlaKsrpaoedk 2️⃣ Power BI Masterclass (2+hours) - kzbin.info/www/bejne/o4mnYYObpNlnnrs 3️⃣ Power BI Playlist - kzbin.info/www/bejne/eXu6XoyYabWZkJo

[@pusamkanism3656]

Chandoo, I tried the 1st Homework using pivot tables. The 2nd Homework, I tried using the sort and filter command, but it's not showing any effect on the table. For the 3rd, I don't know how to approach it.

[@ramanmayuri3575]

you are fabulous! A fantastic approach to explaining excel!

[@chandoo_]

Wow, thank you!

[@dininduguruge3919]

Well articulated detail presentation .superb

[@mandeepkaur-xl1zw]

Halo sir whenever I’m trying to apply formula with =sum in summary it’s showing a value 0 will u plz help me?

[@salmamulla3684]

Thank you. The videos are very helpful.

[@jersonsoriano3706]

new sub here..as im replicating what u do on the spread sheet im having trouble in formula and using the graph..thanks!

[@Amandafanai1997]

It's so easy to understand for a beginner like me .a keep it up 👍👍

[@donaldharrell3465]

Not sure about adding per box to the table.

[@faitaher7951]

Very helpful tutorial

[@joycetambaya3996]

Very helpful 🎉thanks a lot

[@sarfrazakhtar9887]

When i sort SR NO. Change how i fix this problem? And I watched your beginner (12 years ago one) and this one (intermediate level) video what is the next step?

[@koshalendrasingh2620]

Very useful video thank you 🙏🙏 sir

[@tazinahmed7]

Awesome teaching. 💙

[@yvng4697]

i couldnt understand the homework, should we use Charts for the last one " Add amount per box to the table "?

[@mohammadfayaz6160]

Hi mate I have finish learn excel and practicing daily, what next should I do to get job as data analysis in excel thanks for advise .

[@edidiongbassey919]

I will follow you every way❤.

[@ajithkumar4904]

Hi,with all my greetings. Kindly help me to sort out first 2 questions in the homework page, when ever you get time. Thank you

[@SAKGB]

AMAZING SIR I LUB THE WAY U DELIVERING

[@VinaykumarCheekati]

Hello Sir, I need a suggestion. I have a excel workbook with two columns will be filled by users. after they fill the both the columns. cells need to be locked and cannot be edited by the user. I tried many ways its not working. Please suggest me.

[@mk-gaming]

amazing session thankyou sir...👍👍👍