Microsoft Excel 365 Tutorial: 4-Hour Beginner Excel Training Course

✅Download the free demo file and follow along here ➡️https://www.simonsezit.com/excel-365-course-and-exercise-files Welcome to our comprehensive Excel 365 tutorial! In this video, we'll guide you through a detailed exploration of essential Excel features to boost your spreadsheet skills. We'll start with navigating the Excel 365 Online Portal, ensuring you can access your work from anywhere. Learn the basics of launching Excel and efficiently exploring the interface, including contextual menus and ribbons. Discover the power of the Quick Access Toolbar and essential keyboard shortcuts for a seamless workflow. Dive into Excel templates to kickstart your projects, and efficiently work with workbooks and worksheets. We'll show you how to save your work to OneDrive, ensuring collaboration is a breeze. From entering text, numbers, and dates to understanding custom lists and the order of operations, we've got you covered. Explore the fundamentals of formulas, including the 'Big 6' functions, and grasp the concepts of absolute vs. relative referencing. Streamline your calculations with quick tools like Autosum, Autofill, and Flash Fill. Uncover the benefits of named ranges, from creation to application in formulas. Enhance your data presentation with various number formats and formatting techniques for cells, rows, and columns. Learn the ins and outs of tables, including formatting as a table and referencing within formulas. Efficiently work with columns and rows while mastering text and number alignment. We'll demystify merging cells vs. centering across selections and explore the application of themes and styles for a polished spreadsheet appearance. Subscribe, like, and share if you're ready to excel in Excel! Stay tuned for more tutorials to elevate your skills. Happy learning! 📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead! Timestamps: 00:00:00 - Intro Simon Sez IT 00:00:20 - Course Introduction 00:03:59 - Excel 365 Online Portal 00:11:07 - Exercise 01 00:12:07 - Launch Excel 00:15:59 - Explore the Interface 00:25:51 - Contextual Menus and Ribbons 00:30:31 - The Quick Access Toolbar 00:37:42 - Keyboard Shortcuts 00:45:40 - Exercise 02 00:49:41 - Excel Templates 00:56:20 - Work with Workbooks and Worksheets 01:03:01 - Save Workbooks to OneDrive 01:07:49 - Enter Text, Numbers, and Dates 01:14:57 - Custom Lists 01:21:27 - Exercise 03 01:25:29 - Order of Operations 01:32:26 - A Simple Formula 01:38:59 - The 'Big 6' Functions 01:45:28 - Absolute vs Relative Referencing 01:52:55 - Quick Calculations with Autosum 01:58:32 - Autofill and Flash Fill 02:09:12 - Exercise 04 02:14:00 - What are Names Ranges? 02:17:25 - Create Named Ranges 02:21:42 - Use Named Ranges in Formulas 02:25:10 - Exercise 05 02:27:40 - Apply Number Formats 02:39:59 - Format Cells, Rows and Columns 02:53:10 - AutoFormat 02:56:49 - Find and Replace Formatting 03:03:23 - Format Painter 03:07:59 - Clear Cells 03:13:18 - Exercise 06 03:17:19 - Tables Explained 03:25:10 - Format as Table 03:37:38 - Table Reference in Formulas 03:42:30 - Exercise 07 03:45:13 - Work with Columns and Rows 03:54:33 - Align Text and Numbers 04:03:30 - Merge Cells vs Center Across Selection 04:10:27 - Apply Themes and Styles 04:18:48 - Exercise 08 ✅Download the free demo file and follow along here ➡️https://www.simonsezit.com/excel-365-course-and-exercise-files 🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ https://www.simonsezit.com/courses/ 🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 10,000+ ad-free videos and begin your transformation today! ➡️ https://simonsezit.lpages.co/ssit-14-day-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 Data Analysis using Microsoft Tools 👉 https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jiDSWwQjtVvHqT09XdYFMi ✅Microsoft Access Training video playlist 👉 https://www.youtube.com/playlist?list=PLzj7TwUeMQ3g7dabQhzlqljY-bnxv1YFA ✅ Microsoft Excel Beginner's Training here 👉 https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z ✅ Introduction to Databases Training here 👉 https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jJ9OhflqrL5huscvd0Q9Qn 💬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 👍🏽 ;-)