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. ❤

[@chandoo_]

Hints for the homework: 1. You can use a PIVOT Report to do this. Select your tracker data, insert a pivot table. Add date to row label area, amount & boxes to values. Here is a getting started with Pivots video - kzbin.info/www/bejne/l6DJpJemn9t-bdk 2. Select the data. Go to Sort > Custom Sort in home ribbon. Apply two level sort 3. Go to the end of the data. In the next column type = and select amount column, press / and select boxes column. Next steps after this tutorial: 1) GET MORE BASICS - chandoo.org/wp/excel-basics/ 2) LEARN DATA ANALYSIS WITH EXCEL - kzbin.info/www/bejne/rGPSf4qglpyAaKc

[@savesoil8549]

sir are u sure of last hint that u gave ....because i get value error using this ....while if i do it as =sum(table1[amount])/sum(table1[boxes]) it works instead of =table1[amount]/table1[boxes] what u have to say ????????????

[@luckygarg9315]

Hey Chandoo, I am just become your fan. If i don't want to use pivot than is there any way to get totals by date? You made awesome videos and deserve million subscribers atleast.

[@michailmarkou1995]

@@savesoil8549 =[@Amount]/[@[Boxes Sold]]

[@dreamsDubai]

How to do shorting? Q2

[@stellalukita7914]

@@luckygarg9315 use SUMIFS

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

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

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

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

[@76Excel]

Hi Chandoo. Thank you very much for being such a great teacher. I've been so terrified of Excel and have been doing all tabulated work on Word. What a waste of time! You've done a fantastic job, and I have learnt so much. God bless you from Canada!

[@ericaoforka8964]

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

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

[@anishhamal9927]

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

[@moseskpaan4540]

Thanks Chandoo for this Beginner Tutorial, I have leant some new basic skills in Excel.

[@cricketcrazy143]

One of the best channel in KZbin for Msexcel Tq sir

[@chandoo_]

Thank you Sairam 😀

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

[@wayneedmondson1065]

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

[@chandoo_]

YES!!!

[@bmcmails]

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

[@pjaviation9268]

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

[@nautiyaladarsh]

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

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

[@shahtajp4379]

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

[@canirmalchoudhary8173]

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

[@chandoo_]

Thanks Nirmal for the love and support. :)

[@minakshilute8515]

Your teaching is completely excellent . Thank you

[@rkkk3941]

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

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

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

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

[@rahulrdj]

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

[@abinaya9538]

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

[@devildj3311]

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

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

[@MercyAlfred-g6s]

So grateful for this tutorial 🙏❤

[@tolulopesubair2597]

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

[@ebierealexandria]

Thanks Chandoo, This is the best channel ever.

[@savesoil8549]

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

[@ashrafsadick1582]

Thanks for the tutorials. It's really helpful Could you please guide me on how to calculate the totals? Thank you

[@onepunchman00]

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

[@ifejayeola8497]

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

[@kapilshinde8672]

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

[@7dx549]

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

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

[@natureisbest7632]

Thanks a lot sir, it really helps !

[@tomjun8945]

Excellent video like always. Thank you!!

[@chandoo_]

Thanks again!

[@nomanjaved3560]

Awesome it has been great learning for all of us.

[@whitestacey7]

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

[@chandoo_]

Wow. so glad to hear that.

[@TheTravelDiaries486]

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

[@ananttrivedi23]

chandoo sab ka bandhoo...You are amazing buddy

[@onyangoochcich3809]

Chandoo is the real deal .Thanks alot

[@hasanmehdi7219]

You have explained in a very good way

[@francismwangi1885]

Very helpful. Thank you.

[@chandoo_]

You're welcome. Let's get better at Excel!

[@shahinferdaous2461]

Great Learning video's.

[@sairamadaboina8257]

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

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

[@lakbaylaboy2644]

You are my favorite Teacher really Chandoo sir

[@chandoo_]

Thanks Lakbay... :)

[@ankitpandey3543]

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

[@chandoo_]

Most welcome

[@FarhanaSultana-b4s]

This channel is very good. Thank you dear Chandoo.

[@keshavkrishna2723]

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

[@sadafanwer8531]

you have a very clear way of explanation I really like

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

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

[@kelvinaddaeboateng2733]

Thanks for the lesson...I am a newbie But Sir I totally don't know how to go about the assignment

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

[@naveenbattaa6534]

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

[@chandoo_]

Glad to hear that

[@Akshay-vq1uv]

Chandoo you are a Legend! Bless You

[@nanaogirima-zm4bj]

This is super helpful. I need to make good friends from here to grow together in fields like this... Anyone???

[@ashanii66]

This is absolutely a very good video.

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

[@mk-gaming]

amazing session thankyou sir...👍👍👍

[@tazinahmed7]

Awesome teaching. 💙

[@ramanmayuri3575]

you are fabulous! A fantastic approach to explaining excel!

[@chandoo_]

Wow, thank you!

[@Akshay-vq1uv]

Thanks

[@irfanmohammad9023]

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

[@chandoo_]

All the best

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

[@p.kyadav9642]

Hi Chandoo salute to ur wonderfull efforts....A masterpiece tutorial u hv initiated...

[@earthtomoon3314]

You r the, great sir G. really appreciated

[@ericassan]

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

[@jaydeepninawe6993]

Best excel lecture Nice sir 😀🙏

[@jasminebanu3264]

thanks bro, I learned a lot from this video

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

[@Amandafanai1997]

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

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

[@yedieotaka3332]

Thank you Chandoo. This tutorial is so detailed.

[@edidiongbassey919]

I will follow you every way❤.

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

[@DhanashriMunj]

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

[@koshalendrasingh2620]

Very useful video thank you 🙏🙏 sir

[@bikrambiswas324]

from 20:48 ,when i entered new data the calculation do not happen automatically...pls help

[@jaseera1000]

Very nice nd controlled presentation.

[@tonymurphy9112]

Thank you, great beginners video

[@ArjunSingh-rn3wh]

Loved it !! I love the first question, i.e. Calculate totals by each date - for amount & box columns. In this question i copied the data of date to another sheet, where i pasted into the date column, there i removed the duplicated, through "Remove Duplicates". After that made 2 columns, "Total by Amount", "Total by Boxes". Under the total by boxes, i used the "SUMIF" formula, =sumif(sales[Date], The data of which total amount i want, sales[Amount]). Thank you for the knowledge that you share, sir.

[@salmamulla3684]

Thank you. The videos are very helpful.

[@pouvoirsonghai187]

Thank you! Excellent for beginners

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

[@jersonsoriano3706]

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

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

[@dininduguruge3919]

Well articulated detail presentation .superb

[@BobMbai]

Awesome content...I love the way you teach

[@chandoo_]

Thanks Robert... :)

[@dreamdecor888]

thankyou so much sir ... i really appreciate your hardwork

[@chandoo_]

So nice of you. More power to you DD.

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