[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.
☕ If you're the videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
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/learn-excel/
You can also access the Full Excel Training on KZread here: • Getting Started with E...
Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/
⚙️ 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: kzread.info...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 94

  • @dhapumdhap
    @dhapumdhap3 жыл бұрын

    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
    @drrawlings14 сағат бұрын

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

  • @johnpalmer3411
    @johnpalmer34115 жыл бұрын

    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 .

  • @SteS
    @SteS5 жыл бұрын

    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!

  • @vedant8537
    @vedant85372 ай бұрын

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

  • @VarunGoyal777
    @VarunGoyal7773 жыл бұрын

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

  • @pradeeptarak8217
    @pradeeptarak8217 Жыл бұрын

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

  • @grandmasterace4785
    @grandmasterace47854 жыл бұрын

    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.

  • @mitunlakshmanen4668
    @mitunlakshmanen46684 жыл бұрын

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

  • @karthickraja2436
    @karthickraja24364 жыл бұрын

    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.

  • @mohanvaze1
    @mohanvaze13 жыл бұрын

    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

  • @FluxElectroTV
    @FluxElectroTV2 ай бұрын

    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 🙏

  • @Infinite-Influence
    @Infinite-Influence4 жыл бұрын

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

  • @trumpexcel

    @trumpexcel

    4 жыл бұрын

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

  • @sylviakatabaazi3767
    @sylviakatabaazi37673 жыл бұрын

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

  • @wayneedmondson1065
    @wayneedmondson10655 жыл бұрын

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

  • @coderfek
    @coderfek2 жыл бұрын

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

  • @ishusoni629
    @ishusoni6292 жыл бұрын

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

  • @kanikaaggarwal9181
    @kanikaaggarwal91812 жыл бұрын

    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.

  • @hanifbaloch83
    @hanifbaloch832 жыл бұрын

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

  • @dalsieallen-thompson2639
    @dalsieallen-thompson26394 жыл бұрын

    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

  • @jeffreysojo4187
    @jeffreysojo41873 жыл бұрын

    Excellent work my friend! thanks for the great effort.

  • @prateekvijay7746
    @prateekvijay77464 жыл бұрын

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

  • @thaddcorbett2148
    @thaddcorbett21482 жыл бұрын

    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!

  • @ryanmdsouzaa
    @ryanmdsouzaa3 жыл бұрын

    Thank you Sumit for sharing such valuable videos.

  • @kanchansajnani4315
    @kanchansajnani43153 жыл бұрын

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

  • @Aashitaaaaa
    @Aashitaaaaa2 ай бұрын

    Amazing work! thanks!

  • @joyful6933
    @joyful69333 жыл бұрын

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

  • @sbeku
    @sbeku5 жыл бұрын

    Excellent explanation God bless you

  • @huuhanh16
    @huuhanh16 Жыл бұрын

    Thank you so much, such a useful channel!

  • @aygunsafarova3079
    @aygunsafarova30793 жыл бұрын

    Thank you for great explanation.

  • @zainabebrahim8392
    @zainabebrahim83924 жыл бұрын

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

  • @TheHoshmanddeeba
    @TheHoshmanddeeba4 жыл бұрын

    Thanks for you time and efforts.. best teacher

  • @ania2742
    @ania27423 жыл бұрын

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

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

    Glad you're finding the courses useful!

  • @tahaexplores
    @tahaexplores Жыл бұрын

    Great, Hats off your teaching style is best.

  • @vlogbyheart4993
    @vlogbyheart4993 Жыл бұрын

    It's so value for finding this channel

  • @dominickalmilla989
    @dominickalmilla9892 жыл бұрын

    great tutorial. helped me a lot.

  • @mohammadrezaabdoli1810
    @mohammadrezaabdoli18105 ай бұрын

    Just amazed how good you teach, fascinating 🔥🔥

  • @trumpexcel

    @trumpexcel

    5 ай бұрын

    Thank you for the kind words 😊

  • @dafrimohamedzineddine8571
    @dafrimohamedzineddine85713 жыл бұрын

    THANK YOU SO MUCH BROTHER

  • @farehahrahim8550
    @farehahrahim85508 ай бұрын

    The best lecture among the best. Thank you Sir 👍

  • @margad-erdeneboldbaatar4704
    @margad-erdeneboldbaatar47042 жыл бұрын

    Thanks for the this course.

  • @abhishekchaubey6046
    @abhishekchaubey60462 жыл бұрын

    Thank you sir For teaching 💯

  • @kyrieeleison7065
    @kyrieeleison70655 жыл бұрын

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

  • @sandigadzur8122
    @sandigadzur81223 жыл бұрын

    This lessons are fantastic

  • @m.irfanpirwani3064
    @m.irfanpirwani30643 жыл бұрын

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

  • @teddybulunga3393
    @teddybulunga33934 жыл бұрын

    Thank you!!

  • @Bandellacosla
    @Bandellacosla2 жыл бұрын

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

  • @mathematics_infinity_pi2779
    @mathematics_infinity_pi27793 жыл бұрын

    Really exciting

  • @manasiteliofficial3028
    @manasiteliofficial30285 күн бұрын

    Thank you 😊

  • @AnkushSharma-sz4lg
    @AnkushSharma-sz4lg5 ай бұрын

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

  • @alexanderjoe2933
    @alexanderjoe29333 жыл бұрын

    You're a life saver

  • @zain...4187
    @zain...418716 күн бұрын

    Thanks ❤️

  • @Tsukimi9
    @Tsukimi9Ай бұрын

    You're a genius❤

  • @alemameneshoa3743
    @alemameneshoa37433 жыл бұрын

    Thank you so much

  • @JeremiahCarter
    @JeremiahCarter3 жыл бұрын

    Thank You!!!

  • @PersianPartyRock
    @PersianPartyRock3 жыл бұрын

    Thank you!!!

  • @abhisheknaruka8710
    @abhisheknaruka87102 жыл бұрын

    Thank you 😁✌️👍

  • @Jaisshriram
    @Jaisshriram Жыл бұрын

    Wow well explained clappped for Sumit bansal

  • @AD-pe8mo
    @AD-pe8mo4 жыл бұрын

    Awesome.....

  • @ramachandramm5380
    @ramachandramm5380 Жыл бұрын

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

  • @Theglobalorphan
    @Theglobalorphan3 ай бұрын

    excellent

  • @pulkithanduja2428
    @pulkithanduja24284 жыл бұрын

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

  • @marymo7528
    @marymo75285 жыл бұрын

    Very good

  • @educationislove9873
    @educationislove98734 жыл бұрын

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

  • @krishnasathya5272
    @krishnasathya52724 жыл бұрын

    thank you

  • @preetisaini6963
    @preetisaini6963 Жыл бұрын

    thank you😃

  • @middleclass4137
    @middleclass41372 жыл бұрын

    Thank you sir

  • @faujiDeepakKumar-fg8vk
    @faujiDeepakKumar-fg8vk4 жыл бұрын

    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

  • @sairamvenkata1855
    @sairamvenkata18553 жыл бұрын

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

  • @itisharma4875
    @itisharma4875Ай бұрын

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

  • @kidteacher8846
    @kidteacher88463 жыл бұрын

    Fill required when we type songs in excel

  • @marcello2051
    @marcello20514 жыл бұрын

    obrigado sr indiano

  • @rameshakula4292
    @rameshakula4292 Жыл бұрын

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

  • @mohammadirkanansari671
    @mohammadirkanansari6713 жыл бұрын

    SIR YOU ARE GREATE BECOUSE YOU TEACHING SKILL IS CRYSTAL CLEAT

  • @aminsaiyed1089
    @aminsaiyed10892 жыл бұрын

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

  • @priteshpatel7682
    @priteshpatel76823 жыл бұрын

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

  • @ARIFSAIFIFARHAN
    @ARIFSAIFIFARHAN3 жыл бұрын

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

  • @sohailahmad7363
    @sohailahmad73637 ай бұрын

    how to draw table plz

  • @Kashifnasir89
    @Kashifnasir894 ай бұрын

    please enable captions

  • @Shree8140
    @Shree81402 ай бұрын

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

  • @trumpexcel

    @trumpexcel

    2 ай бұрын

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

  • @kartheekpanuku3376
    @kartheekpanuku3376 Жыл бұрын

    files to practice

  • @Prasantkumar2064
    @Prasantkumar20642 жыл бұрын

    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

  • @fayazmuhammad5983
    @fayazmuhammad59833 жыл бұрын

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

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

    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
    @mohammadirkanansari6713 жыл бұрын

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

  • @RahulKumar-pw8tg
    @RahulKumar-pw8tg Жыл бұрын

    👏👏👏🙏🙏🙏

  • @anupkumarsingh476
    @anupkumarsingh4764 жыл бұрын

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

  • @varshagupta866
    @varshagupta8664 жыл бұрын

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

  • @trumpexcel

    @trumpexcel

    4 жыл бұрын

    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

    @heeyaboruah9226

    3 жыл бұрын

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

  • @yuvrajahuja1857
    @yuvrajahuja18572 жыл бұрын

    Thanks Sir