Excel Tutorial Beginner to Advanced 12Hour Excel Course

YOUR LINK HERE:

http://youtube.com/watch?v=DXOq1xiIaF0

✅ Download the free exercise files to follow along ➡️https://www.simonsezit.com/excel-2021... • 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/ • 🚀 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-... • Check out our Microsoft Excel Long Tutorials playlist here • 🔥 • Microsoft Excel Training Tutorials fo... • 💬Stay in touch! • SimonSezIT.com: https://www.SimonSezIT.com/ • LinkedIn: / simon-sez-it

#############################

New on site