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 formulas in Excel, how dates and time work in Excel, how to print the pages you want to print in Excel, and so much more. By the end of this Excel tutorial, you'll be well on your way to mastering spreadsheets.
This tutorial also includes follow-along exercises that you can download below!
Get the free MS Excel 2019 course exercise files and complete the exercises here ► https://www.simonsezit.com/excel-2019-course-exercise-files/
Note: This 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 Option
1:13:57 - Split Screen Option
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. See all the Beginner to Expert courses on Simon Sez IT here ► https://www.simonsezit.com/course-category/excel/
Click below to download the follow-along exercise files so you can make the most of this awesome free Excel course.
https://www.simonsezit.com/excel-2019-course-exercise-files/
Check out more popular MS Office tutorials from Simon Sez IT:
- 6-Hour Microsoft Excel Crash Course: https://youtu.be/sM0Lldwt7iA
- How to Add video to Microsoft PowerPoint: https://youtu.be/yvWv1bk6mu8
- Learn PivotTables in One Hour: https://youtu.be/2RKw-HGCLB0
- Microsoft Project 2016 Tutorial for Beginners: https://youtu.be/lWmP0kReXkQ
Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
If you enjoyed the video, please give a "thumbs up," leave some comments and subscribe to the channel ;-)
Видео Microsoft Excel Tutorial: 3-Hour MS Excel 2019 Course for Beginners! канала Simon Sez IT
This tutorial also includes follow-along exercises that you can download below!
Get the free MS Excel 2019 course exercise files and complete the exercises here ► https://www.simonsezit.com/excel-2019-course-exercise-files/
Note: This 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 Option
1:13:57 - Split Screen Option
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. See all the Beginner to Expert courses on Simon Sez IT here ► https://www.simonsezit.com/course-category/excel/
Click below to download the follow-along exercise files so you can make the most of this awesome free Excel course.
https://www.simonsezit.com/excel-2019-course-exercise-files/
Check out more popular MS Office tutorials from Simon Sez IT:
- 6-Hour Microsoft Excel Crash Course: https://youtu.be/sM0Lldwt7iA
- How to Add video to Microsoft PowerPoint: https://youtu.be/yvWv1bk6mu8
- Learn PivotTables in One Hour: https://youtu.be/2RKw-HGCLB0
- Microsoft Project 2016 Tutorial for Beginners: https://youtu.be/lWmP0kReXkQ
Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
If you enjoyed the video, please give a "thumbs up," leave some comments and subscribe to the channel ;-)
Видео Microsoft Excel Tutorial: 3-Hour MS Excel 2019 Course for Beginners! канала Simon Sez IT
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
50 Ultimate Excel Tips and Tricks for 2020Excel 2019 Beginner TutorialMicrosoft Outlook Tutorial (2019/365): 3+ Hour Getting Started in Microsoft Outlook 2019 Class!PowerPoint Tutorial: 3-Hour PowerPoint Intro Course - How To Use PowerPoint 2019The Ultimate MS Excel Crash Course: 6-Hour Microsoft Excel 2016 Tutorial for BeginnersMS Excel - Pivot Table Example 1How to Pass Excel Assessment Test For Job Applications - Step by Step Tutorial with XLSX work filesExcel How-To: Starting a Basic SpreadsheetWord Beginner TutorialExcel for Accounting: Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, KeyboardsMicrosoft Excel Tutorial - Beginners Level 1Excel Basics 1: Introduction To Excel 1: Formatting, Formulas, Cell References, Page SetupExcel 2019 Expert TutorialAdvanced Pivot Tables Tutorial in Excel - 2.5 Hour Pivot Table Excel CourseAdvanced Excel Tutorial: Advanced Functions Course (VLOOKUP, IF, Forecasting, Statistical)Power BI Beginner TutorialExcel VBA Expert TutorialGetting Started in Microsoft Word 2019/365: Microsoft Word TutorialExcel 2019 Pivot Tables Tutorial