Excel 2021 Full Course Tutorial (3+ Hours)

Learn Skills Daily April 26, 2023
Video Thumbnail
Learn Skills Daily Logo

Learn Skills Daily

@learnskillsdaily

About

BECOME A MEMBER TO UNLOCK AD-FREE VIDEOS Learn Skills Daily provides on-demand video courses on a wide range of software and subjects. From the deep data tools of Microsoft Excel to the endless creative possibilities of Adobe Photoshop to the collaborative concoction of Microsoft Teams, we've got you covered. At Learn Skills Daily, we've been fine-tuning our teaching methodology for over 25 years. Our videos are specifically designed to emulate the same great experience you get from a live class. Plus, you can learn at your own pace, following along with our try-it-yourself exercise files. If you're serious about learning, we're serious about providing you with a better learning platform.

Video Description

Excel 2021 Full Course Tutorial (3+ Hours) Get Ad-Free Training by becoming a member today! https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content: https://www.learnitanytime.com Exercise Files: https://tinyurl.com/4h4wpbev 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. 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 Learnit is no longer associated with this channel/video. (C) 2025 Bomberry Productions Any illegal reproduction of this content will result in immediate legal action.

Essential Kitchen Upgrade

AI-recommended products based on this video

Loading...
Waterdrop 10UA Under Sink Water Filter System, Reduces Lead, Chlorine, Bad Taste & Odor, Under Counter Water Filter Direct Connect to Kitchen Faucet, NSF/ANSI 42 Certified, 8K Gallons, USA Tech

Waterdrop 10UA Under Sink Water Filter System, Reduces Lead, Chlorine, Bad Taste & Odor, Under Counter Water Filter Direct Connect to Kitchen Faucet, NSF/ANSI 42 Certified, 8K Gallons, USA Tech

(19,655)
$69.99
FREE delivery Tue, Sep 23
100+ bought in past month
Loading...
Waterdrop 15UA Under Sink Water Filter System, Reduces Lead, Chlorine, Bad Taste & Odor, Under Counter Water Filter Direct Connect to Kitchen Faucet, NSF/ANSI 42 Certified, 16000 Gallons, USA Tech
Amazon's Choice

Waterdrop 15UA Under Sink Water Filter System, Reduces Lead, Chlorine, Bad Taste & Odor, Under Counter Water Filter Direct Connect to Kitchen Faucet, NSF/ANSI 42 Certified, 16000 Gallons, USA Tech

(9,244)
$87.99$79.99
FREE delivery Tue, Sep 23
700+ bought in past month
Loading...
2-in-1 Stainless Steel Pet Grooming Comb Set with Dense & Bristles for Dogs and Cats - ABS Handle, Self-Cleaning, 20cm

2-in-1 Stainless Steel Pet Grooming Comb Set with Dense & Bristles for Dogs and Cats - ABS Handle, Self-Cleaning, 20cm

(0)
$4.30
$3.99 delivery Jun 17 - 26
Loading...
17 MILE Black Cross Earrings for Men, 28 Pieces Stainless Steel Long Chain Dangle Piercing Hoop Earrings Set for Gifts

17 MILE Black Cross Earrings for Men, 28 Pieces Stainless Steel Long Chain Dangle Piercing Hoop Earrings Set for Gifts

(3,800)
$18.97
FREE delivery Sat, Jun 14 on your first order
Loading...
Huachuang 3PCS Griddle Accessories for Blackstone: 2 Clip-on Stainless Steel Spatula Holder + Magnetic Grease Gate Blocker for 28"/36" Blackstone Griddle - Grill Barbecue Tool Set

Huachuang 3PCS Griddle Accessories for Blackstone: 2 Clip-on Stainless Steel Spatula Holder + Magnetic Grease Gate Blocker for 28"/36" Blackstone Griddle - Grill Barbecue Tool Set

(4)
$16.99
FREE delivery Sun, Aug 10 on your first order
Loading...
Trinckle Magnetic Earrings for Men and Women, 4 Pairs Stainless Steel Stud Earrings Hypoallergenic Cubic Zirconia Studs Small Non-piercing Clip on Earrings Silver Ear Cuff Black Fake Earring Set 6-8MM

Trinckle Magnetic Earrings for Men and Women, 4 Pairs Stainless Steel Stud Earrings Hypoallergenic Cubic Zirconia Studs Small Non-piercing Clip on Earrings Silver Ear Cuff Black Fake Earring Set 6-8MM

(182)
$17.99
FREE delivery Fri, Jul 11 on your first order
Loading...
Victorinox Swiss Army Classic SD Pocket Knife, Camo

Victorinox Swiss Army Classic SD Pocket Knife, Camo

(45,533)
$33.00
$4.99 delivery Jun 19 - 25
Loading...
Herb Garden Planter Indoor Kit 21Pcs Kitchen Herb Starter Set Herb Growing Kit Including Wooden Box, Burlap Pots, Soil Discs, Gardening Tools, Unique Easter Birthday Christmas Gift Ideas for Women Mom

Herb Garden Planter Indoor Kit 21Pcs Kitchen Herb Starter Set Herb Growing Kit Including Wooden Box, Burlap Pots, Soil Discs, Gardening Tools, Unique Easter Birthday Christmas Gift Ideas for Women Mom

(0)
$21.99
$9.99 delivery Jun 19 - Jul 3
Loading...
Toddler Kitchen Tower, Learning Standing Tower, 4-in-1 Kitchen Black Wooden Stool Helper with Chalkboard Montessori and Waldorf Helper for Kids in Kitchen

Toddler Kitchen Tower, Learning Standing Tower, 4-in-1 Kitchen Black Wooden Stool Helper with Chalkboard Montessori and Waldorf Helper for Kids in Kitchen

(12)
$89.99
FREE delivery Sat, Jun 28
50+ bought in past month
Loading...
Herb Garden Planter Indoor Kit 21Pcs Kitchen Herb Garden Starter Kit Growing Kit Including Wooden Box Burlap Pots Soil Discs Gardening Tools Unique Easter Birthday Christmas Gift Ideas for Women Mom

Herb Garden Planter Indoor Kit 21Pcs Kitchen Herb Garden Starter Kit Growing Kit Including Wooden Box Burlap Pots Soil Discs Gardening Tools Unique Easter Birthday Christmas Gift Ideas for Women Mom

(0)
$30.99
FREE delivery Jun 19 - Jul 3
Loading...
3D Spiral Apples Silicone Molds for Baking | Food Grade Mousse Cake Chocolate Molds | Reusable Baking Molds Silicone Shapes (3.46x3.46x2.09in)

3D Spiral Apples Silicone Molds for Baking | Food Grade Mousse Cake Chocolate Molds | Reusable Baking Molds Silicone Shapes (3.46x3.46x2.09in)

(0)
$14.39
$5.54 delivery Aug 27 - Sep 18
Loading...
Ninja Air Fryer Pro 5-in-1, 5 QT Capacity, Air Fry, Bake, Roast, Reheat, and Dehydrate, Air Crisp Technology, Nonstick Basket & Crisper Plate, Grey, AF142C

Ninja Air Fryer Pro 5-in-1, 5 QT Capacity, Air Fry, Bake, Roast, Reheat, and Dehydrate, Air Crisp Technology, Nonstick Basket & Crisper Plate, Grey, AF142C

(650)
$100.99
FREE delivery Thu, Oct 16
500+ bought in past month
Loading...
Glass Oil Sprayer for Cooking, 180ml Olive Oil Sprayer Bottle with Brush, Olive Oil Spray Mister, Kitchen Gadgets Accessories for Air Fryer, Canola Oil Spritzer (GREY)

Glass Oil Sprayer for Cooking, 180ml Olive Oil Sprayer Bottle with Brush, Olive Oil Spray Mister, Kitchen Gadgets Accessories for Air Fryer, Canola Oil Spritzer (GREY)

(2,436)
$7.99
FREE delivery Mon, Jun 16 on your first order