[FREE Excel Course] Lesson 2 - Data Entry, Editing, and Number Formatting
ฝัง
- เผยแพร่เมื่อ 25 มิ.ย. 2024
- This video covers the basics of Data Entry, editing as well as number formatting.
Once you know are comfortable with the layout of Excel, the next step is to learn how to enter and edit data in Excel.
You can enter three types of data in Excel - numeric, text, and formulas.
To enter data in any cell, just select the cell and start typing. Once done, press the enter key to move to the cell below. In case you are entering dates, enter it in a format that Excel recognizes as a date (such as 01-01-2020 or 01 Jan 2020 or 01/01/2020).
This video will show you how to enter data in Excel and edit already added data (such as deleting data, modifying existing data and replacing data).
Apart from this, it also covers the auto-fill in Excel as well as number formatting.
☕ 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 TH-cam 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: th-cam.com/users/trumpexc...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
![[FREE EXCEL COURSE] Lesson 3 - Data Formatting in Excel](http://i.ytimg.com/vi/1LgkR1R1ACU/mqdefault.jpg)
![[FREE EXCEL COURSE] Lesson 3 - Data Formatting in Excel](/img/tr.png)
![[FREE EXCEL COURSE] Lesson 4 - Working with Cells and Ranges](http://i.ytimg.com/vi/B16UleW3uUM/mqdefault.jpg)
Watching this in 2023, and I still find it quite helpful. Thank you.
Hey bro, I am watching this in 2024
@@__ya_z2917 ME IN 2024
ME IN 2025
Watching it in 2026
he recorded it in 2014 posted in 2019 me watching it in 2022 !
😂😂😂😂 I am watching today 10 Nov 2023
Me watching it today 11th November 2023
Watching at 23
Me watching at 15 nov2023 10:24 PM
2023😊❤
Hi Sumit.. thanks. Even though I've been using EXCEL for years, I always pick up new tips and tricks watching your videos. Thanks for offering this course for free. Thumbs up!
few days ago decided to become a data analyst.. n from here i have started my journey...thank you thank you so much
I'm too thinking of becoming data analyst
I think this is the most comprehensive excel training channels in YT...it's got everything that I wanted! excellent work!
Thank you so much for producing and sharing this Free Excel course; I've been using Excel for years, all self taught to learn more of the many features Excel has. Now I have time during this Covid-19 Pandemic, so I will take the opportunity to learn Excel. Thank you so much.
I stumbled upon your course after several searching... I have no idea about Excel even 1% plus numbers really scare me... But knowing Excel is a basic knowledge for any corporate job these days...Thank you for really teaching it from scratch I finally could start understanding excel I hope I can atleast have a doable grasp of it at the end of this course. Subscribed! Need more real educators like u.
I really like your EXCEL tutorial videos, they are just organised and well planned. However, a video tutorial on pivot tables and dashboard will be highly appreciated. Thank you
Thank you so much for educating about excel in such a easy and detailed way! Indeed very much helpful and appreciated.
Thank you so much for these videos. Your generosity and time are very much appreciated!
Though I have gone through your first video in this series yet I found it very helpful and very well explained. Thanks for your work, I will go through to all.
Thank you so much for sharing the knowledge in clear and concise way.
Wow, thanks for the free excel tutorial videos. These really help a lot. Especially to me who's applying for a job now and I already forgot the excel thing since we use several systems now.
Thanks once again, particularly for " Introduction to Number formatting" . I found this part very useful. Best regards
Hello Sumit, thank you for putting these free classes on YT. Its such a refresher for me. God Bless
Thank you for this free course.Really grateful ❤️
This is pure gold! Thank you so much for giving away your hard work for free. God bless you my friend.
You're a life saver, man.
Thank you for the great work
Thank you so much for these free classes. Helping a lot.
Wow! Thanks so much for your lovely videos, really appreciated
Thanks for offering this course for free. Thumbs up!
Thank you Mr. Sumit. I am learning very well. Also receiving regular emails on Excel learning. Keep it up.
you're doing a great job! I appreciate it
Sir Your dedication is Realy Awesome 🙌🙌
Thank you so much man .. I’m learning a lot watching this series .. Much love brother
Glad you found the video useful!
Thank you Sumit for sharing such valuable videos.
Really very good Information and the way teaching Is very understandable .......Thanks a lot
Thank you so much, I appreciate your efforts 😁✌️👍
Your video is very useful. Thanks a lot
Thank you for this course!
Thanks a lot sir for offering it for free
Thanks💛
really appreciate this
Thank you very much for this informative video.
I want to become a successful data analyst and looking for a job as data analyst .....this tutorial is very helpful for me......soon i shall get a good opportunity
Learning at 0.8 speed, thank you very much!
hey Sumit, just want to say thank you so much for these videos, they are excellent! I will be buying you several coffees once i get a new job lol
Really helpful sumit thanks for videos
You are A Rockstar sir Thanks for Tutorials 👍🙏
It's an useful information for beginners
Tnq Trump Excel for giving wonderful video
Hi Sumit, thanks For Explain In very Easy Way
You have done an excellent job in thoroughly explaining everything. Do you have any practice projects for us to practice the skills we have learned.?
Thank u for this great work ❤️
Hi Sumit
thank you very much. It was helpful.
excellent vedios great for yours efforts .
God Bless You Brother!💙
Excellent explanation thanks alot
Thanks for the this course.
Thank you so much 😁✌️👍
thanks Mr. sumit
Very nicely planned videos :)
great way to learn
Brilliant work
Thanks a lot sir
I find it interesting to figure out which features Open office (what i'm using) doesn't have as I go through this series.
Ty sir for free classes
thank you Sumit!!!
youtube.com/@memissham?si=rE00Wfkp3Ui8r2e2
Thanks brother
THANSKYOU SO MUCH SIR !!!
What a Video!
Thank you
This is great ASMR
thank you
thank you 👌
thank u sir
Nice.....
Thank you so much can you give a online class
Good video
mine f2 is for volume down .i tried with contolf2 as well. using excel 2016 corei3
watching this in 2024 and its helpful
Thank you for this video but mine shorcut keyboard CTRL + 1 does not work, what can i do? Thank you
Hi, I need help on tutorial of how to paste down bundle of jpg pic in folder with numbering eg 001-1000 into excel columns following the rows n numbers
How can i enable the autofill option
sir in numeric data 100 gets copied down to remaining cells instead of 100,200, at 13:18
If anyone reading this comment I need some advice,first how should in practice the things that I've learned from the video?should I watch same video for more than once for better understanding?and i think I should make notes of the stuffs to get easy access if I forget something so how should I make the notes?
Where can I get the basic to advance PowerPoint course?
Hii sumit i watch this video a long date format is not working properly is this aval or not
This is when you realize excell is not just storing data inside a box.
Hi I am using excel from a years...I have started learning from your course and its really very good content.... I just want to ask you that is this course consider completely Advance course or is there any other things that we need to learn... will wait for reply
well there's more to learn and this series doens't completely teach you 100% so keep learning from other sources or books.
Thank U Sumit for your beautiful video.. May Allah bless you.. how can I get u a cup of coffee? Greetings from Bahrain
my excel is copying the same number and not floowing the pattern like if i write 100 then 200 than drag it below so it is copying 100 in all the cells.....what to do?????
following*
14:35
Date 7 dec 2023❤
Me watching the video in June 2024
How to increase the width of column when m using laptop ?
Have a look at this - trumpexcel.com/autofit-excel/
Thnku sir ...understood now with this link...
Sir another problem came to me is that auto fill option for months as u have done its not operating on my laptop..y so?
@@trumpexcel Hi sir this is amazing but is there somewhere or any website in hindi langauge Please elt me know i am waiting
More advertisment please
Can I have this course and get certificate?
no certificate but great learning
how your excel is having so much ribbon and tabs
He made his own customisations
2024 walo like karo😂😂
youtube.com/@memissham?si=rE00Wfkp3Ui8r2e2
❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤
youtube.com/@memissham?si=rE00Wfkp3Ui8r2e2
Hi Sumit , I am from Arctik Circle, an educational start up, I really like your course here .Please revert for business opportunity.
you recorded it in 2014 and posted it on youtube in 2019.
true
Hi Sumit, thank you for this video. It is really helpful.
thank you
Thank u sir
Thanks Sir
Thanks Sir
Thanks Sir