Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching Excel 2021/365 Beginners & Intermediate Training: 10-Hour Excel Tutorial Class. and this video is uploaded by Simon Sez IT at 2022-08-16T07:30:45-07:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [fODnNDNMXiI]
| Name | Excel 2021/365 Beginners & Intermediate Training: 10-Hour Excel Tutorial Class |
| Video Uploader | Video From Simon Sez IT |
| Upload Date | This Video Uploaded At 16-08-2022 14:30:45 |
| Video Discription | ✅ Download to follow along and complete the exercises ➡️https://www.simonsezit.com/excel-2021-beginner-and-intermediate-course-files/ In this Excel 2021 Beginner to Intermediate training course, go from zero to hero as we cover the basics and expand to intermediate Excel skills. We'll go over Excel logical IF functions, Excel lookup functions such as VLOOKUP and XLOOKUP, importing data into Excel, formatting, and so much more! We've even included downloadable exercise files from our paid-for course, which means you can complete the exercises in this Microsoft Excel 2021 Tutorial and put what you are learning into practice. This will help you master the various Excel tips and tricks taught. ✅https://www.simonsezit.com/excel-2021-beginner-and-intermediate-course-files/ 📝Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead! 00:00:00 - Introduction 00:00:22 - Course Intro 00:02:42 - Excel 2021 vs Excel 365 00:08:21 - Launching Excel 00:12:00 - The Start Screen 00:22:12 - Exploring the Interface 00:33:51 - Ribbons, Tabs and Menus 00:42:20 - Backstage Area 00:47:00 - Quick Access Toolbar 00:56:45 - Useful Keyboard Shortcuts 01:06:27 - Getting Help 01:13:04 - Exercise 01 01:15:27 - Working with Templates 01:24:30 - Workbooks and Worksheets 01:32:04 - Saving Workbooks 01:40:50 - Entering and Editing Data 01:50:43 - Navigating and Selecting Cells, Rows and Columns 01:58:02 - Exercise 02 02:03:22 - Formulas and Functions Explained 02:15:06 - SUM Function 02:22:44 - COUNT Function 02:30:10 - AVERAGE Function 02:34:27 - MIN and MAX Function 02:36:52 - Handling Errors in Calculations 02:45:34 - Absolute vs Relative Referencing 02:52:29 - Autosum and Autofill Options 03:02:12 - Flash Fill 03:07:15 - Exercise 03 03:12:26 - What are Named Ranges 03:21:33 - Managing Named Ranges 03:25:22 - Using Named Ranges 03:30:42 - Exercise 04 03:35:00 - Applying Number Formats 03:45:03 - Applying Date and Time Formats 03:50:41 - Formatting Cells, Rows and Columns 03:59:20 - Format Painter 04:04:00 - Exercise 05 04:08:11 - Working with Rows and Columns 04:16:36 - Deleting and Clearing Cells 04:23:02 - Aligning Text and Numbers 04:34:15 - Applying Themes and Styles 04:42:13 - Course Introduction 04:48:31 - Improve Readability with Cell Styles 04:53:30 - Controlling Data Input 05:01:49 - Adding Navigation Buttons 05:10:36 - Logical Functions 05:23:56 - The IF Function 05:29:25 - Nested IFs 05:37:24 - The IFs Function 05:43:27 - Conditional IFs 05:50:13 - Multiple Criteria 05:57:25 - Error Handling 06:03:27 - Exercise 01 06:10:56 - VLookup (Exact Match) 06:21:36 - VLookup (Approximate Match) 06:26:02 - HLookup 06:31:40 - INDEX and MATCH 06:42:09 - XLookup and XMatch 06:52:18 - OFFSET Function 07:03:10 - INDIRECT Function 07:12:17 - Exercise 02 07:17:19 - Sorting on Multiple Columns 07:24:25 - Soring Using a Custom List 07:28:00 - SORT and SORTBY Functions 07:37:49 - Advanced Filter 07:44:52 - UNIQUE Function 07:50:10 - FILTER Function 07:49:40 - Exercise 03 08:05:20 - How Date and Times are Stored 08:09:32 - Custom Data and Time Formats 08:16:42 - Time and Date Functions 08:25:26 - WORKDAY and WORKDAY.INTL Functions 08:29:16 - NETWORKDAYS and NETWORKDAYS.INTL Functions 08:32:13 - DATEDIF 08:38:28 - EDATE and EOMONTH 08:45:52 - Exercise 04 08:50:45 - Importing Data into Excel 09:00:40 - Removing Blank Rows, Cells and Duplicate Entries 09:06:02 - Changing Case and Removing Spaces 09:15:07 - Splitting Up Data Using Text to Columns 09:22:08 - Splitting Up Data Using Text Functions 09:30:13 - Flash Fill 09:35:13 - CONCAT 09:42:44 - Formatting Data as Table 🌍 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=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z ✅ Excel 2021 Tutorials for Intermediate Users here 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3 ✅ 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 👍🏽 ;-) [fODnNDNMXiI] |
| Category | Science & Technology |
| Tags | excel tutorial | excel tips and tricks | excel 2021 | excel 365 | vlookup | hlookup | xmatch | xlookup | sumif | countif | excel unique | concat | flash fill | excel flash fill | sumifs | excel xlookup | vlookup in excel | countifs | flash fill excel | office 2021 | unique function | averageifs | excel flashfill | xmatch excel | office 365 | count if | hlookup in excel | xmatch function in excel | countif and countifs | index match | filter function | nested if | microsoft office 2021 | counta | excel xmatch | excel |
