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

This video covers the basics of data formatting in Excel.
You can format data in Excel to make it look better and to highlight some data points.
For example, if you have data-set and you want to highlight the negative numbers, you can simply highlight it in red color to it.
Here are some of the common formatting I use to make my data look better and more readable
-- Applying borders to all cells
-- Making headers bold
-- Giving a background cell color to headers.
-- Center align the headers
You can find these options in the 'Home' tab in the Font category.
✅ Download File - trumpexcel.com....
☕ If you find the videos useful and would like to support me, you can buy me a coffee - www.buymeacoff...
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: trumpexcel.com...
You can also access the Full Excel Training on TH-cam here: • Getting Started with E...
Free Excel Course - trumpexcel.com...
Paid Online Training - trumpexcel.com...
Best Excel Books: trumpexcel.com...
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: www.youtube.co...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial

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

[@johnpalmer3411]

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 .

[@vedant8537]

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

[@pradeeptarak8217]

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

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

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

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

[@sylviakatabaazi3767]

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

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

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

[@ishusoni629]

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

[@prateekvijay7746]

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

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

[@TheHoshmanddeeba]

Thanks for you time and efforts.. best teacher

[@joyful6933]

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

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

[@tahaexplores]

Great,
Hats off your teaching style is best.

[@Aashitaaaaa]

Amazing work! thanks!

[@vlogbyheart4993]

It's so value for finding this channel

[@farehahrahim8550]

The best lecture among the best. Thank you Sir 👍

[@mohammadrezaabdoli1810]

Just amazed how good you teach, fascinating 🔥🔥

[@trumpexcel]

Thank you for the kind words 😊

[@ania2742]

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

[@trumpexcel]

Glad you're finding the courses useful!

[@zainabebrahim8392]

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

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

[@coderfek]

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

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

[@abhishekchaubey6046]

Thank you sir
For teaching 💯

[@huuhanh16]

Thank you so much, such a useful channel!

[@m.irfanpirwani3064]

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

[@aygunsafarova3079]

Thank you for great explanation.

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

[@sbeku]

Excellent explanation God bless you

[@sandigadzur8122]

This lessons are fantastic

[@margad-erdeneboldbaatar4704]

Thanks for the this course.

[@AnkushSharma-sz4lg]

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

[@jeffreysojo4187]

Excellent work my friend! thanks for the great effort.

[@manasiteliofficial3028]

Thank you 😊

[@Tsukimi9]

You're a genius❤

[@zain...4187]

Thanks ❤️

[@ramachandramm5380]

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

[@dominickalmilla989]

great tutorial. helped me a lot.

[@abhisheknaruka8710]

Thank you 😁✌️👍

[@alexanderjoe2933]

You're a life saver

[@JeremiahCarter]

Thank You!!!

[@jaykabutarandpigeon]

excellent

[@mathematics_infinity_pi2779]

Really exciting

[@Bandellacosla]

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

[@sairamvenkata1855]

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

[@alemameneshoa3743]

Thank you so much

[@AD-pe8mo]

Awesome.....

[@dafrimohamedzineddine8571]

THANK YOU SO MUCH BROTHER

[@preetisaini6963]

thank you😃

[@itisharma4875]

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

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

[@krishnasathya5272]

thank you

[@mohammadirkanansari671]

SIR YOU ARE GREATE BECOUSE YOU TEACHING SKILL IS CRYSTAL CLEAT

[@middleclass4137]

Thank you sir

[@educationislove9873]

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

[@marymo7528]

Very good

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

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

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

[@priteshpatel7682]

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

[@aminsaiyed1089]

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

[@Infinite-Influence]

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

[@trumpexcel]

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

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

[@ARIFSAIFIFARHAN]

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

[@kidteacher8846]

Fill required when we type songs in excel

[@pulkithanduja2428]

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

[@kartheekpanuku3376]

files to practice

[@marcello2051]

obrigado sr indiano

[@Kashifnasir89]

please enable captions

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

[@mohammadirkanansari671]

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

[@missytales]

Ctrl - F4 for redo

[@RahulKumar-pw8tg]

👏👏👏🙏🙏🙏

[@anupkumarsingh476]

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

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

[@PersianPartyRock]

Thank you!!!

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

[@yuvrajahuja1857]

Thanks Sir

[@hanifbaloch83]

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

[@sohailahmad7363]

how to draw table plz

[@Jaisshriram]

Wow well explained clappped for Sumit bansal

[@wayneedmondson1065]

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

[@ryanmdsouzaa]

Thank you Sumit for sharing such valuable videos.

[@teddybulunga3393]

Thank you!!