Channel: Simon Sez IT

Category: Science & Technology

Tags: excel tutorialhlookupxmatch function in excelexcel uniquevlookupvlookup in excelexcel flash fillexcel flashfilldatedifcountifsindex matchhlookup in excelexcel intermediateexcel 2021count ifxmatch exceloffice 365unique functionexcel tips and trickssumifexcel xlookupaverageifsflash fill exceloffice 2021sumifsconcatmicrosoft excelxlookupfilter functionflash fillcountif and countifsexcel 365countifexcel formulasxmatch

Description: Download to follow along and complete the exercises ►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. This will help you put what you are learning into practice and master Excel. 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:00:20 - Course 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: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 Take a look at the latest Excel training courses from Simon Sez IT ►bit.ly/3fNO5mw Check out our Excel 2021 tutorials for intermediate users playlist here ►youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3 Watch more popular MS Office tutorials from Simon Sez IT: Microsoft Excel 2021/365 Tutorial (4.5+ Hours Beginner Course) ►youtu.be/Lvk45S3j7Y8 Advanced PowerPoint Hacks (1-Hour Webinar Tutorial) ►youtu.be/X1sLCkCB-Ts Learn PivotTables in 1 Hour (Excel Crash Course) ►youtu.be/2RKw-HGCLB0 Introduction to QuickBooks Desktop 2021 (4-Hour Tutorial) ►youtu.be/-K357CmF0Xk Ultimate Microsoft Office Course (12-Hour Course for Beginners) ►youtu.be/IUAq9r5B9Go Other, free Microsoft Excel playlists from Simon Sez IT: Excel 2021 Tutorials for Beginners playlist ►youtube.com/playlist?list=PLzj7TwUeMQ3jqRlmIaj6jb_X9EGQueMDb Microsoft Excel 2019 Advanced playlist ►youtube.com/playlist?list=PLzj7TwUeMQ3gL_KnxdZzkDExVeX5vngx9 Stay in touch! SimonSezIT.com: SimonSezIT.com StreamSkill.com: StreamSkill.com YouTube Channel: youtube.com/user/simonsezittraining Subscribe to our channel: youtube.com/simonsezittraining?sub_confirmation=1 If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)