Toptube Video Search Engine



Title:The Ultimate MS Excel Crash Course: 6-Hour Microsoft Excel 2016 Tutorial for Beginners
Duration:06:01:56
Viewed:484,114
Published:30-04-2019
Source:Youtube

โœ…Get FREE MS Excel 2016 course exercise and instructor data files here and follow along here: โžก๏ธ https://simonsezit.lpages.co/excel-2016-course-exercise-files/ In this mega, 6-hour long Excel 2016 tutorial for beginners, you'll finally learn how to use Microsoft Excel including Excel formulas and functions such as VLOOKUP. By the end of this Excel tutorial, you'll be well on your way to mastering spreadsheets. This Excel course is packed full of Excel tips, tricks, and hacks on how to get the most from your spreadsheets! Over 6-hours, we cover many different areas of Excel, including Excel formulas, formatting in Excel, VLOOKUP in Excel and so much more. ๐Ÿ“ Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead! - Introduction to the Excel Course and Exercise Files - 0:00 - Basics of Using the Ribbon - 2:47 - Quick Access Toolbar - 18:07 - Mini Toolbars and Contextual Menus - 24:06 - Status Bar - 27:41 - Basics of Entering and Editing Data in a Workbook - 32:43 - Exercise 01 - 46:13 - Formatting Dates - 48:03 - Formatting Numbers - 1:00:40 - Exercise 02 - 1:14:28 - Working with Fill and Series - 1:16:11 - Flash Fill - 1:25:20 - Workbook Views, Zoom, and Freeze - 1:29:25 - Printing - 1:38:06 - Exercise 03 - 1:53:05 - Methods of Cutting, Copying, and Pasting - 1:56:01 - Delete and Clear - 2:09:33 - Insert, Hide, Column Width and Row Height, and Merge - 2:23:18 - Alignment - 2:36:06 - Themes and Styles - 2:48:10 - Exercise 04 - 2:59:29 - Basics of Formulas and Functions - 3:01:14 - Complex Examples of Formulas - 3:12:29 - Exercise 05 - 3:26:35 - Managing Worksheets - 3:30:02 - Working with Multiple Workbooks -3:38:42 - Saving in Different File Types - 3:54:31 - The Spell Checker - 4:07:34 - Inserting Comments - 4:20:42 - Exercise 06 - 4:26:06 - The VLOOKUP Function - 4:29:07 - Text Functions - 4:43:14 - Date and Time Functions - 4:51:31 - Logical Functions - 4:58:19 - Creating Graphs and Charts - 5:14:10 - Customizing a Cluster Column Chart - 5:26:20 - Customizing a Pie Chart - 5:42:02 - New Chart Types in Excel 2016 - 5:55:38 - Exercise 7 - 5:58:08 ๐ŸŒ Get unlimited training with Simon Sez ITโ€™s 150+ courses โฉ https://www.simonsezit.com/courses/ ๐Ÿš€ Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos โฉ https://www.simonsezit.com/ssit-first-month-free ๐Ÿ’ป Watch more free popular training tutorials from Simon Sez IT: ๐Ÿ”ฅCheck out our FREE 300+ hour training course playlist here โžก๏ธ https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU โœ… Check out our free video playlist for Excel beginners ๐Ÿ‘‰https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gABy6lbJgp6kZtXVhadATg โœ… Pivot Table Tutorials for Beginners here ๐Ÿ‘‰https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i80FzwXA86zJOK8dtlB-qt โœ… Microsoft Excel Tips and Tricks ๐Ÿ‘‰https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc โœ… Microsoft Office 2021 and Office 365 Training here ๐Ÿ‘‰https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j ๐Ÿ’ฌStay in touch! SimonSezIT.com: https://www.SimonSezIT.com/ LinkedIn: https://www.linkedin.com/company/simon-sez-it/ FaceBook: https://www.facebook.com/SimonSezIT ๐Ÿ”” Subscribe to our channel: https://www.youtube.com/simonsezittraining?sub_confirmation=1 If you enjoyed the video, please give a thumbs up ๐Ÿ‘๐Ÿฝ ;-)



SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :