Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Excel Tutorial Beginner to Advanced - 12-Hour Excel Course. That video is uploaded by Simon Sez IT at 2023-01-25T06:00:08-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [DXOq1xiIaF0]
| Name | Excel Tutorial Beginner to Advanced - 12-Hour Excel Course |
| Video Uploader | Video From Simon Sez IT |
| Upload Date | This Video Uploaded At 25-01-2023 14:00:08 |
| Video Discription | ✅ Download the free exercise files to follow along ➡️https://www.simonsezit.com/excel-2021-beginner-to-advanced-course-files/ This Microsoft Excel 2021 Beginner to Advanced training course covers everything from the basics of Excel to intermediate and advanced skills. Topics covered include logical IF functions, Excel lookup functions, formatting, statistical functions, and more. Downloadable exercise files from the paid-for course are included, helping users master Excel. The course covers how to launch Excel, explore the interface, use ribbons, tabs, and menus, utilize the Quick Access Toolbar, and more. Additionally, the course covers intermediate topics such as cell styles, data input, navigation buttons, and more. Finally, the course covers advanced topics such as dynamic arrays, two-way lookups, median and mode, rounding values, and more. 📝 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:22 - Course Intro 0:02:42 - Excel 2021 vs Excel 365 0:08:21 - Launching Excel 0:12:00 - The Start Screen 0:22:12 - Exploring the Interface 0:33:51 - Ribbons, Tabs and Menus 0:42:20 - Backstage Area 0:47:00 - Quick Access Toolbar 0: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:21 - Intermediate Course Introduction 04:14:39 - Improve Readability with Cell Styles 04:19:36 - Controlling Data Input 04:27:55 - Adding Navigation Buttons 04:36:42 - Logical Functions 04:50:01 - The IF Function 04:55:27 - Nested IFs 05:03:29 - The IFs Function 05:09:34 - Conditional IFs 05:16:19 - Multiple Criteria 05:23:30 - Error Handling 05:29:33 - Exercise 01 05:37:02 - VLookup (Exact Match) 05:47:43 - VLookup (Approximate Match) 05:52:09 - HLookup 05:57:46 - INDEX and MATCH 06:08:18 - XLookup and XMatch 06:18:26 - OFFSET Function 06:29:16 - INDIRECT Function 06:38:22 - Exercise 02 06:47:27 - Sorting on Multiple Columns 06:50:31 - Soring Using a Custom List 06:54:05 - SORT and SORTBY Functions 07:04:04 - Advanced Filter 07:10:58 - UNIQUE Function 07:16:16 - FILTER Function 07:25:45 - Exercise 03 07:31:26 - How Date and Times are Stored 07:35:38 - Custom Data and Time Formats 07:42:47 - Time and Date Functions 07:51:33 - WORKDAY and WORKDAY.INTL Functions 07:55:22 - NETWORKDAYS and NETWORKDAYS.INTL Functions 07:58:19 - DATEDIF 08:04:32 - EDATE and EOMONTH 08:12:15 - Advanced Course Introduction 08:15:04 - Exercise 01 08:17:08 - Dynamic Arrays 08:19:23 - Spill and Arrays 08:30:18 - Extract and Count Unique Entries 08:36:33 - Unique vs. Distinct 08:39:54 - Unique with Multiple Criteria 08:43:07 - Unique Values by Column 08:47:30 - SORT Function 08:56:25 - Horizontal Sort 09:02:30 - SORTBY Function 09:08:40 - Horizontal SORTBY 09:11:47 - Sequence and Unstacking Records 09:21:54 - Filter Function 09:28:54 - Using Filter with Logic Plus Operator 09:33:41 - Using Filter with Logic Asterisk Operator 09:39:19 - Using Filter with Logic Equals Operator 09:43:32 - Using Filter with Logic Minus Operator 09:48:21 - RANDARRAY and RANDBETWEEN 09:58:06 - XLookUp 10:10:26 - XMatch 10:16:50 - Exercise 02 10:29:57 - Two-way Lookups 10:38:23 - CHOOSE Function 10:48:25 - SWITCH Function 10:52:58 - Exercise 03 11:00:03 - Median and Mode 11:06:20 - Using LARGE and SMALL 11:13:51 - Ranking Data 11:21:33 - COUNTBLANK Function 11:26:19 - Exercise 04 11:33:24 - Rounding Values 11:40:23 - Specialized Rounding 11:44:52 - Aggregate Function 11:49:26 - Exercise 05 🌍 Get unlimited training with Simon Sez IT’s 160+ 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 Check out our Microsoft Excel Long Tutorials playlist here 🔥https://www.youtube.com/playlist?list=PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI ✅ PivotTable training here 👉 https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iJ5hWG_iZuIvFvnuJJ-mtc 💬Stay in touch! SimonSezIT.com: https://www.SimonSezIT.com/ LinkedIn: https://www.linkedin.com/company/simon-sez-it/ DXOq1xiIaF0 |
| Category | Science & Technology |
| Tags | Excel 2021 | Excel 365 | Advanced Excel | excel tips and tricks | excel 2021 xlookup | excel dynamic array | randarray | randbetween | sortby | xlookup | xmatch | countblank | excel statistics | excel mode | excel median | excel switch | aggregate function | excel | office 2021 | office 365 | dynamic array function | xmatch function | simon sez it | vlookup | office 365 dynamic arrays | array formula in excel | dynamic array | averageifs | sumifs | unique function | dynamic array functions | data cleaning | IF |
