[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
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.
No hype. This teaches complex things using the most simplified method. 👌
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 .
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!
Finally found a genuine excel course. Really good and genius one👏🏻❤
Thanks a lot Sumit, for telling a feature that solved so much of my problem..."Center Across Selection"..
No need to go particularly Excel classes ,,, this is enough to learn more about excel ,, excellent explaining pont to point , well done bro
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.
WOW. Nice shortcuts. Great effort from your side. Thank you.
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.
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
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 🙏
amazing teacher .. he deserves more views ...god blesss u thnx buddy
@trumpexcel
4 жыл бұрын
Thanks for commenting Mansi... Glad you found the video useful!
I have learned more about the cell formatting in this video. Shrink to fit, ctl +1 e.t.c. thank you for sharing.
Hi Sumit.. thanks.. great review.. great information. Thanks for offering this course for free. Thumbs up!
Thanks for providing us this free tutorial.Very detailed and helpful ;)
This is amazing. You saved my money. And easily making us understand everything. Thank you so much.
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.
Double click format painter trick was something new for me. Thanks a lot...
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
Excellent work my friend! thanks for the great effort.
Very useful video. Every thing is in detailed. Thank you so much
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!
Thank you Sumit for sharing such valuable videos.
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 ☺☺
Amazing work! thanks!
Thank you for making video on excel in an understable manner.
Excellent explanation God bless you
Thank you so much, such a useful channel!
Thank you for great explanation.
God bless you Sumit.. very nice video.. stay blessed ☀️🙏🌙
Thanks for you time and efforts.. best teacher
Great job on all the videos of this course! Thank you!
@trumpexcel
3 жыл бұрын
Glad you're finding the courses useful!
Great, Hats off your teaching style is best.
It's so value for finding this channel
great tutorial. helped me a lot.
Just amazed how good you teach, fascinating 🔥🔥
@trumpexcel
5 ай бұрын
Thank you for the kind words 😊
THANK YOU SO MUCH BROTHER
The best lecture among the best. Thank you Sir 👍
Thanks for the this course.
Thank you sir For teaching 💯
How can I get videos for both lesson 1 and lesson 2? Thanks for this brilliant lesson.
This lessons are fantastic
You are doing a great job. Sir , how to CENTER ALIGN 2 or more cells VERTICALLY without using merge and center
Thank you!!
Amazing Tutorial Mr. Trump, along with the tutorial can you kindly say about the keyboard shortcut in your video if possible.
Really exciting
Thank you 😊
Just superb yaar just superb never thought i would excel in excel 😊
You're a life saver
Thanks ❤️
You're a genius❤
Thank you so much
Thank You!!!
Thank you!!!
Thank you 😁✌️👍
Wow well explained clappped for Sumit bansal
Awesome.....
Hi Sunil ji F4 shortcut is not working in my office home and student 2021..
excellent
sir how you placed raw data and formatted data at left bottom is this sheet
Very good
Sir can u tell us assignments so we can practice after every lecture?
thank you
thank you😃
Thank you sir
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
The content is very good .. no need to go for coaching.
From where can we practice excel? Like are there any exercises that we can do? Any websites or material?
Fill required when we type songs in excel
obrigado sr indiano
format brush painter for the multiple objects is not working in 2021 versions
SIR YOU ARE GREATE BECOUSE YOU TEACHING SKILL IS CRYSTAL CLEAT
i want to prepare excel sheet of daily expenses of the year 2021 how can i make? pl give me suggestion.
Really amazing but Pl share exercise file so that we can do pararally
Hello Sumit Do you provide paid session, Let me know how can I approach you
how to draw table plz
please enable captions
sir ,what shortcut you use for get back or undo data .
@trumpexcel
2 ай бұрын
Control + Z (hold the control key and then press the Z key)
files to practice
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
Sir when I orient Number instead of text I get # Sir what is the reason behind it.
@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
SIR IF TEACH ME CONDITIONAL FORMATTING I AM VERY THANKFUL TO YOU
👏👏👏🙏🙏🙏
Hi, Can you share your email if we have any doubt?
Instead of these u should hv used formula, this is totally basic 5th grade students content
@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
3 жыл бұрын
I am in 7th grade so thanks this helps me a lot because it is for me!
Thanks Sir