Complete MS Excel Tutorial for Beginners | Part 2 of 3 | (with Download link)

[@athiresh-cm7pt]

Me who's watching this without even a laptop 😅

[@divyaaleixa7831]

Same😂😂😅

[@gs5571]

Same here too. But I have tried it by using mobile.

[@awamee]

Noobs

[@HR-uy3br]

❤😂

[@panugotirajkumar5148]

Me 😅

[@windchimes.]

Please make a video on HLOOKUP, XLOOKUP, and INDEX MATCH functions too

[@shivam_kumar1994]

I'm not sure if this comment will reach you, but I've been watching numerous videos to learn Excel for the past few months. However, most of the concepts weren't clear to me. The videos are often too long, such as 10 hours or 6 hours, and I end up getting bored at some point. The way you explain things really makes sense. Kudos to you! I would appreciate more videos at different levels, such as beginner, intermediate, and advanced.

[@MuzainShariff]

This 1 hour 27min and 11sec course of Excel is GOAT .......just amazing.... Lots of respect .....thank you so much ..

[@polokahmedtushar5860]

I have just finished your tutorial and learnt many things. You explained each of these functions and formulas with the easiest possible ways. Thanks for your effort.

[@afrinsheikh6911]

I am listening you since 2019, back then I used to watch your videos for my college placements, I'm glad to see you back on YT, lots of respect, you are inspiring :)

[@pradeep3528]

Ma'am I want to read book but my English is bad nd not understandable phases as well as speaking 🗣️ how to start book reading strategies nd strong vocabulary because I try to read but infact single pages not familiar of vocabulary so many times have to searching so that whole paragraph exactly meaning not found at the end of completing one pages then how to strong from strach?? please help ma'am and all guys

[@thepomodorosociety6768]

Read word power and after that completing it start reading the Hindu editorials, don't expect to understand them for first three months till then take help of chat gpt to understand the editorials, and then just google every word you think is important and you can also maintain a digital library for the words you like or find Important. And read novels or books like sapiens within 6 months you will be at a level where you will not get overwhelmed by vocabulary and by then you will also have improved your comprehension

[@daphynegracias8515]

This is one of the best excel courses out there. The practice sheet is so useful. I cant believe I had so much fun learning excel and I didnt even feel overwhelmed or bored. The simplicity and ease with which you explain translates to the viewers and makes everything look easy. Thanks a ton. The only problem that I faced was flashfill doesn't work in my version.

[@meghanair3328]

Can you please tell me which version is this one

[@vaijayanthir8731]

I am from Tamilnadu. I was subscribed your channel when I seen your channel first time for the content of how to speak in English. What a great teacher you are! I love your way of teaching and expressions. Excel class for beginners is amazing...

[@pushparai2578]

Ggggggggggg. . ,. ,. , , ,. ,

[@hemanthadapa7246]

❤❤❤❤❤

[@nareshadministrator7729]

Ur voice getting very low some words 😢

[@junity1]

Certain parts of this tutorial were too fast for Beginners ! You may have to talk slower when explaining these functions. No need to talk that fast through them. Thank you.

[@poojatiwari3880]

Very clean and clear! Great content, thankyou for sharing your knowledge!!

[@hashkat6465]

that small box while that appears after dragging 10:07 didnt appear on my web excel

[@anuragtiwari6910]

Same, but it something like it is showing up on offline office

[@radhavitiwari3876]

Thank you so much for Basic MS Excel video series.... Request you to make similar series on Advance Excel, MS PowerPoint, MS Outlook & MS Word.

[@aatlasrisatya4528]

Yes please make viedos for advanced excel

[@narayansharmag58]

Throughout this video I was thinking dude I've seen her somewhere... But the voice no I've never heard that before and today I realised she looks like Shruti Sharma 2021 IAS topper

[@anoysaikia3384]

My flash fill option isn't available. Also tried the advanced option to check it. But it's not available there

[@anuragtiwari6910]

Same issue with me too

[@mahi-ho9nc]

And ,if(and) gives same result...and gives true or false If(and) gives which statements we give it will display like that 😂

[@imranshaik7589]

Everything is too good but the sound quality is too low..... please improve it

[@vigneshwaribalaga7306]

Iam aspiring for the lead role in the current working company so am I seeking to learn excel

[@yeshwanthm6188]

Ma'am if possible please try to do advanced Excel if you can. Because I fell very comfortable to learn within 2hrs

[@windchimes.]

At 1:19:59 you mention "analyse data" button. It's not there in my excel worksheet.

[@biram1289]

Mam plz make video about Excel jobs

[@rishabhmakkar6624]

Though I have blur knowledge of excel, it was all brushed up. Now I feel comfortable to learn hard core excel.

[@masterclassic2271]

Great video for beginners..it's really helpful..take a bow 🙌

[@prashbk]

I have been using Excel for many years..but never used or observed flash fill feature. Even though many things are basics but very useful.. thanks for sharing 🙏

[@TheUrbanFight]

Glad it was helpful!

[@narayansharmag58]

Because flashfill isn't available on older versions of excel

[@prateekverma1256]

Kindly make a video on "INDEX MATCH"@@TheUrbanFight

[@sakshibenjamin2813]

i literally enjoyed this session of yours !! The way you taught all the things, that was just awesome >>> Thanks a lot !! ❤

[@parthaedu9039]

Actually your IELTS video has helped me a lot, thank you very much

[@sweetmelodiesbysumeet4767]

have been learning excel from long time, but the way excel is being learned here is fun and easy to grasp. Have a blessed time ahead. right now finished 32 mins of this video and the joy of learning is increasing. Thanks a lot

[@dhanushn-u2m]

mam i request a separate video for pivot table and thanks for the knowledge

[@Abhi42039]

practice workbook is not working, please help me. please give to do practice i want to do practice please reply someone

[@Mis_sush_gaming]

Im not able download the work book

[@faizulansari29]

im sorry but it was jarring for me to constantly listen "hermoine" instead of the actual name. i just had to say this here otherwise i would have kept thinking about it throughout the whole video. btw, the video was excellent.

[@RachuBubbly]

CREATE a seperate video to teach which u missed in this video like index match and some other function.

[@arunraj7332]

Please upload next level of excel lesson thank you

[@priyankapanchal5306]

Thank you for such a good course in very easy way. I have one request to you, please don't stop making video. I eagerly wait for your video topic does't matter, because your every video gives so many learning. You are such a great you tuber. You helped me a lot. Your work is actually appreciable.

[@manisankardatta3417]

Great Vedio, if u make some Vedios on power point tricks and detail vedio on how to make slides on canva , will be very helpful

[@fathimats450]

Overall good...but confusing too

[@srikanthg9357]

THANKS , I GOT CLARITY OF EXCEL IN MY 6 YEARS ONLY AFTER WATCHING THIS VIDEO…., BECAME A FAN OF YOUR TEACHING

[@Glamifytips]

I am working on excel online and I am not getting the option of autofill..please help🥺🥺

[@farhaqureshi6952]

There's no practice sheet for absolute references onwards.

[@gowthamsandeep9839]

Hi I have one doubt in the Excel conditional formatting could you please help me

[@prateekverma1256]

Kindly make a video on "INDEX MATCH"

[@kenathuthavalai1823]

such a wonderful class ... planning, creation, delivery everything was amazing. new lead and concept no one replace your place.

[@DheerajSingh_00]

Nice for beginner who nothing know about the ms -excel . And thank to ma' am for such useful video.

[@shaamlv]

Happy to see you after a long time, Good work I was searching this video for a week, exactly at the right time. Make videos consistently a kind request as a subscriber.

[@Hrishikamondal]

I'm preparing for the HR role including recruitment. So I need to work with both Ms word and Excel to keep the records of the candidates. Plz suggest how I should prepare for it.

[@Sufiyan_2002]

She's a Harry Potter fan😂..and so I ❤

[@pareshpatel1504]

🙂I have just finished your tutorial and learnt many things. You explained each of these functions and formulas with the easiest possible ways. Thanks for your effort.

[@जीवनचक्र-श3न]

Ma'am, Data entry and Excel same or different. It would be great if you could share a video on how to do data entry by phone for online Dara entry jobs.

[@tripurarisaisubhash4191]

Mam how can we access workbook it's not accessing

[@dudipayal]

This Excel tutorial video is very helpful for me..... I love it❤ Thnx a lot🍀

[@AnnaRinta]

Please do a video on other Microsoft tools like word, powerpoint etc . Your video is too good .

[@MrMysterious31]

❤❤

[@madhavam718]

Hi, I have data or blank cells in range A2:K20. Each cell may contain either data or blank. In column J, I want the last non blank data to be returned for each row. How can I achieve this. Please help.

[@moviesExplore17]

Mam, Do More Videos On Advanced Excel and Hlookup,Index match,...

[@vinaypatil8009]

Volume of the video is very low by default pls fix it in future videos

[@shweta-bisht]

Ahh finaly a female teacher 💕😊

[@GigglyGiraffes]

hey ! this toturial is amazing . but i just want to know that can we do all these visualisation chart part in web version of excel 365 . because i am getting issues while working with it as few options like recommended charts, are not available in my case . please help

[@ashasakpal3165]

Love your way of teaching my dear you are too good ❤ God bless you in abundance with lots more success😊

[@shivamgupta097]

I would like to learn excel to use in my teaching profession .

[@karanamyamuna17]

Ur explanation is understandable,I really liked it. I wish to do more videos for even management related students.♥️

[@hari_kumar123]

Thanks a lot for making this amazing playlist on excel. Its very to understand the concept. Your way of explanation is too good. Thanks a lot , madam 😊😊

[@ivyendeavourhumanity]

*Wow!❤ Ma'am kindly make complete Playlist of PPT basics to advance as well* ❤ 🌈 🏳️‍🌈 🌈

[@shubhtechdigital277]

very nice explanation and best tutorial of MS EXCEL

[@TheUrbanFight]

Glad you think so!

[@PenchalReddyBovilla]

hai Mam plz do video exclusively on lookup functions , it might be useful.. thank you for your efforts

[@PoeticPulse953]

You are such a great teacher 😘, love you 😘☺️♥️

[@kavithaunnikrishnan1919]

Something I was searching for.... Thank you so much Urban fight

[@ShruthiPenikonda]

Hello Urban Fight, Thanks for your videos, It would be a great help, if you make a video on EXCEL SHORTCUTS, because in work mostly everyone will use more SHORTCUTS, so a very small request. Thankyou.

[@NakalemaHannah]

that was the simplest tutorial ever. thank you for making it easy to learn. you are the best teacher ever.

[@thasneem120]

I have watched the 3rd vid whc is interview vid first, then I'm here, The thing you said often you will enjoy the video is really damn true 💯 Thanks for making it in such a manner.

[@pallavimalla5195]

Thank you for every minute detail..

[@sapnakumari-xk7gs]

Pls also make video on ppt tips

[@saicharan4081]

CONCAT and TEXTJOIN Formulas not working in practice workbook sheet

[@premikapachikoru9821]

This Video is useful and very easy to understand. I am requesting that you please make detailed videos of Hlookup, XLOOKUP, and Pivot tables.

[@CharuMalhotra_13]

thank you so much mam its really helpful. i have a querry mam i entered the arguments in SUMIF function but its not working, a message popping up that arguments are too long.

[@gautambala1819]

Mam practice sheet have no data in it ,Please upload correct one excel section is very useful for my job please upload more useful videos like excel thank you mam

[@TT-xg7qd]

Wow it's amazing video lot of videos are there but here it's superb amazing work 🙏👏👏

[@varshasingh3364]

After seeing all the tutorials on Excel video...I reached on right ▶️ it's really good and easy to understand for me😅

[@Extraterrestrially_Activities]

while clicking on practice workbook link it only taking me to fill the form but not towards any workbook.. why so?

[@tushar5687]

Please make a seperate video on H,X and index match Look up..

[@pavithrasridhar8478]

Plz make pivot table complete video thanks for putting so much of hardwork to educate society

[@saiKishore-jg3dj]

Madam please interduce about power bi course please

[@mrpavankumar2747]

Please make More Videos Regarding to XLookup, HLookup, and Relating to Data analysis Make some videos madam

[@Lokivlogs98]

Best ever Excel video on youTube😍 Thanks a lot❤

[@JayaramuduTondaladinne]

iam practicing that Auto fill And falsh fill but + symbol icon not comming into my excel sheet pls help this issue

[@TheUrbanFight]

Select a cell. Then hover your cursor at the bottom right corner of it. You will see the fill handle. Have fun excel-ling! :)

[@shwetafursule1794]

❤❤ thanks mam

[@daphynegracias8515]

Thank you so much! It was such a helpful video and I was able to do it so easily. I just had a problem with flash fill though. It's not available in data in my excel version.

[@Rohitpatel-hr3jk]

Wonderful course I appreciate you for providing it at free of cost that makes you best tutor. I really like the way you teach us . Plz make videos on interview preparation

[@sumidas8076]

your videos are so simple and informative.could you also create a video on how to create and use MIS reports in excel?

[@deeannmckenzie188]

This video is very helpful. Could you also make a video on Excel shortcuts pls.

[@shreyakottapelli5092]

28:20 mam how to freeze other columns?

[@pulkit0g]

Someone's a Potterhead for sure 12:10 ❤❤

[@parthaedu9039]

Hello curly 🎉 good to see you after a long time Thank you

[@pmalli5332]

Mam hi iam new subscribe how to know case study in excel please upload video case study excel mam

[@KrishnaMaganlalKhandelwal]

Please create a video on Pivot table.

[@fortunatemiles2556]

Am looking forward to turning into a pro I can't believe it. Good teacher I love you. You really can explain. Words won't explain what am feeling of you thank you God bless you.❤❤❤❤❤❤❤❤❤❤❤❤

[@abhishekganguli117]

it was awesome, the way you make us learn it was like having a fun.Thank you so much.

[@swapnareddyvaka5201]

Hello mam . which version of excel your using currently...i am not getting auto fill option for micro soft excel online...plz help mee...😊

[@parmarchetan7259]

It's very easy to understand because of you ma'am.....I am so happy for this video created you❤❤❤❤❤❤❤thank you

[@KARTHIKAVINOD-c9m]

Is concat and termjoin functions working. It was not working for me, concatenate function is there but sytax is different from concat as mentioned

[@narutodihargo]

0:00 - Introduction 2:18 - Workbook Basics 2:58 - Cell Name/Cell Address and Cell Range 5:09 - Insert/Delete and Hide Rows/Columns 7:06 - Introduction to the MS Excel Ribbon 8:21 - Autofill and Flashfill 14:22 - Home Tab Features 14:44 - Formatting Options 15:52 - Wrap Text 16:15 - Merge and Centre 16:50 - Number Formats 17:33 - Conditional Formatting (Highlight Cell Rules, Data Bars, Icon Sets, Colour Scales, Clear Rules..) 19:50 - Auto-fit Column Width 20:11 - Find, Select and Replace 22:22 - Sort & Filter 25:50 - Split and Freeze Pane (View Tab Features) 28:59 - Difference Between Split and Freeze Pane 29:38 - Functions and Formulas 29:49 - Sum, Average, Max, Min 31:50 - Count, CountA, CountBlank 32:45 - Difference between Formula and Function 33:54 - Relative and Absolute References 38:38 - Mixed References 42:12 - Logical Functions 42:29 - IF Function 44:14 - Nested IF 45:09 - AND Function 46:22 - OR Function 47:40 - SumIF Function 49:44 - CountIF Function 50:30 - Text Functions 50:52 - Left, Right, Mid 51:40 - Upper, Lower, Proper 52:05 - Len and Trim 52:55 - Concat and TextJoin 54:15 - VLOOKUP 57:42 - VLOOKUP Limitation 59:57 - MS Excel Tables (Creation and Features) 1:04:14 - Slicers 1:06:30 - Charts 1:10:20 - Different Chart Types 1:12:04 - Pivot Tables (Cleaning Data, Create Pivot Table and Analyse Data Option) 1:21:27 - MS Excel Errors 1:25:25 - IFError Function

[@kingqueen1033]

Good Job

[@ektaaggarwal9874]

Thankyou