[FREE EXCEL COURSE] Lesson 3 - Data Formatting in Excel

[@dhapumdhap]

Yes, indeed. Just like many of your viewers/subscribers have commented, I'm quite impressed with your lucid style of organizing and teaching the basics with such ease and patience, it's really growing on me. Thank you very much.

[@drrawlings]

No hype. This teaches complex things using the most simplified method. 👌

[@Bearhead66]

New to Excel. Had no idea what it was capable of. I'm only on the third lesson and it is already helping me understand Excel more than i ever did before. Thanks .

[@pradeeptarak8217]

No need to go particularly Excel classes ,,, this is enough to learn more about excel ,, excellent explaining pont to point , well done bro

[@vedant8537]

Finally found a genuine excel course. Really good and genius one👏🏻❤

[@VarunGoyal777]

Thanks a lot Sumit, for telling a feature that solved so much of my problem..."Center Across Selection"..

[@SteS]

Fairly proficient with excel but you can always learn. Today it was double click match tool and centre across selection. I've always used merge and centre. Thank you!

[@Infinite-Influence]

amazing teacher .. he deserves more views ...god blesss u thnx buddy

[@trumpexcel]

Thanks for commenting Mansi... Glad you found the video useful!

[@NileshJagtap-m8m]

Deserve 100k so simple and easy to understand and apply

[@InterestingVideos556]

It's so value for finding this channel

[@pragyakumari6138]

Thankyou so much sir you don't know how much you helped me through your videos i can't afford the payble excel course and your videos help me in gaining knowledge and boost my skills more.

[@trumpexcel]

Happy to know the videos are helpful 🙂

[@tahaexplores]

Great, Hats off your teaching style is best.

[@hanifbaloch83]

Double click format painter trick was something new for me. Thanks a lot...

[@mohammadrezaabdoli1810]

Just amazed how good you teach, fascinating 🔥🔥

[@trumpexcel]

Thank you for the kind words 😊

[@thaddcorbett2148]

Thanks bro! That "sum" button just saved me a huge headache. In the past I thought I was supposed to type something like =B2+B3+B4+B5+B6 thanks!

[@jasobantibehera8764]

Explanation is excellent

[@joyful6933]

Thank you for making video on excel in an understable manner.

[@sylviakatabaazi3767]

I have learned more about the cell formatting in this video. Shrink to fit, ctl +1 e.t.c. thank you for sharing.

[@prateekvijay7746]

Very useful video. Every thing is in detailed. Thank you so much

[@ml3842]

WOW. Nice shortcuts. Great effort from your side. Thank you.

[@kanikaaggarwal9181]

I have just started your videosand this is soo amazing that i got your channel. Your way of teaching is very soothing and too good. Thankyou so much for these lessons.

[@TheHoshmanddeeba]

Thanks for you time and efforts.. best teacher

[@FluxElectroTV]

I just wanna say thank you so much for doing this cause i can't afford to pay for courses and I'm currently going through a career change and you have helped me get through this difficult time. Thank you again 🙏

[@ishusoni629]

This is amazing. You saved my money. And easily making us understand everything. Thank you so much.

[@karthickraja2436]

HI, Am really very much looking for a tutorial like yours for ages for a better & deep understanding of excel. it's really a very useful for newbies and even for pro learners. am learning many new things from your tutorial . Thanks a lot for this high motive tutorial.

[@grandmasterace4785]

Here for a refresher course on the basics of Excel and your lessons have been a great help. It would have taken more out of me to figure out the things I knew all by myself.

[@Aashitaaaaa]

Amazing work! thanks!

[@AnkushSharma-sz4lg]

Just superb yaar just superb never thought i would excel in excel 😊

[@ryanmdsouzaa]

Thank you Sumit for sharing such valuable videos.

[@ania2742]

Great job on all the videos of this course! Thank you!

[@trumpexcel]

Glad you're finding the courses useful!

[@farehahrahim8550]

The best lecture among the best. Thank you Sir 👍

[@huuhanh16]

Thank you so much, such a useful channel!

[@zainabebrahim8392]

God bless you Sumit.. very nice video.. stay blessed ☀️🙏🌙

[@wayneedmondson1065]

Hi Sumit.. thanks.. great review.. great information. Thanks for offering this course for free. Thumbs up!

[@abhishekchaubey6046]

Thank you sir For teaching 💯

[@coderfek]

Thanks for providing us this free tutorial.Very detailed and helpful ;)

[@margad-erdeneboldbaatar4704]

Thanks for the this course.

[@kanchansajnani4315]

I thought excel was so difficult n u explain it so well..... Thanks.... It is so easy n simple to understand when u go thru this course...... Thanks ☺☺

[@mohanvaze1]

Very nice, particularly, Center across Selection in Alignment and Cell style was a new learning, I will be using it now on. Thanks a lot. Best regards

[@aygunsafarova3079]

Thank you for great explanation.

[@Jaisshriram]

Wow well explained clappped for Sumit bansal

[@sairamvenkata1855]

The content is very good .. no need to go for coaching.

[@Tsukimi9]

You're a genius❤

[@dalsieallen-thompson2639]

I am truly learning alot. had no idea excel was this good . i am on the third lesson which is assisting me well it allows me to comprehend excel more thanks

[@sandigadzur8122]

This lessons are fantastic

[@jeffreysojo4187]

Excellent work my friend! thanks for the great effort.

[@m.irfanpirwani3064]

You are doing a great job. Sir , how to CENTER ALIGN 2 or more cells VERTICALLY without using merge and center

[@dominickalmilla989]

great tutorial. helped me a lot.

[@sbeku]

Excellent explanation God bless you

[@bimpeibrahim788]

Great one

[@ramachandramm5380]

Hi Sunil ji F4 shortcut is not working in my office home and student 2021..

[@Bandellacosla]

Amazing Tutorial Mr. Trump, along with the tutorial can you kindly say about the keyboard shortcut in your video if possible.

[@abhisheknaruka8710]

Thank you 😁✌️👍

[@mohammadirkanansari671]

SIR YOU ARE GREATE BECOUSE YOU TEACHING SKILL IS CRYSTAL CLEAT

[@itisharma4875]

From where can we practice excel? Like are there any exercises that we can do? Any websites or material?

[@mathematics_infinity_pi2779]

Really exciting

[@alexanderjoe2933]

You're a life saver

[@manasiteliofficial3028]

Thank you 😊

[@educationislove9873]

Sir can u tell us assignments so we can practice after every lecture?

[@Shree8140]

sir ,what shortcut you use for get back or undo data .

[@trumpexcel]

Control + Z (hold the control key and then press the Z key)

[@dafrimohamedzineddine8571]

THANK YOU SO MUCH BROTHER

[@zain...4187]

Thanks ❤️

[@GoGetSP]

When I am selecting the data in the RawData sheet and changing the format from General to Number , the data isn't getting right aligned? why is that? please guide , ty in advance 🙏

[@jaykabutarandpigeon]

excellent

[@alemameneshoa3743]

Thank you so much

[@yuvrajahuja1857]

Thanks Sir

[@AD-pe8mo]

Awesome.....

[@preetisaini6963]

thank you😃

[@aminsaiyed1089]

i want to prepare excel sheet of daily expenses of the year 2021 how can i make? pl give me suggestion.

[@rameshakula4292]

format brush painter for the multiple objects is not working in 2021 versions

[@kyrieeleison7065]

How can I get videos for both lesson 1 and lesson 2? Thanks for this brilliant lesson.

[@priteshpatel7682]

Really amazing but Pl share exercise file so that we can do pararally

[@anandthakur9006]

Plzz tell me someone why after pressing control g i am going back to the same it still the same changes doesn't happen plzz tell me

[@faujiDeepakKumar-fg8vk]

Sir there is no raw data and format data option available in 2007 version and also I double click on format painter it is not selecting

[@middleclass4137]

Thank you sir

[@ARIFSAIFIFARHAN]

Hello Sumit Do you provide paid session, Let me know how can I approach you

[@pulkithanduja2428]

sir how you placed raw data and formatted data at left bottom is this sheet

[@Prasantkumar2064]

Write formulas to calculate the retail prices (Net Price + Sales Tax) for all 500 Products in both NY and SF. You MUST reference cells A5 and B5 in your formulas. please solve the question

[@marymo7528]

Very good

[@kidteacher8846]

Fill required when we type songs in excel

[@teddybulunga3393]

Thank you!!

[@fayazmuhammad5983]

Sir when I orient Number instead of text I get # Sir what is the reason behind it.

[@trumpexcel]

It should work just like text. One reason this happens is when the cell width is less, so making the column with wider sorts this out

[@krishnasathya5272]

thank you

[@kartheekpanuku3376]

files to practice

[@sohailahmad7363]

how to draw table plz

[@KashifReads]

please enable captions

[@mohammadirkanansari671]

SIR IF TEACH ME CONDITIONAL FORMATTING I AM VERY THANKFUL TO YOU

[@marcello2051]

obrigado sr indiano

[@missytales]

Ctrl - F4 for redo

[@anupkumarsingh476]

Hi, Can you share your email if we have any doubt?

[@RahulKumar-pw8tg]

👏👏👏🙏🙏🙏

[@varshagupta866]

Instead of these u should hv used formula, this is totally basic 5th grade students content

[@trumpexcel]

This is basic Excel in the beginning of the course. If you want to learn how to do formatting using Conditional formatting, that will come later in the course.

[@heeyaboruah9226]

I am in 7th grade so thanks this helps me a lot because it is for me!

[@JeremiahCarter]

Thank You!!!

[@PersianPartyRock]

Thank you!!!