Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Excel 2021 Full Course Tutorial (3+ Hours). That video is uploaded by Learnit Training at 2023-04-26T06:00:06-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [7tx1H7sxSL0]
| Name | Excel 2021 Full Course Tutorial (3+ Hours) |
| Video Uploader | Video From Learnit Training |
| Upload Date | This Video Uploaded At 26-04-2023 13:00:06 |
| Video Discription | Excel 2021 Full Course Tutorial (3+ Hours) Get Ad-Free Training by becoming a member today! https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join Exercise Files: https://learnitanytime.com/p/exercise-files-excel-2021-full-course-tutorial Who it's for: Beginners - experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel. What it is: Microsoft’s spreadsheet application used to clean and organize data. What you'll learn: We start with the basics, showing you the user interface and quick ways to navigate. Once you’re comfortable with the software’s layout, we quickly move on to calculating data with basic formulas and functions. In the Intermediate section, we show you the various tools and ways to sort and filter data in a timely manner. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Advanced training starts with basic functions like the IF function. After that, we explore complex Database functions, provide an introduction to Macros, and show you how to save time by automating common Excel tasks. Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content: https://www.learnitanytime.com For Private Group Trainings please visit: https://www.learnit.com/private-group-classes-workshops Manuals: https://bit.ly/30xZb59 Username: manuals Password: password Start 0:00 Introduction 0:03 Start Screen 2:35 Excel Interface 7:03 Zooming, Navigating, and Shortcuts 13:31 Performing Excel Calculations 28:19 Simple Excel Functions 36:53 ABS, REF, and AutoFill Functions 42:25 Checking Compatibility 47:51 Inserting, Moving, and Cutting 49:29 Cell Styles 54:30 Themes 59:41 Showing and Hiding Worksheets 1:03:16 Grouping Worksheets 1:06:19 Freeze Panes 1:08:45 Custom Views 1:14:15 Saving Templates 1:16:09 Spell Check 1:18:36 Print Preview 1:20:09 Conclusion 1:23:17 Introduction 1:23:59 Formatting Lists as Tables 1:25:19 Flash Fill 1:34:16 Custom Sorting 1:37:03 Subtotals 1:41:15 QA Tool 1:45:55 Data Charts 1:49:01 Sparklines 1:56:29 Introduction to Pivot Tables 2:01:26 Advanced Pivot Tables Options 2:13:32 Data Validation 2:21:01 Conditional Formats 2:27:34 Comments and Notes 2:34:05 Linking Data 2:36:40 Privacy and Protection 2:39:41 Conclusion 2:43:16 Introduction 2:43:41 Nesting Functions 2:46:48 Database Functions 2:54:40 XLOOKUP 3:03:11 UNIQUE 3:11:03 SORT and SORTBY 3:16:54 FILTER 3:22:48 LET 3:29:18 Consolidate 3:34:42 Introduction to Macros 3:39:27 Recording and Playing Macros 3:42:02 Conclusion 3:47:27 #excel #excel2021 #exceltutorial (C) 2023 Learnit, Inc. Any illegal reproduction of this content will result in immediate legal action. 7tx1H7sxSL0 |
| Category | Education |
| Tags | learn excel 2021 | excel 2021 tips and tricks | excel 2021 guide | how to use excel 2021 | free excel 2021 training | using excel 2021 | microsoft excel 2021 | excel xlookup | add drop down in excel | excel password | excel name | excel convert | excel count | excel sort | excel subtotal | excel data set | excel tutoring | excel duplicate | excel autofill | excel function | excel freeze | excel group | excel view | excel template | excel print | excel table | excel formula | excel vlookup |
