Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching Microsoft Excel Intermediate Training (2021/365): 5-Hour Excel Tutorial Class. and this video is uploaded by Simon Sez IT at 2022-04-26T08:00:13-07:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [oN82Umc9MCQ]
| Name | Microsoft Excel Intermediate Training (2021/365): 5-Hour Excel Tutorial Class |
| Video Uploader | Video From Simon Sez IT |
| Upload Date | This Video Uploaded At 26-04-2022 15:00:13 |
| Video Discription | ✅ Download to follow along and complete the exercises ➡️ https://www.simonsezit.com/excel-2021-intermediate-courseexercise-files/ In this Excel 2021 Intermediate training course, you will build on your beginner-level Excel knowledge and expand your skills. We'll go over Excel logical functions such as IF, COUNTIF, and SUMIF and Excel lookup functions like VLOOKUP, HLOOKUP, INDEX, and MATCH. We will also discuss various other Excel formulas such as UNIQUE, CONCAT, and so much more! You will also learn how to use advanced filters, sort columns and lists, use custom date formats, remove duplicate entries, split and combine data, and many other Excel tips and tricks. After this training video, you will have a solid foundation for using Excel 2021/Excel 365, as part of the Office 2021 suite of applications. We've even included downloadable exercise and instructor files from our paid-for course so you can follow along and complete the exercises in this Microsoft Excel 2021/365 Tutorial. ✅ https://www.simonsezit.com/excel-2021-intermediate-courseexercise-files/ 📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead! 0:00:00 - Introduction 0:06:38 - Improve Readability with Cell Styles 0:11:37 - Controlling Data Input 0:19:57 - Adding Navigation Buttons 0:28:43 - Logical Functions 0:42:02 - The IF Function 0:47:28 - Nested IFs 0:55:30 - The IFs Function 1:01:35 - Conditional IFs 1:08:20 - Multiple Criteria 1:15:33 - Error Handling 1:21:34 - Exercise 01 1:29:04 - VLOOKUP (Exact Match) 1:39:44 - VLOOKUP (Approximate Match) 1:44:10 - HLOOKUP Function 1:49:49 - INDEX and MATCH 2:00:16 - XLookup and XMatch 2:10:26 - OFFSET Function 2:21:17 - INDIRECT Function 2:30:24 - Exercise 02 2:35:26 - Sorting on Multiple Columns 2:42:31 - Sorting Using a Custom List 2:46:07 - SORT and SORTBY Functions 2:56:07 - Advanced Filter 3:02:59 - UNIQUE Function 3:08:16 - FILTER Function 3:17:48 - Exercise 03 3:23:29 - How Dates and Times are Stored 3:27:39 - Custom Date and Time Formats 3:34:49 - Time and Date Functions 3:43:33 - WORKDAY and WORKDAY.INT Functions 3:47:22 - NETWORKDAYS and NETWORKDAYS.INT Functions 3:50:20 - DATEDIF Function 3:56:33 - EDATE and EOMONTH Functions 4:03:55 - Exercise 04 4:08:51 - Importing Data into Excel 4:18:46 - Removing Blank Rows, Cells, and Duplicate Entries 4:24:07 - Changing Case and Removing Spaces 4:33:12 - Splitting Up Data Using Text to Columns 4:40:15 - Splitting Up Data Using Text Functions 4:48:22 - Using Flash Fill 4:53:21 - CONCAT Function 5:00:50 - 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 Beginner to Advance Excel Training 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hHQu2_LBKMpM6hjE0_aqF- ✅How to Use Pivot Tables in Excel video playlist 👉 https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u ✅ Microsoft Excel 30 Tips and Tricks here 👉 https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc ✅ Microsoft Office 2021 and Office 365 playlist here 👉 https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hCohvZZ2QjNGEo95OoqZST 🔥Check out our FREE 300+ hour training course playlist here ➡️ https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 💬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 👍🏽 ;-) [oN82Umc9MCQ] |
| Category | Science & Technology |
| Tags | microsoft excel | excel tutorial | excel tips and tricks | Excel Intermediate | excel 2021 | excel 365 | vlookup | hlookup | xmatch | xlookup | sumif | countif | excel unique | concat | DATEDIF | flash fill | excel flash fill | sumifs | excel xlookup | vlookup in excel | excel formulas | 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 |
