Microsoft Excel Tutorial: 3-Hour MS Excel 2019 Course for Beginners!

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! ➡️

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

Looking for Excel tricks or Excel tutoring? Check out our Excel 2021 tutorials for intermediate users playlist here:

🔥Check out our FREE 300+ hour training course playlist here 👉

💻Watch additional popular Microsoft Office tutorials from Simon Sez IT:

✅ Microsoft Excel 2021/365 Tutorial (4.5+ Hours Beginner Course)👉

💬Stay in touch!

♥️ We appreciate your support!

#SimonSezIT #Excel

[stevenkaufman]

I really like how you take the approach that the person viewing knows nothing. It makes it much more comfortable and easy to follow.

[anthonypacheco]

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!

[AnaRodriguez-xjlp]

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.

[xtratouch]

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.

[jamie-leeapril]

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

[shibasisbiswas]

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 👌👌

[tweetye]

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.

[jasst]

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!

[elizabeth-tuqz]

by far the best tutorial and I have gone through many. Perfect pace and structure.

[billwayzata]

Love it! I have been using Excel for 20 years and now I realize I had no idea what I was doing. Thanks!

[marshawooten]

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.

[olajumokeolaoye]

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

[JessicaRabbit-hmyy]

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.

[philiciahunte]

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.

[sillyme]

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!!

[moratanga]

Oh lord, The way you explain it is absolutely clear and help me to understand it easily.Thank you !

[dzrosesme]

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.

[ksenyat]

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?

[charlesmangezi]

Thank you Cindy, what a powerful presentation, a game changer

[hatimhmt]

great content love the excercise files thank you