Excel 2019 VBA Intermediate Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Exercise Files: https://tinyurl.com/yvfmez5e

Who it's for: Business Analysts, Data Scientists, and everyone in between looking to write their own rulebook on what’s possible in Excel.

What it is: Visual Basic for Applications (VBA) is the programming language for Excel and other Microsoft Office programs. VBA is used to automate repetitive processes and frequent actions. Even more, it can be used to build tools that otherwise don’t exist in Excel.

What you'll learn: In this series, users will be guided through the foundational concepts of VBA in Excel. Users will learn to build macros from the ground up, starting with recording macros that require little to no code, and working towards building their own macros using crucial VBA concepts such as Loop, If Then, and other complex functions.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Start 0:00
Introduction 0:03
Introduction to Expressions, Variables, and Intrinsic Functions 2:06
Variables - Overview, Naming Rules, and Conventions 3:48
Variable Declaration Methods and Scope5:35
VBA Data Types 7:40
Option Explicit Statement and Removing Variables from Memory 9:26
Concise Ways to Declare Variables 13:43
Declaring Procedure Level String Variables and Reviewing Intrinsic Functions and VIN Characters 17:19
Assigning Values to Variables Using Intrinsic Functions and the Line Editor 21:14
Testing the Sub Procedure and Introduction to the With-End With Structure and the Offset Property 28:26
Creating a With-End With Structure that References the Offset Property and Testing the Procedure 33:40
Troubleshooting the Procedure and Re-Testing It 37:44
Saving Files as Macro-Enabled 40:50
Overview of MsgBox and InputBox Functions 41:24
Modifying an Event Procedure to Include a Message Box 46:56
Testing the Message Box Function 51:44
Modifying a Sub Procedure to Include an Input Box 52:56
Testing the Input Box Function 59:45
Overview of Object Variables 1:01:03
Using Object Variables in a Sub Procedure 1:02:38
Testing a Sub Procedure by Stepping Into It 1:10:33
Expressions, Variables, and Intrinsic Functions Recap 1:15:04
Introduction to Controlling Program Execution 1:18:24
Controlling Program Execution and Control of Flow Structures 1:19:02
Boolean Expressions, Logical Operators, and Comparison Operators 1:21:10
Overview of the If-Then Constructs 1:24:40
Using the If-Then-End If Construct 1:27:01
Creating a Function Procedure Using the If-Then-Else-End If Construct 1:30:32
Calling a Function Procedure from a Sub Procedure 1:34:47
Testing the Function Procedure and Modifying the Code 1:37:54
Creating a Function Procedure to Extract the Year from the VIN 1:39:55
Testing the Year Extraction Function 1:43:30
Creating a Function Procedure Using the If-Then-ElseIf-End If Construct 1:44:14
Creating a With-End With Structure for Concise Code - Testing Procedure 1:47:47
Select Case Overview - End Select Construct 1:50:29
Creating Functions Using the Select Case - End Select Construct 1:51:20
Creating Functions by Using a Text File 1:55:13
On Your Own - Creating a Function to Extract the Make 1:58:24
Testing Final Three Function Procedures for Extraction 2:00:11
Overview of Looping Constructs 2:00:56
Using a Do While Loop to Populate the Spreadsheet 2:04:14
Creating Procedures to Append and Clear Info on Sheets 2:08:20
Testing the Append and Clear Sheet Procedures 2:14:19
Avoiding Errors by Using an If-Then-Else Construct 2:15:01
Using the For-Each-Next Loop 2:22:58
Controlling Program Execution Recap 2:27:46
Conclusion 2:28:51

#excel #exceltutorial #exceltips #vba #excelvba
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.

Excel 2019 VBA Beginner Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Exercise Files: https://tinyurl.com/yvfmez5e

Who it's for: Business Analysts, Data Scientists, and everyone in between looking to write their own rulebook on what’s possible in Excel.

What it is: Visual Basic for Applications (VBA) is the programming language for Excel and other Microsoft Office programs. VBA is used to automate repetitive processes and frequent actions. Even more, it can be used to build tools that otherwise don’t exist in Excel.

What you'll learn: In this series, users will be guided through the foundational concepts of VBA in Excel. Users will learn to build macros from the ground up, starting with recording macros that require little to no code, and working towards building their own macros using crucial VBA concepts such as Loop, If Then, and other complex functions.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com


Start 0:00
Introduction 0:03
Getting Started 2:06
VBA Overview 3:35
Adding the Developer Tab to the Excel Ribbon 6:48
Record Macro Dialog Box 8:06
Recording Macros 11:43
Testing Macros 15:21
Visual Basic Editor Overview and Changing Font Settings 17:18
Customizing VBE Toolbar 23:54
Editing VBA Code Generated by Recording a Macro 25:53
Using the Properties Window to Rename Objects 34:55
Saving Macro-Enabled Workbooks 38:23
Testing Macro Changes in Another Excel File 41:27
Undoing Macro Steps and Modifying Trust Center Settings 46:09
Getting Started Recap 53:21
Excel Object Model Hierarchy Overview and Collections 54:49
Referencing Objects 59:49
Introduction to Procedures and Functions 1:06:26
Understanding Module and Procedure Types 1:08:05
Naming Rules and Conventions for Procedures 1:10:12
Starting Macro Recordings from the Status Bar 1:12:10
Creating a Macro that Copies Data from Another File into the Current File 1:16:33
Reviewing Methods and Examples 1:18:26
Reviewing Newly Generated Code 1:20:18
Creating a Sub-Procedure from Scratch Using the Insert Menu 1:24:30
Modifying Two Existing Sub-Procedures 1:30:14
Executing Procedures and Creating a Calling Procedure from Scratch 1:35:26
Understanding the Scope of Procedures 1:39:35
Testing Calling Procedures 1:42:50
Creating Event Procedures 1:46:31
Testing Calling Procedures 1:51:13
Creating Function Procedures 1:52:13
Testing Function Procedures in the Immediate Window 1:59:23
Testing Function Procedures in Excel - User Defined Function 2:02:45
Accessing Context Specific Help from VBE 2:05:43
Procedures and Functions Recap 2:09:19
Conclusion 2:10:14

#excel #exceltutorial #exceltips #vba #excelvba
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.

Excel 2019 Intro to Data Analysis Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/3xunkxwf

Who it's for: Excel users needing to analyze, summarize, and visualize their data. Basic knowledge of Excel (familiarity with formulas, cell referencing, simple functions like SUM and AVERAGE) is recommended.

What it is: Microsoft Excel is the perfect program for viewing and analyzing data.

What you'll learn: Beyond simple averages and totals, Microsoft Excel offers many features to help you draw insights from your data. Sometimes those observations come from a particular formatting or visualization of the data; other times a specific summary function will generate a surprisingly significant result. In this full-length introductory course, learn all about data analytics in Excel with tools like table formatting, conditional functions, charting, pivot tables, and much more.


Start 0:00
Introduction 0:03
Preparing Data for Tables 1:22
Removing Blank Rows and Duplicates 3:35
Using Flash Fill to Apply Table Styles 7:52
Applying Table Styles 10:40
Auto Sorting and Filtering in Tables 13:55
Applying a Custom AutoFilter in Excel Tables 18:08
Adjusting Table Style Formats and Options 21:36
Applying Total Rows 24:13
Adding New Data and Turning Off Table Styles 27:04
Applying Conditional Formats 29:53
Editing and Turning Off Conditional Formats 33:38
IF Functions 36:01
SUMIF Functions 40:47
COUNTIF Functions 44:54
AVERAGEIF Functions 48:27
Creating Charts 51:58
Editing and Reformatting Charts 55:54
Creating Sparklines 1:00:20
Creating Win-Loss Sparklines 1:03:25
Creating Pivot Tables Using the Recommended Pivot Tables Button 1:05:19
Creating Pivot Tables from Scratch 1:08:25
Editing Summary Function and Format of Pivot Table Value Fields 1:11:53
Filtering, Sorting, and Editing Pivot Table Fields 1:15:02
Grouping Column Labels in Pivot Tables 1:19:17
Creating Slicers 1:22:09
Refreshing Pivot Table Data 1:24:45
Creating and Updating Pivot Charts 1:26:29
Conclusion 1:31:27

#excel #data #analysis #microsoft #training 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.

Excel 2019 Power User Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/4tsjvfv4

Who it's for: This course was built from the ground up for the advanced users and those in search of more than typical Excel tools and processes. Attendees of this course are recommended to have completed our Excel 2019 training, or at a minimum already be proficient in the skills referenced in those courses.

What it is: The Excel Power User Tutorial expands on the idea that the tools by themselves are only part of the equation. To say that you’re capable of solving a problem is enough for most users, but participants in this course aren’t most users. The desire to learn and invest time in building resources that solve problems faster and with less effort is a key quality of the power user and something the course maintains a heavy focus on.

What you'll learn: In this series, students will learn how to intermix tools in Excel to accomplish time-intensive tasks. Students will learn to develop a deeper understanding of data mining tools like VLOOKUP, as well as more advanced solutions like the INDEX, MATCH, and OFFSET functions. Throughout the course, users will learn how to expedite data analysis through dynamic ranges and how to push Excel to the edges of what’s possible out of the box with new perspectives on how to think their way through challenging problems.

Start 0:00
Introduction 0:03
Troubleshooting VLOOKUP 2:21
Using IFERROR 11:05
Replacing VLOOKUP with XLOOKUP 13:42
Index Match 17:40
Text Functions 22:28
PivotTables - 2019 Features 27:15
PivotTables - Calculated Field 33:40
PivotTables - Calculated Items 37:06
PivotTables - Show Values As 39:30
Array Formulas and Functions 40:49
Index and Match Array Function 43:16
Conditional Format New Rule Examples 49:09
Combo Charts and Sparklines 54:33
Add Developer Recording Macros 1:00:05
Editing, Saving, and Stepping into a Macro 1:05:17
Recording a Format Macro 1:09:39
Conclusion 1:14:25

#excel 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.

Excel 2019 Pivot Tables Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/42t7ae2s

Who it's for: Anyone who uses Excel and wants to learn one of the most powerful tools Excel offers.

What it is: Pivot Tables helps you easily take a very large dataset and create a table that only displays the information you need.

What you'll learn: You’ll learn how to easily create, modify, and update Pivot Tables and charts.

Start 0:00
Introduction 0:03
Data Mining 2:40
Adding Related Data Using VLOOKUP 13:35
Inserting Pivot Tables 26:23
Setting Up Pivot Tables 30:51
Building Pivot Tables 36:56
Filtering and Slicing Pivot Table Data 42:21
Changing Source Data and Refreshing Pivot Tables 48:23
Inserting Pivot Charts 55:17
Using Tables to Build Pivot Tables 59:28
Finding Correct Layouts for Reports 1:05:37
Setting Default Layouts for Reports 1:11:03
Using Pivot Table Styles 1:14:25
Subtotals and Grand Totals 1:18:03
Creating Report Pages 1:20:31
Adding the Power Pivot Tab to Excel 1:27:13
Creating Tables for the Data Model 1:30:36
Adding Relationships with Power Pivot 1:34:32
Using DAX Expressions with Power Pivot 1:40:18
Creating Pivot Tables with Power Pivot 1:42:21
When to Use Power Pivot 1:46:03
Conclusion 1:47:33

#excel 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.

Excel 2019 Expert Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/k7acppwc

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 Advanced 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 Expert 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
Creating & Applying Named Ranges 1:24
Navigating with Named Ranges 9:42
IF Functions (Part 1) 11:26
IF Functions (Part 2) 15:17
Introduction to Nesting Functions 18:07
The Round Function 22:16
Formula Auditing Tools 25:39
Introduction to VLOOKUP 29:40
VLOOKUP 33:58
IFERROR 36:13
Database Functions – SUMIF & AVERAGEIF 38:37
Database Functions – SUMIFS 42:42
Text Functions 46:13
Consolidate by Position 53:17
Consolidate by Category 57:34
Goal Seek 1:00:31
Introduction to Data Tables 1:03:22
Data Tables 1:06:25
Scenario Manager 1:07:45
Macros – Adding the Developer Tab 1:12:28
Macros – Recording & Running the Header Macro 1:14:42
Macros – Visual Basic Editor & Form Control 1:20:29
Macros – Adding Macros to the Ribbon 1:25:02
Macros – Exercise 1:27:38

#excel 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.

Excel 2019 Advanced Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/k7acppwc

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 Advanced 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 Expert 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
Overview of List Design 1:02
Formatting Lists as Tables 4:47
Filtering Records from Lists or Tables 6:45
Removing Duplicates from Lists or Tables 10:19
Flash Fill 13:40
Single & Multi-Level Sorting 16:50
Inserting Automatic Subtotals in Lists 21:27
Inserting Data Charts Using Recommended Charts 27:36
Formatting & Editing Chart Elements 32:28
Creating & Applying Custom Chart Templates 36:58
Adding & Removing Data from Charts 40:38
Inserting Sparklines 43:23
Printing Charts 48:52
Inserting Pivot Tables 49:57
Filtering Pivot Tables 55:04
Using Report Layouts in Pivot Tables 59:58
Refreshing & Changing Source Data in Pivot Tables 1:03:05
Inserting Pivot Charts 1:07:21
Data Validation 1:09:18
Applying Built-In Conditional Formatting 1:14:12
Creating Custom Conditional Formats 1:17:26
Linking Data 1:20:23
Comments 1:24:41
Protection 1:26:56

#excel 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.

Excel 2019 Beginner Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/k7acppwc

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 Advanced 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 Expert 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 & Templates 0:59
Ribbon & Quick Access Toolbar 6:04
Backstage View 12:44
Smart Lookup & Tell Me 15:33
Interface 18:49
Navigation 22:36
Keyboard Shortcuts 26:03
Entering Text 30:18
Number Formats 36:08
Deleting & Formatting 40:20
AutoSum 44:55:01
Simple Formulas 49:29
Simple Functions (Part 1) 52:57
Simple Functions (Part 2) 59:18
Absolute Referencing 1:03:01
Moving & Copying Data 1:09:15
Inserting Rows & Columns 1:12:16
AutoFill 1:16:57
Cell Styles 1:22:52
Worksheet Themes 1:27:26
Excel Templates 1:32:40
Freeze Panes 1:35:39
Grouping Worksheets 1:41:01
Page Layout View 1:43:56
Custom Views 1:45:54
Spell Check 1:48:13
Printing 1:49:58

#excel 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.

Google Sheets for Excel Users Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/3yzb7ukw

Who it's for: This accelerated class is meant for experienced users of Excel, who know how to create formulas and apply functions, and who want to learn how to do the same and more in Google Sheets.

What it is: Google Sheets is the spreadsheet application in Google's cloud-based office suite.

What you'll learn: By the end of this course, you’ll learn how to take stock of the knowledge you’ve accumulated in Microsoft Excel over the years and successfully transfer those skills to the world of Google Sheets. In 2+ hours of comprehensive training, learn how to do the following tasks in Google Sheets: create conditional formatting, use privacy tools to limit what users can add or edit in a spreadsheet, share spreadsheets and collaborate in real-time, make interactive sheets and forms to collect information, get real-time financial data from sources like the stock market, create Macros to automate repetitive actions, and build visuals like charts, sparklines, and QR Codes.


Start 0:00
Introduction 0:03
Overview 0:57
Data Validation 3:40
Conditional Formatting 10:37
Named Ranges 15:58
Protected Sheets and Ranges 22:42
Filter Views 28:47
File Version History 34:56
Charts and Sparklines 39:30
Checkboxes 51:33
Forms and Responses 59:22
Importing HTML 1:18:31
Introduction to Queries 1:26:42
SQL and Google Query Overview 1:30:13
SQL Statements 1:42:41
Financial Data 2:00:58
Financial Data Dashboard 2:06:31
Introduction to Macros 2:09:32
Absolute vs Relative Macros 2:13:44
Formatting Macros 2:19:34
Sorting Macros 2:24:21
Apps Script Editor 2:29:23
Conclusion 2:33:59

#googlesheets #googleworkspace #excel 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.

Excel 2021 Productivity Tips and Tricks Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/3wndjyuf

Who it's for: In today's data-driven world, mastering Microsoft Excel has become an essential skill for professionals in various fields. Whether you're a student, an analyst, a business owner, or simply someone who wants to enhance their productivity, this course is designed to take your Excel skills to the next level.

What it is: Excel is much more than just a spreadsheet program - it's a powerful tool that can simplify complex calculations, streamline data management, and present information in visually appealing ways.

What you'll learn: In this course, we will explore a wide range of tips and tricks that will help you work smarter, faster, and more efficiently with Excel. Throughout this course, you will learn how to harness the full potential of Excel's features and functions. We will cover topics such as formulas and functions, data analysis techniques, data validation, pivot tables, and much more. Soon, you’ll be able to perform complex tasks with ease, saving you valuable time and effort in your everyday work.

Start 0:00
Introduction 0:09
Selecting Data 0:33
Flash Fill 2:29
Data Validation 10:34
Data Mining 24:28
Named Ranges 36:45
Pivot Tables 49:24
XLOOKUP 57:47
Power Query 1:02:39
Conclusion 1:09:15

#excel #exceltutorial #exceltips 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.

Excel 2021 Power User Full Course Tutorial (4+ Hours)

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/4kb55kuw

Who it's for: This course was built from the ground up for the advanced users and those in search of more than typical Excel tools and processes. Attendees of this course are recommended to have completed our standard Excel training, or at a minimum already be proficient in the skills referenced in that content.

What it is: The Excel Power User course expands on the idea that the tools by themselves are only part of the equation. To say that you’re capable of solving a problem is enough for most users, but participants in this course aren’t most users. The desire to learn and invest time in building resources that solve problems faster and with less effort is a key quality of the power user and something the course maintains a heavy focus on.

What you'll learn: In this series, students will learn how to intermix tools in Excel to accomplish time-intensive tasks. Students will learn to develop a deeper understanding of data mining tools like VLOOKUP, as well as more advanced solutions like the INDEX, MATCH, and OFFSET functions. Throughout the course, users will learn how to expedite data analysis through dynamic ranges and how to push Excel to the edges of what’s possible out of the box with new perspectives on how to think their way through challenging problems.

You’ll learn how to easily create, modify, and update Pivot Tables and charts. In no time, take a very large dataset and create a table that only displays the information you need. Then, learn all the steps to make your Pivot Tables great: data cleanup, manipulation, aggregate functions, pivot charts, big data, and even "power" features.

Beyond simple averages and totals, Microsoft Excel offers many features to help you draw insights from your data. Sometimes those observations come from a particular formatting or visualization of the data; other times a specific summary function will generate a surprisingly significant result. Learn all about data analytics in Excel with tools like table formatting, conditional functions, charting, pivot tables, and much more.

Learn about VLOOKUP and Index and Match, the precursors to XLOOKUP. We'll talk about what makes those functions fantastic and what makes them lacking in certain areas. Then, we'll explain why XLOOKUP is a huge improvement and how to properly use it to level up your Excel performance.

Start 0:00
Excel Power User Introduction 0:03
DB Functions, XLOOKUP, VLOOKUP, INDEX, MATCH 4:17
Excel XLOOKUP Two-Way Search 18:27
Text Functions 22:00
Advanced Pivot Tables 26:42
INDEX MATCH Array Function 41:11
Advanced Conditional Formats 48:14
Excel Charts 52:57
Introduction to Macros 1:00:19
Macro Examples 1:09:18
Excel Power User Conclusion 1:13:41
Pivot Tables Introduction 1:14:16
Organizing Data in Tables 1:18:42
More Data Organization Techniques 1:26:04
Data Mining 1:30:45
Custom Sort Command and Functions 1:35:28
Merge Data Using XLOOKUP 1:46:15
Pivot Tables - Setup 1:54:48
Pivot Tables - Building Reports 2:02:25
Pivot Tables - Formats, Drilldowns, and Refreshing 2:10:32
Pivot Tables - Designing for Reports and Charts 2:17:37
Pivot Tables - Cal Fields, Items, and Grouping 2:28:22
Power Pivot - Turning It On 2:34:30
Power Pivot - Adding Data and Establishing Relationships 2:36:38
Power Pivot - RELATED Function and Pivot Tables 2:41:44
Pivot Tables Conclusion 2:46:10
Intro to Data Analysis Introduction 2:48:10
Working with Tables 2:51:12
Conditional Formats 3:03:07
Using the IF FUNCTION 3:11:54
Database Functions 3:18:01
Unique, Sort, and Filter Functions 3:22:47
Charts and Sparklines 3:25:56
Working with Pivot Tables 3:34:38
Intro to Data Analysis Conclusion 3:45:10
XLOOKUP Introduction 3:46:17
VLOOKUP Refresher 3:49:03
XLOOKUP Basics 3:56:46
INDEX and MATCH 4:02:06
XLOOKUP - Approx Match Results 4:05:40
XLOOKUP - Returning Multiple Values 4:08:43
XLOOKUP - Two Way Search 4:11:18
XLOOKUP Conclusion 4:14:16



#excel #exceltutorial #exceltips 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.

Excel 2021 XLOOKUP Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/ye233pnt

Who it's for: All Excel users, especially those looking for the next best feature.

What it is: XLOOKUP is a powerful new lookup function in Excel, letting users search for and find items in a table faster than ever before.

What you'll learn: First, you'll learn about VLOOKUP and Index and Match, the precursors to XLOOKUP. We'll talk about what makes those functions fantastic and what makes them lacking in certain areas. Then, we'll explain why XLOOKUP is a huge improvement and how to properly use it to level up your Excel performance.

Start 0:00
Introduction 0:03
VLOOKUP Refresher 3:59
XLOOKUP Basics 11:42
INDEX and MATCH 17:03
XLOOKUP - Approx Match Results 20:36
XLOOKUP - Returning Multiple Values 23:39
XLOOKUP - Two Way Search 26:14
Conclusion 29:12

#excel #exceltutorial #exceltips #xlookup
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.

Excel 2021 Intro to Data Analysis Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/4kb55kuw

Who it's for: Excel users needing to analyze, summarize, and visualize their data. Basic knowledge of Excel (familiarity with formulas, cell referencing, simple functions like SUM and AVERAGE) is recommended.

What it is: Microsoft Excel is the perfect program for viewing and analyzing data.

What you'll learn: Beyond simple averages and totals, Microsoft Excel offers many features to help you draw insights from your data. Sometimes those observations come from a particular formatting or visualization of the data; other times a specific summary function will generate a surprisingly significant result. In this full-length introductory course, learn all about data analytics in Excel with tools like table formatting, conditional functions, charting, pivot tables, and much more.


Start 0:00
Introduction 0:03
Working with Tables 3:51
Conditional Formats 15:46
Using the IF Function 24:33
Database Functions 30:41
Unique, Sort, and Filter Functions 35:27
Charts and Sparklines 38:35
Working with Pivot Tables 47:17
Conclusion 57:50

#excel #exceltutorial #exceltips #dataanalysis #dataanalytics #pivottable
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.

Excel 2021 Pivot Tables Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/4v7zd9md

Who it's for: Anyone who uses Excel and wants to learn one of the most powerful tools Excel offers.

What it is: Pivot Tables helps you easily take a very large dataset and create a table that only displays the information you need.

What you'll learn: You’ll learn how to easily create, modify, and update Pivot Tables and charts.

Start 0:00
Introduction 0:03
Organizing Data in Tables 5:55
More Data Organization Techniques 13:17
Data Mining 17:58
Custom Sort Command and Functions 22:42
Merge Data Using XLOOKUP 33:28
Pivot Tables - Setup 42:01
Pivot Tables - Building Reports 49:38
Pivot Tables - Formats, Drilldowns, and Refreshing 57:45
Pivot Tables - Designing for Reports and Charts 1:04:50
Pivot Tables - Cal Fields, Items, and Grouping 1:15:35
Power Pivot - Turning It On 1:21:43
Power Pivot - Adding Data and Establishing Relationships 1:23:51
Power Pivot - RELATED Function and Pivot Tables 1:28:57
Conclusion 1:33:23

#excel #exceltutorial #exceltips #pivottables
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.

Excel 2021 Power User Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Exercise Files: https://tinyurl.com/yrhs4s9j

Who it's for: This course was built from the ground up for the advanced users and those in search of more than typical Excel tools and processes. Attendees of this course are recommended to have completed our Excel Beginner, Intermediate, and Advanced training, or at a minimum already be proficient in the skills referenced in those courses.

What it is: The Excel Power User course expands on the idea that the tools by themselves are only part of the equation. To say that you’re capable of solving a problem is enough for most users, but participants in this course aren’t most users. The desire to learn and invest time in building resources that solve problems faster and with less effort is a key quality of the power user and something the course maintains a heavy focus on.

What you'll learn: In this series, students will learn how to intermix tools in Excel to accomplish time-intensive tasks. Students will learn to develop a deeper understanding of data mining tools like VLOOKUP, as well as more advanced solutions like the INDEX, MATCH, and OFFSET functions. Throughout the course, users will learn how to expedite data analysis through dynamic ranges and how to push Excel to the edges of what’s possible out of the box with new perspectives on how to think their way through challenging problems.

Start 0:00
Introduction 0:03
DB Functions, XLOOKUP, VLOOKUP, INDEX, MATCH 5:11
Excel XLOOKUP Two-Way Search 19:21
Text Functions 22:54
Advanced Pivot Tables 27:36
INDEX MATCH Array Function 42:05
Advanced Conditional Formats 49:08
Excel Charts 53:51
Introduction to Macros 1:01:13
Macro Examples 1:10:12
Conclusion 1:14:35

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

#excel #exceltutorial #exceltips
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.

Excel 2021 Full Course Tutorial (3+ Hours)

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

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.

Excel 2021 Expert Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

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
Nesting Functions 4:24
Database Functions 12:16
XLOOKUP 20:47
UNIQUE 28:39
SORT and SORTBY 34:30
FILTER 40:24
LET 46:54
Consolidate 52:19
Introduction to Macros 57:03
Recording and Playing Macros 59:38
Conclusion 1:05:03

#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.

Excel 2021 Advanced Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

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
Formatting Lists as Tables 2:03
Flash Fill 10:59
Custom Sorting 13:46
Subtotals 17:59
QA Tool 22:38
Data Charts 25:45
Sparklines 33:13
Introduction to Pivot Tables 38:10
Advanced Pivot Tables Options 50:16
Data Validation 57:45
Conditional Formats 1:04:18
Comments and Notes 1:10:49
Linking Data 1:13:24
Privacy and Protection 1:16:25
Conclusion 1:20:00

#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.

Excel 2021 Beginner Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

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

#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.

Excel for Finance and Accounting Expert Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/rxvb4utb

Who it's for: Professionals using Excel to tackle practical tasks around financial data.

What it is: Microsoft’s spreadsheet application used to clean, organize, and present data.

What you'll learn: This course begins with a brief Excel refresher before moving on to a series of Finance and Accounting tips to improve your day-to-day workflow. First, we’ll explore common functions like NPV, IRR, and IPMT. Then, you’ll learn how to create a variety of charts to visually represent your data like stock charts, area charts, and even football field charts. Next, you’ll refamiliarize yourself with some key Excel tools like Pivot Tables to maximize your time in the application. Finally, we’ll show you how all of this works in the real world with comprehensive exercises around income statements, balance sheets, cash flow statements, and much more.

Start 0:00
Introduction 0:09
Building Data Rates 1:20
Calculating HPR Rates of Return 4:23
Statement Model 10:39
Income Statements 12:29
Operating Costs 21:06
Operating Expenses and Interest 24:57
Taxes 26:47
Net Income 28:47
Capital Expenditure and Depreciation Schedule 31:27
Setting Up Balance Sheets 37:11
Balance Sheet Forecasts 40:33
Cash Flow Statements 54:15
Statement Model Check 1:04:21
Conclusion 1:06:22

#excel #exceltutorial #exceltips #exceltricks
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.