Channel BannerChannel Banner
DXOq1xiIaF0DXOq1xiIaF0

Excel Tutorial Beginner to Advanced - 12-Hour Excel Course

1,441,984
Socialcounts.Org
Enter Fullscreen (f)
25,040
likes
941
comments
daily view 0
monthly view 0

Share

Live Analytics

Comments 0

Excel Tutorial Beginner to Advanced - 12-Hour Excel Course Analytics Table

Income Estimates for Excel Tutorial Beginner to Advanced - 12-Hour Excel Course

Based on this YouTube video's total view count of 1.44M views and industry-standard rates, the estimated total earning is $1.01K - $2.88K through ad revenue. Historical data is not yet available to calculate daily, weekly, or monthly averages.

About Excel Tutorial Beginner to Advanced - 12-Hour Excel Course

Explore Excel Tutorial Beginner to Advanced - 12-Hour Excel Course with 1,441,984 views, 25,040 likes, and 941 comments. Experience the impact of this video content that has captured audience attention.

āœ… 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/ šŸš€ 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-day-free/ Check out our Microsoft Excel Long Tutorials playlist here šŸ”„https://www.youtube.com/playlist?list=PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI šŸ’¬Stay in touch! SimonSezIT.com: https://www.SimonSezIT.com/ LinkedIn: https://www.linkedin.com/company/simon-sez-it/

About YouTube Real-Time View Count

With SocialCounts.org’s view counter, track your YouTube video’s live view count and YouTube likes count in real time with fast, reliable updates.

Watch every YouTube video live view count rise with our real-time YouTube views tracker—built for accuracy and minimal delay.

Follow YouTube real time views as they happen, using our dedicated view counter for YouTube videos.

Get up-to-date live view count on YouTube and see real-time growth with SocialCounts.org’s smart tracking tools.

Embed Widget

Parameters:

  • fullscreen=true - Fullscreen counter
  • graph=true - Live graph chart
  • counter=0/1/2 - Select counter (0=likes, 1=views, 2=comments)
URL

Click to copy the embed URL to your clipboard