Загрузка страницы

Excel Tutorial Beginner to Advanced - 12-Hour Excel Course

✅ 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/

Видео Excel Tutorial Beginner to Advanced - 12-Hour Excel Course канала Simon Sez IT
Показать
Комментарии отсутствуют
Введите заголовок:

Введите адрес ссылки:

Введите адрес видео с YouTube:

Зарегистрируйтесь или войдите с
Информация о видео
25 января 2023 г. 19:00:08
11:55:34
Другие видео канала
Agile Scrum Team Roles: The Product Owner, Scrum Master, and Team MemberAgile Scrum Team Roles: The Product Owner, Scrum Master, and Team MemberAdobe Illustrator CC Essentials: Creating Stunning Artwork Using the Lasso ToolAdobe Illustrator CC Essentials: Creating Stunning Artwork Using the Lasso ToolUltimate Excel Tips and Tricks - 4+ Hours Tutorial of Step by Step TrainingUltimate Excel Tips and Tricks - 4+ Hours Tutorial of Step by Step TrainingAdobe Illustrator CC for Beginners Tutorial: 2+ Hours of Illustrator Creative Cloud TrainingAdobe Illustrator CC for Beginners Tutorial: 2+ Hours of Illustrator Creative Cloud TrainingHow to Use Microsoft Teams for Beginners TutorialHow to Use Microsoft Teams for Beginners TutorialMicrosoft Project 2021 Beginner to Advanced Training: 5-Hour Tutorial CourseMicrosoft Project 2021 Beginner to Advanced Training: 5-Hour Tutorial CourseMicrosoft Word 365 for Beginners: 4+ Hour Training CourseMicrosoft Word 365 for Beginners: 4+ Hour Training Course20 Excel Formulas and Functions to Master in 2024 - Excel Formulas and Functions Training Tutorial20 Excel Formulas and Functions to Master in 2024 - Excel Formulas and Functions Training Tutorial30 Essential Excel Tips and Tricks for 2024 - Excel Productivity Tutorial30 Essential Excel Tips and Tricks for 2024 - Excel Productivity TutorialHow to use Dynamic Arrays in Excel and other Advanced FormulasHow to use Dynamic Arrays in Excel and other Advanced FormulasThe Ultimate Guide to Essential Excel Formulas to Supercharge Your Productivity!The Ultimate Guide to Essential Excel Formulas to Supercharge Your Productivity!Microsoft 365 Training Course: Beginner Guide to Essential Basics with M365Microsoft 365 Training Course: Beginner Guide to Essential Basics with M365How to use Lookup Functions in Excel: VLOOKUP, INDEX and MATCH, and XLOOKUP Training TutorialHow to use Lookup Functions in Excel: VLOOKUP, INDEX and MATCH, and XLOOKUP Training TutorialQuickBooks Desktop 2023 Training for Beginners (4+ Hours QuickBooks Tutorial Crash Course)QuickBooks Desktop 2023 Training for Beginners (4+ Hours QuickBooks Tutorial Crash Course)Ultimate Excel PivotTables Tutorial: Beginner to Advanced - 3.5 Hours!Ultimate Excel PivotTables Tutorial: Beginner to Advanced - 3.5 Hours!Changing the Margins in Microsoft ExcelChanging the Margins in Microsoft ExcelTracking Changes in Microsoft ExcelTracking Changes in Microsoft ExcelHow to Make a Line Graph in Microsoft ExcelHow to Make a Line Graph in Microsoft ExcelMicrosoft Access 2021 Beginner Course: 3 Hours Database Management TrainingMicrosoft Access 2021 Beginner Course: 3 Hours Database Management TrainingHow to Use QuickBooks Desktop 2023 for Beginners - 1+ Hour QuickBooks Tutorial!How to Use QuickBooks Desktop 2023 for Beginners - 1+ Hour QuickBooks Tutorial!Microsoft Project 2021 Tutorial Course: 2.5 Hours of Beginner TrainingMicrosoft Project 2021 Tutorial Course: 2.5 Hours of Beginner Training
Яндекс.Метрика