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