[FREE EXCEL COURSE] Lesson 3 - Data Formatting in Excel
Вставка
- Опубліковано 5 лют 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 UA-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
![[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)
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!
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 🙏
It is excellent and interesting to learn new things about Excel.
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.
It's so value for finding this channel
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.
Great,
Hats off your teaching style is best.
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.
Double click format painter trick was something new for me. Thanks a lot...
Thank you for making video on excel in an understable manner.
Deserve 100k so simple and easy to understand and apply
Just amazed how good you teach, fascinating 🔥🔥
Thank you for the kind words 😊
WOW. Nice shortcuts. Great effort from your side. Thank you.
This is amazing. You saved my money. And easily making us understand everything. Thank you so much.
Very useful video. Every thing is in detailed. Thank you so much
Hi Sumit.. thanks.. great review.. great information. Thanks for offering this course for free. Thumbs up!
Great job on all the videos of this course! Thank you!
Glad you're finding the courses useful!
Explanation is excellent
Thank you Sumit for sharing such valuable videos.
Thanks for you time and efforts.. best teacher
Great one
Amazing work! thanks!
Just superb yaar just superb never thought i would excel in excel 😊
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 ☺☺
God bless you Sumit.. very nice video.. stay blessed ☀️🙏🌙
The content is very good .. no need to go for coaching.
The best lecture among the best. Thank you Sir 👍
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
Excellent work my friend! thanks for the great effort.
Thank you so much, such a useful channel!
Thanks for providing us this free tutorial.Very detailed and helpful ;)
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
Thanks for the this course.
This lessons are fantastic
Thank you sir
For teaching 💯
You're a genius❤
Thank you for great explanation.
Thank you 😊
great tutorial. helped me a lot.
Thank you 😁✌️👍
Wow well explained clappped for Sumit bansal
Thanks ❤️
Really exciting
You are doing a great job. Sir , how to CENTER ALIGN 2 or more cells VERTICALLY without using merge and center
Excellent explanation God bless you
You're a life saver
Amazing Tutorial Mr. Trump, along with the tutorial can you kindly say about the keyboard shortcut in your video if possible.
Thanks Sir
SIR YOU ARE GREATE BECOUSE YOU TEACHING SKILL IS CRYSTAL CLEAT
Awesome.....
excellent
Thank you so much
THANK YOU SO MUCH BROTHER
thank you😃
From where can we practice excel? Like are there any exercises that we can do? Any websites or material?
Thank you sir
Very good
Sir can u tell us assignments so we can practice after every lecture?
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 🙏
Thank you!!
thank you
Hi Sunil ji F4 shortcut is not working in my office home and student 2021..
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
files to practice
Really amazing but Pl share exercise file so that we can do pararally
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)
Fill required when we type songs in excel
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
How can I get videos for both lesson 1 and lesson 2?
Thanks for this brilliant lesson.
sir how you placed raw data and formatted data at left bottom is this sheet
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
how to draw table plz
please enable captions
obrigado sr indiano
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
Ctrl - F4 for redo
SIR IF TEACH ME CONDITIONAL FORMATTING I AM VERY THANKFUL TO YOU
👏👏👏🙏🙏🙏
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!!!