Excel 2019 Beginner Tutorial

Excel 2019 Beginner Tutorial

Get Ad-Free Training by becoming a member today!

Who it's for: Beginners - experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel.

What it is: Microsoft’s spreadsheet application used to clean and organize data.

What you'll learn: We start with the basics, showing you the user interface and quick ways to navigate. Once you’re comfortable with the software’s layout, we quickly move on to calculating data with basic formulas and functions. In the Advanced section, we show you the various tools and ways to sort and filter data in a timely manner. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Expert training starts with basic functions like the IF function. After that, we explore complex Database functions, provide an introduction to Macros, and show you how to save time by automating common Excel tasks.

For ad free training and certificates please join Learnit Anytime:

Enroll in our live, instructor-led Excel classes:

For Private Group Trainings please visit:

Start 0:00
Introduction 0:03
Start Screen & Templates 0:59
Ribbon & Quick Access Toolbar 6:04
Backstage View 12:44
Smart Lookup & Tell Me 15:33
Interface 18:49
Navigation 22:36
Keyboard Shortcuts 26:03
Entering Text 30:18
Number Formats 36:08
Deleting & Formatting 40:20
AutoSum 44:55:01
Simple Formulas 49:29
Simple Functions (Part 1) 52:57
Simple Functions (Part 2) 59:18
Absolute Referencing 1:03:01
Moving & Copying Data 1:09:15
Inserting Rows & Columns 1:12:16
AutoFill 1:16:57
Cell Styles 1:22:52
Worksheet Themes 1:27:26
Excel Templates 1:32:40
Freeze Panes 1:35:39
Grouping Worksheets 1:41:01
Page Layout View 1:43:56
Custom Views 1:45:54
Spell Check 1:48:13
Printing 1:49:58

#Excel

(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

[yuniol]

D1: Entering Text 30:18
D2: Deleting & Formatting 40:20
D3: Absolute Referencing 1:03:01
D4: AutoFill 1:16:57
D5: Excel Templates 1:32:40
D6: Printing 1:49:58
D7: To go over

[dodgeable]

Thank you SO much for this excellent tutorial. I'm not exactly a numbers person so this vid really helped me understand a spreadsheet I've been having trouble with. Your teaching method is very clear, and easy to learn from. Your voice is pleasing to listen to, with no distracting hesitations, pauses or mannerisms. Better than other tutorials I've tried. I'm going to try the Advanced Tutorial now.

[nlading]

Just keep in mind at approximately 1:16:00 when you are describing the find and replace for blank cells, if you replace blanks with zeros that will impact your cells with descriptive stats formulas (average, min, max, count, etc.). If you replace blanks with a dash or "blank" those cells will not be impacted.

[johnnog]

I’ve been using excel for a while, but this is an excellent vid to relearn how to do tasks in new and more efficient ways.

[kellybell]

This is an excellent tutorial. Not everyone is capable of teaching. It takes an innate talent to be able to teach effectively. The person narrating and instructing in this video and the other Excel tutorials is a natural born teacher. Excellent!

[Seb]

I'm just going to do a little checklist of where I left the video so...
Day #1: 18:49
Day #2: 44:54
Day #4: 1:09:15
Day #6: 1:32:40
Day #7: 1:53:15 (Finished :D)

Thank you so much for this Tutorial! ❤️ I'll keep with the next one now.

[kingkong]

Thanks a ton. Learned a lot. Just saw you have intermediate, advanced, power user and pivot table videos too. For people that take it upon themselves to learn or may not have the means to afford traditional education, your material is priceless.

[vickijohnson]

Thank You! As an old beginner, I have been mesmerized by your tutorial, ease of understanding, Calmness of voice and careful use of your cursor. You, sir, have blown my mind!

[leilaakbari]

Thanks a million for sharing this complete prefect video.
I learned alot totaly free. You made my day because I was searching for such tutorial. Good job🙏💙

[tracyross]

I've taken several tutorials on Excel. This by far is the best one. It's extremely thorough!

[andrewhunt]

Thank you so much for this terrific and FREE video. You have a perfect voice for what you do. It's super easy to follow and understand. Thank you again!

[alexblance]

It's a great help. Now I know how to use my Excel 2019. I really appreciate your tutorial, it's very clear and easy to follow. That saves me a lot of time learning it in the fastest way. Thank you!

[techfun]

im starting to love using excel since watching this tut vid thnx a lot dude

[chestchirecateyes]

Thank you for this!! I spent two weeks in a course trying to learn this material, but I couldn't make heads or tails of it, and in one sitting, with this tutorial, I was able to learn the beginner's level of the course!
The Instructor is not only knowledgeable, his voice and tone are not off-putting!! -:)
Most people don't realize how much of a difference that makes to some learners, especially as we're all attempting to learn the new normal of learning remotely.
Again, thank you so much!!!

[kayl]

This video is EXCELLENT! I am a basic Excel user but I’m trying to become more advanced so this video is just what I needed. The way you explain everything is so clear and concise—I love your teaching style! Thanks!

[lowvoltageghost]

Very Professional way of teaching.
I have learned lots of new shortcuts to become more efficient.
Thank you.

[arunshinde]

This tutorial is for beginners. However, when I went through it I learned some wonderful tricks and tips which are very useful in our routine life. Definitely, its value addition in our knowledge. The tutorial is very well planned and narrated through out the session. I suggest, even if you are not a beginner, you will learn some amazing tricks.

[jacobm]

this guy is absolutely amazing at teaching

[ibraheemahmad]

Are you looking for a comprehensive video on excel? This is where to go. The tutor really took good care of the beginners and went well from the beginning to the end. Thanks and keep up the good work.

[anthonyyung]

Thanks a lot for your course on excel as it enable to strengthen my understanding about how to use excel in my daily job. Thanks again for your teaching and patience.