Microsoft Excel Tutorial: 3-Hour MS Excel 2019 Course for Beginners!
Вставка
- Опубліковано 16 лип 2024
- In this mega, 3-hour long Excel 2019 tutorial for beginners, you'll start on your journey towards Excel mastery. This Excel tutorial packs in so much content, including, getting started with Excel formulas and functions, how dates and time work in Excel, how to print the pages you want to print in Excel, working with ranges in Excel, working with larger files in Excel, freeze panes in Excel, loads of information about formulas in Excel, and so much more. By the end of this Excel tutorial, you'll be well on your way to mastering spreadsheets.
If you've never used Excel before, or the thought of a spreadsheet makes you nervous, then this Excel crash course packed full of Excel tips and tricks is the place to start.
✅ This Excel tutorial also includes follow-along exercises that you can download below! ➡️
www.simonsezit.com/excel-2019...
Note: This Excel course is also suitable for Excel 365, 2016, and 2013 users.
📝Tutorial Markers:
0:00:00 - Intro to Excel
0:01:09 - What's New In Excel 2019
0:09:01 - Course Overview
0:10:18 - Overview of the Excel window
0:18:44 - Mouse-Features
0:21:57 - Backstage View
0:24:35 - Entering Text and Numbers in Excel
0:29:06 - Creating Basic Formulas in Excel
0:35:56 - Relative References in Excel
0:38:57 - Order of Operations in Excel
0:43:45 - Working with Ranges in Excel
0:48:22 - Module 2 - Practice Exercise
0:49:56 - Working with the Save and Save As Commands
0:54:31 - File Extensions, Share, Export and Publish Files
0:58:36 - Module 3 - Practice Exercise
0:59:34 - Opening a File in Excel
1:05:06 - Working with Larger Files in Excel
1:10:41 - Freeze Panes in Excel
1:13:57 - Split Screen in Excel
1:21:03 - Module 4 Exercise
1:23:51 - Headers and Footers in Excel
1:31:15 - Print Titles
1:34:07 - Comments in Excel
1:39:31 - Page Setup Options in Excel
1:47:01 - Fit to Print on One Page in Excel
1:51:00 - Printing Workbooks in Excel
1:54:56 - Module 5 Exercise
1:56:49 - Adding and Deleting Columns and Cells
2:03:00 - Changing Column and Rows Widths
2:06:49 - Module 6 Exercise
2:07:58 - Copt, Cut and Paste
2:15:06 - Copying Formulas
2:20:18 - Module 7 Exercise
2:21:36 - Overview of Formulas
2:24:24 - Create Formulas Using Functions part1
2:34:28 - Create Formulas Using Functions part2
2:39:53 - Absolute Values
2:45:12 - Module 8 Exercise
2:46:30 - Adding Deleting and Renaming Sheets
2:50:38 - Additional Sheet Tab Options
2:55:58 - 3 Dimensional Formulas
3:01:29 - Module 9 Exercise
These tutorials were taken from the full-length Simon Sez IT class
bit.ly/3eVSKmb
Get the free MS Excel 2019 course exercise files and complete the exercises here ⏩ www.simonsezit.com/excel-2019...
🔥Need training for Excel 2021/365? Check out our free 10-hour training course on UA-cam ➡️ • Excel 2021/365 Beginne...
🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a a free 30 day trial to our complete training library of 8,500+ video ⏩ www.simonsezit.com/ssit-first...
Looking for Excel tricks or Excel tutoring? Check out our Excel 2021 tutorials for intermediate users playlist here:
👉 • Excel 2021 Tutorials f...
🔥Check out our FREE 300+ hour training course playlist here 👉
• Simon Sez IT Long Trai...
🚀 Level up your Excel skills with free training here 👉 • Microsoft Excel Tips a... & here 👉 • Microsoft Excel Traini...
& Pivot Table training here 👉 • How to Use Pivot Table...
💻Watch additional popular Microsoft Office tutorials from Simon Sez IT:
✅ Excel 2021 tutorials for intermediate users playlist here:👉 • Excel 2021 Tutorials f...
✅ Ultimate Microsoft Office Course (12-Hour Course for Beginners):👉 • Microsoft Office Tutor...
✅ Microsoft Excel 2021/365 Tutorial (4.5+ Hours Beginner Course)👉
• Microsoft Excel Tutori...
✅ Advanced PowerPoint Hacks (1-Hour Webinar Tutorial)👉 • Advanced PowerPoint Ha...
✅Learn PivotTables in 1 Hour (Excel Crash Course)👉 • Pivot Table Tutorial -...
💬Stay in touch!
✅SimonSezIT.com: 👉www.SimonSezIT.com/
✅StreamSkill.com: 👉StreamSkill.com/
✅UA-cam Channel: 👉 / simonsezittraining
✅LinkedIn: 👉 / simon-sez-it
Please SUBSCRIBE 🔔 ua-cam.com/users/simonsezittra...
♥️ We appreciate your support!
#SimonSezIT #Excel - Наука та технологія
Reminder to the eyes that see this: You are capable and you are alive! Keep asking questions and moving in actionable goals. Put forth the work and keep the fire alive. Thanks for the great refresher Cindy!
Thanks for watching Anthony!
This was super excellent for me shooting me into another next level in Microsoft Excel . Thank u so much for ur kind patient explanatory way of expression ,I love it & I equally love u too 😍🥰🤝
Lord help me- I cannot sleep- I have seen many tutorials but never this in-depth. I absolutely love this- super excited it is 02:56 am and I'm moving on to module 10
!
Where did u learn other modules
That’s awesome! 😊 I too have viewed many tutorials understand the complexity of it all. Happy Excel learning 👍
This is a fantastic tutorial... the procession through the various lessons and exercises are structure exceptionally well. Couldn't have spent a more pleasurable time learning Excel. Keep up the excellent work.
You're very welcome! I'm delighted to hear that you enjoyed it!
This is by far one of the best tutorials, I needed to brush up on my excel skills, for work, and this 3 hour training was everything, very easy to follow and Cindy did her thing, explaining each module in a manageable way for someone that works with
excel but not on a everyday basis. Once again, thank you kindly, Cindy, and Simon for this outstanding tutorial.
Thank you for the kind comments, Ana. We'll let Cindy know. If you need additional Excel training, we have additional videos in one Excel playlist here ➡️ ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
Probably the best Excel course for beginners on YT. I really enjoyed going through this tutorial. I'm truly grateful that you offer such content for free. Thank you!
Great to hear!
Excellent 👍👍👍 in-depth tutorial. I have gone through many Excel tutorials but none were so intuitively structured nor were the explanations so in-depth while being easy to comprehend. Really appreciate the effort put in by the instructor Cindy 🙏🙏. I would highly recommend anyone willing to engage with Excel in a meaningful way to go through the tutorials in this channel.
Keep up the good work 👌👌
Thank you for reviewing the tutorial Shibasis. I really appreciate that you've left a detailed review and I'm pleased that you've enjoyed and recommended our channel!
This is beyond what i could have imagined.the lesson is so well structure and the voice encourages you to want more and more. i am learning so much. Thank you so much for this, May God continue to bless you as you provide to us.
You're very welcome Philicia, I'm very pleased that you were able to benefit from the Microsoft Excel Tutorial. Stay safe!
Thank you Cindy. This is a great start to anyone who uses Excel. This is one of the best and thorough Excel course on the internet. I have taken few paid courses and this free course beats them all!!
You're very welcome! I'm delighted that you've enjoyed the course!
Definitely understood and was able to follow at the same time with my own spreadsheet. Excellent tutorial. You made it so much easier by pacing yourself so we can follow you without missing anything. Thank you. Next step Power Query.
Love it! I have been using Excel for 20 years and now I realize I had no idea what I was doing. Thanks!
You're very welcome!
by far the best tutorial and I have gone through many. Perfect pace and structure.
Stumbled across this video. Love the organization and ease to jump to topic. I was looking how to calculate or create a formula for hours * rate. My sheet has hours listed (0.75h) and rate $20. I tried following the example in Mod 7 part 2 and I'm not having luck with the downloaded CSV file. You are definitely gifted to be an instructor! Great tone, easy to listen and follow.
Thanks so much for this very educational, engaging and enjoyable video. Learnt so much in addition to the little I knew previously. Cindy, you are excellent in your delivery. Thank you
Thank you Olajumoke!
Excellent! I didn’t know anything about Excel and it scared the livin’ bejeezits out of me before your course. Now, makes sense and appears doable! Still, I have much to review, and I’m learning on a Mac so I had to search a bit more for some of items. Found them, but it took a bit longer. Big thanks for your clear style, presentation and lovely voice.
What a great presentation! Thank you so much for putting this course together! Do you have any Excel tutorials for the level after this one?
Oh lord, The way you explain it is absolutely clear and help me to understand it easily.Thank you !
Definitely changed my game. Excellent tutorials! Working much better in Excel. Thank you.
Great to hear!
Very detailed, very simple, and very informative!!!! This will definitely help me get all of my "stuff" organized. Thank you so much and God Bless you.
Glad it was helpful!
THANK YOU! I have been wanting to know how to do 3-dimensional formulas! This was an excellent lesson for Excel!
I have started with this course and found very helpful , especially the worksheets provided for practicing is very very useful ..THANK YOU
Thank you 😊
Cindy, thanks for this tutorial. It's a great refresher. I like that I'm learning the why along with the how. The pace is good and the rate of speech is good, too. I don't have to stop and rewind to figure out what was said or demonstrated.
You’re welcome, I’m pleased to hear that you were able to make the most of the tutorial!
Thanks
Thank you sir for this great revision. Since 2015 I have never sit to do this exercise again
Thank you for the help to refresh my memory on Excel, along with what I did not know. Good job thanks again.
She is very good and perfect for a beginner. I’m happy to learn some basics that I can understand what I have to deal with at work on sheets pre done but have to do ok it tables.
Thank you Cindy, what a powerful presentation,a game changer
Glad it was helpful!
I cant believe how easy it is to follow and keep up. You seriously have a gift for teaching. I am in college and you are better then my professor. Thank you soooo much
Yeah it is so clear that I could understand most parts even at 2x
Thank you for the help with Excel. I am feeling much more fluent and confident in the program. This video was very helpful. Thank you again.
Thanks Lucie, I’m pleased to hear that the course was helpful to you!
This course has been a delight to watch and follow along. I have never had such teachings taught in a way even a child in elementary would comprehend. Thank you so much! :)
Wow, thank you!
great content love the excercise files thank you
I really like this video, I teach Excel so I shared this tutorial with my students and it really helped. Thank you.
You're very welcome! Thanks for taking the time to comment
Definitely a course for advanced users, sort of refreshing
It is always a great a idea to go back and refresh. Very detailed and helpful! Thanks a million!
You're so welcome!
This was a very helpful tutorial, it help me remember some of the functions and showed me some I did not know about.
Thank you Dunia! 😃
)
Great course! The only recommendation I have is to have the yellow area around the pointer either more transparent or eliminate it and use a colored pointer only. I am a visual learner and could not see under the yellow coloring. Thank you for the course.
Thanks for the feedback Linda, Delighted that you've enjoyed the course!
Make it transparent or change the color but please don’t remove it. Being visual I look for courses with this attribute. Btw, great course.
Thank you so much . God bless you in all the details of your life. Amen
Thanks. Same to you!
@@SimonSezIT Thanks!
Hi Cindy! Your delivery is amazing!
Thank you Esther, I appreciate you leaving a comment!
OMG I love this channel. I started a new job as a Project coordinator and these tutorials are a god send. Thank you so much team you are amazing. The step by step guide is on point.
Thanks Jenny! I’m delighted to hear how the tutorial’s are helpful! Keep watching! 🙂
Clear voice, clear step by step easy taught process. Detailed video. Practice sheets. I would give 5 stars
Thanks a lot 😊
I'm about 2/3 of the way finished with this tutorial and I've been very happy so far. I feel it is on the same level as a Udemy course, but free😀 Thank you.
Glad it helped, Kurt. We also have 4+ hour tutorials for Excel 2021/365 beginner, and intermediate level here: ua-cam.com/play/PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j.html
The way you explain it is absolutely clear
Thanks you Sarath!
This is a very informative tutorial, by the way Mrs. Cindy has a very soothing and sweet voice.
Thank you kindly!
@@SimonSezIT l⁰0p
Wow thank you so much for this video and I admire your effort wish you all the best 👍
Thank you so much Sultan🙂
Thank you so much for this and the files!!! truly grateful:)
You're very welcome!
Thank you for the excellent instruction!
Giiiirl You are an angle from heaven. I watching all your videos lol.
Thanks Johan!
Thanks for providing such an awesome tutorial!
Thanks for watching Tung 🤗
Brilliant. So clear and easy to understand. The best tutorial on this subject.
Wow, thanks for nice comments!
Excellent, detailed tutorial, thank you!
You’re welcome Mansoureh!😁
i have no words to thank you🖤
I’m glad it helped!
Thanks Cindy for your clear and lovely tutorial
Glad it was helpful!
Great tut, pleasant voice-over, +10!
Thank you!
You are the best. Dont stop doing that:) Thank you.
Thank you for uploading this helpful video alongside with an excel file for practice! From 🇧🇩
You are welcome!
very good will watch it again
Thank you for this great tutorial (:
No problem 😊
Thanks brother, it worked!! I watched many video but only this worked!! I am very thankful to you!.
You are welcome. We appreciate your comments!
Thanks for all your efforts. I found it very useful.
That’s great to hear Neha, thanks
thanks very much , that was excellent
What a amazing tutorial! She is really one of the best in town 👏👏👏
Glad it was helpful, Riva :-)
Cindy, you are a great instructor. Thank you 💕
Thank you so much!
I cannot say how helpful is this.. Thanks a lot....
Glad it was helpful!
Thanks for the great tutorial.
You are welcome Robert!
Thank you so so much for this!
You're very welcome!
You are blessed as you prove for us so will God provide for you, I am not ungrateful human
Thanks Kalvin
Thank you, Cindy - I have always hated and feared Excel, because of the terrible things it has done to me! Now that I've decided to bite on a bullet and make a spreadsheet, you are a godsend!
Thanks for watching!
great tutorial, thank you.
You are welcome!
I want to thank you 😊. You have made this easy for me. I understand so much now.
I'm so glad!
This as a great refresher course for me. Thank you for offering it for free! On to the next tutorial
7y
7
6
7
7
fantastic tutorial!
Great course! i love it. Thank you for hard work.
You are very welcome! Glad it was helpful. 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Thank you for great tutorial. It's very useful for me. Blessings.
Glad it was helpful!
This is a great video! Thank you soo very much!!! :-)
Thank you for sharing this knowledge, excellent tutorial, very clear and simplified.
Glad it was helpful!
I could have lost my job .. You are my savior , thank you. Love from India
Glad it was helpful!
thanks for the information and the lesson very informative
Glad it was helpful!
This was very helpful, very well explained.
Glad it was helpful!
Your channel is simply amazing.
Thank you, glad to hear you’re enjoying it!
This the best excel tutorial I ever watched please I need link to module Ten ASAP
very helpful, thank you so much
Glad it was helpful!
Such a great tutorials. I have learnt a lot. Many thanks
You are welcome! Thanks for watching ;-)
Thank you, i realy understood your teaching.
You are welcome!
great job concise and highly educational
Why thank you!
What i need to understand the most, analyzing data on measures of central tendency
Good course for very first time !
Glad you think so Mehrad!
it is really a nice tutorials, thanks for the video
I'm glad you enjoyed the Microsoft Excel 2019 Tutorial!
Great video
The explanation is very nice and helpful
Thank you Fatima, much appreciated
Great class.
Keep up the good work.
Thank You,
Natasha Samuel
Thank you! 😃
Thanks you for the incredible contents
Glad you like them! 😀
SUPER HELPFUL THANKYOU
So glad!
This is very helpful and easy to follow
Glad you think so Ann!
Wonderful ❤️❤️
Thank you for this great Course it really helpful
You're very welcome!
This amazing!
Delighted that you think so!
Awesome content and explanation. I love it 👍
Glad you liked it, Red 🙂 We have additional Excel training here ➡️ ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
Best tutorial ever
You are best Excel Teacher ❤️
Thank you!
Thank you for sharing!
My pleasure!
Thank you!