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

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.



⚙️ Gear I Recommend:

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.

[johnpalmer]

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 .

[drrawlings]

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

[pragyakumari]

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.

[pradeeptarak]

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

[vedant]

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

[VarunGoyal]

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

[sylviakatabaazi]

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

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

[prateekvijay]

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

[ml]

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

[TheHoshmanddeeba]

Thanks for you time and efforts.. best teacher

[ishusoni]

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

[karthickraja]

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.

[thaddcorbett]

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!

[grandmasterace]

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.

[hanifbaloch]

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

[kanikaaggarwal]

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.