Microsoft Office & Productivity
In this Microsoft Excel 2016 training video you will learn how fix your printing issues. Are you having printing woes? Watch this Excel 2016 tutorial and learn how to correct them now.
Please subscribe to our YouTube channel, and visit our website http://learnitanytime.com to watch the latest in Excel training videos.
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.
Microsoft Excel 2016 Learn how Merge Spreadsheets tutorial. In this Excel 2016 tutorial you lean how to save time by Merging Spreadsheets.
For more Excel 2016 tutorials visit http://learnitanytime.com, and please subscribe to our YouTube Channel.
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.
In this Excel 2016 training video we look at Pivot Tables, you will learn the basics about Pivot tables in Excel 2016, and also some advanced ways to set up and use them.
Please subscribe to our Youtube channel, and check out our website to get the latest in Excel training videos at http://learnitanytime.com
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 Power User 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://bit.ly/46VQwi7
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 2016 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 to Dynamic Range Charts 0:03
Dynamic Range Chart Data 3:36
Defining Dynamic Named Ranges 9:11
Defining Dynamic Legend Entries 14:45
Defining Dynamic Category Labels 18:58
Dynamic Offset 21:30
Updating Dynamic Named Ranges 28:18
Enabling the Developer Tab 31:03
Inserting Spinner Buttons 32:35
Linking Spinner Buttons 34:36
Outside Formulas in Pivot Tables 38:40
Calculated Fields 44:44
Calculated Items 49:37
Removing Calculated Fields and Items 53:54
Grouping Pivot Items 55:32
Showing Values As 57:57
Importing Web Data 1:01:02
Recording Macros 1:06:08
Running Macros and Selecting Fields of Data 1:12:19
Editing VBA Code 1:19:05
#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 Power User 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://bit.ly/46VQwi7
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 2016 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
VLOOKUP 0:03
Range Lookup 7:45
Autofilling Lookup 10:41
Defining Names 14:06
Using Named Ranges to Retrieve Data 17:18
INDEX 22:11
MATCH 27:41
INDEX & MATCH (Part 1) 30:28
INDEX & MATCH (Part 2) 34:27
INDEX & MATCH (Part 3) 40:23
Introduction to Array Formula 44:00
Array Formula 46:20
Array Function 51:49
Dynamic Named Ranges (Offset) 1:01:03
OFFSET Function 1:05:30
Name Manager 1:12:52
Basic Conditional Formatting 1:18:37
Building New Rules and Troubleshooting 1:22:06
Expanding Conditional Formatting Fields 1:30:39
Text Search Conditional Formatting 1:33:14
Data Validating Conditional Formatting 1:40:16
#excel #vlookup
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 2016 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://bit.ly/4nYb5R4
Who it's For: Anyone currently using Microsoft Excel, or anyone who wants to learn how!
What it is: Excel is a popular Microsoft application that organizes and analyzes data.
What You'll Learn:
Our beginner videos start with simple tasks like selecting cells and entering data, then quickly move to calculating data with basic formulas and functions. The intermediate portion shows you how simple it is to sort and filter and then moves to one of Excel’s most popular features, Pivot Tables. Our advanced videos start with functions like IF and VLOOKUP and finish up with Macros.
Start 0:00
Named Ranges 0:03
Creating Named Ranges from Selection 5:24
Named Ranges (Continued) 8:31
IF Functions 11:15
Formula Auditing Tools 19:26
IF Functions (Continued) 26:05
Nesting Functions 30:51
VLOOKUP 38:42:19
Autofill VLOOKUP & IFERROR 47:20
VLOOKUP Range 54:01
VLOOKUP Range with Nested Functions 59:31
HLOOKUP 1:07:27
SUMIF 1:11:17
AVERAGEIF 1:19:20
SUMIFS 1:23:12
Date Functions 1:27:47
Text Functions 1:34:27
Consolidating Data 1:41:00
Consolidating Data Without Structure 1:45:28
Complex Solver Tool 1:48:27
Solver Tool 1:54:09
Scenario Manager 2:02:11
Data Table 2:09:38
Turning on the Developer Tab 2:16:08
Recording Macros 2:18:18
Editing Macros in VBA & Recording a Second Macro 2:23:46
Adding Macros to the QA Toolbar 2:31:27
Adding Macro Buttons to the Worksheet 2:33:46
Conclusion 2:36:52
#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 2016 Intermediate 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: http://bit.ly/42EQloU
Who it's For: Anyone currently using Microsoft Excel, or anyone who wants to learn how!
What it is: Excel is a popular Microsoft application that organizes and analyzes data.
What You'll Learn: Our beginner videos start with simple tasks like selecting cells and entering data, then quickly move to calculating data with basic formulas and functions. The intermediate portion shows you how simple it is to sort and filter and then moves to one of Excel’s most popular features, Pivot Tables. Our advanced videos start with functions like IF and VLOOKUP and finish up with Macros.
Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Flash Fill 0:03
List Design & Single Level Sorting 2:28
Multi-Level Sorting 4:52
Custom Sorting 8:20
Filtering 11:33
Multi-Level Filtering 15:40
Search Filtering 17:34
Format as Table 21:47
Table Style Options 25:13
Remove Duplicates 29:12
Convert to Range 34:07
Subtotal 34:51
Multi-Level Subtotaling 40:32
Remove Subtotals 42:59
Quick Analysis Charts 43:29
Inserting Data Charts 46:53
Formatting Data Charts 51:46
Chart Templates 57:21
Sparklines 1:01:28
Printing Charts 1:06:18
Importing From Web 1:08:18
MS Query 1:14:33
Exporting Overview 1:21:12
Pivot Tables 1:22:50
Multiple-Field Pivot Tables 1:31:03
Drill Down Reports 1:36:10
Pivot Charts & Grouping Fields 1:38:52
Slicer Tool 1:47:18
Data Validation 1:54:28
Additional Data Validation 2:03:12
Cell & Sheet Protection 2:09:30
File Encryption 2:14:58
Conditional Formatting 2:17:28
Linking Data 2:25:34
Inserting Comments 2:32: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.
Microsoft Excel 2016 - Learn Excel 2016 Beginners Tutorial Video
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/y2n7rkc6
Learn Microsoft 2016 from the pro's. In this FREE beginners tutorial for Microsoft 2016 you will learn the basics of Excel 2016, and Tips and Tricks so that you can get the most out of your Excel experience. Our beginner videos start with simple tasks like selecting cells and entering data, then quickly move to calculating data with basic formulas and functions. The intermediate portion shows you how simple it is to sort and filter and then moves to one of Excel’s most popular features, Pivot Tables. Our advanced videos start with functions like IF and VLOOKUP and finish up with Macros.
Some of the other topics in the Microsoft Excel 2016 tutorial include:
Start Screen & Templates, Ribbon & QA Toolbar - Part 1, Ribbon & QA Toolbar - Part 2, Backstage View, Interface, Share Pane, Tell Me, Smart Lookup, Navigating, Keyboard Shortcuts, Entering Text
Formatting Numbers, Deleting & Formatting, AutoSum, Simple Formulas, Simple Functions, Absolute Referencing, Inserting Rows
Inserting Columns, Moving & Copying Data, Autofill, Cell Styles, Worksheet Themes, Excel Templates, Grouping Worksheets, Freeze Panes, Custom Views, Spell Check, Printing, Flash Fill, List Design & Single Level Sorting, Multi-Level Sorting, Custom Sorting, Filtering, Multi-Level Filtering, Search Filtering, Format as Table, Table Style Options, Remove Duplicates, Convert to Range, Subtotal, Multi-Level, Subtotaling, Remove Subtotals, Quick Analysis Charts, Inserting Data Charts, Formatting Data Charts, Chart, Templates, Spark lines, Printing Charts, Importing From Web, MS Query, Exporting Overview, Pivot Tables, Multiple-Field Pivot Tables, Drill Down Reports, Pivot Charts & Grouping Fields, Slicer Tool, Data Validation - Part 1, Data Validation - Part 2, Cell & Sheet Protection, File Encryption, Conditional Formatting, Linking Data, Inserting Comments.. and more
Please subscribe to Learn iT! and check out our website (http://learnit.com) to browse other Microsoft Courses, Project Management, and IT Training courses.
#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.
Tutorial Para Principiante de Excel 2021
Archivos de ejercicios: https://tinyurl.com/4h4wpbev
Únete a Learnit Anytime para obtener capacitación y certificados sin publicidad:
https://www.learnitanytime.com
Empezar 0:00
Introducción 0:03
Pantalla de inicio 2:35
Interfaz de Excel 7:03
Zoom, navegación y accesos directos 13:31
Realización de cálculos de Excel 28:19
Funciones sencillas de Excel 36:53
Funciones ABS, REF y Autocompletar 42:25
Comprobación de compatibilidad 47:51
Insertar, mover y cortar 49:29
Estilos de celda 54:30
Temas 59:41
Mostrar y ocultar hojas de trabajo 1:03:16
Agrupar hojas de trabajo 1:06:19
Congelar paneles 1:08:45
Vistas personalizadas 1:14:15
Guardar plantillas 1:16:09
Corrector ortográfico 1:18:36
Vista previa de impresión 1:20:09
Conclusión 1:23:17
#excel #excel2021 #exceltutorial #dubbedwithaloud
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.
This video has been dubbed into Spanish (United States) using an artificial voice via https://aloud.area120.google.com to increase accessibility. You can change the audio track language in the Settings menu.
Este video ha sido doblado al español con voz artificial con https://aloud.area120.google.com para aumentar la accesibilidad. Puede cambiar el idioma de la pista de audio en el menú Configuración.
XLOOKUP Excel 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 File: https://tinyurl.com/mr2dpmxa
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
Introduction to VLOOKUP 2:31
VLOOKUP Limitations 10:29
Introduction to Index and Match 14:13
Introduction to XLOOKUP 23:04
XLOOKUP - Approximate Match 28:44
XLOOKUP - Multiple Values Returned 31:14
XLOOKUP - Two Way Search 33:32
Conclusion 37:47
#xlookup #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 VBA 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/m6bvnx4w
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.
Start 0:00
Worksheets Methods 0:03
DateSerial and Format 3:28
Sheet Template Generator 13:32
Move 20:21
PrintOut and PrintPreview 23:40
Practice (Part 1) 25:51
Practice (Part 2) 34:20
Practice (Part 3) 35:54
Practice (Part 4) 37:38
Practice (Part 5) 41:11
Practice (Part 6) 51:48
Custom Functions (Part 1) 54:18
Custom Functions (Part 2) 1:01:01
Custom Functions (Part 3) 1:04:32
Wrapping Up 1:14:07
#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 VBA 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/m6bvnx4w
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.
Start 0:00
Variables 0:03
Variable Rules 7:59
For Next Loop Basics 11:18
For Next Loop Doubled 15:44
For Next Loop Triple 19:47
For Each Loop 22:11
Exit For Statement 23:50
Do While Loop 27:07
Do While Not Empty Loop 30:32
Do Until Loop 32:53
Do Loop UNTIL 35:11
Count and Offset 36:49
End, Address, Call Statement 48:23
Practice 55:35
Using the FIND Tool in a Macro 1:03:47
Message Boxes 1:14:50
Input Boxes 1:22:58
Code Continuation Character and vbCrLf Constant 1:27:16
If Then, ElseIF, and Else 1:33:44
Select Case 1:40:13
Multiple Variables 1:42:58
Practice 1:46:09
#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 VBA 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/m6bvnx4w
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.
Start 0:00
Introduction 0:03
What is VBA? 1:44
Object Oriented Programming Languages 5:59
Turning on the Developer Tab 10:17
The Macro Recorder 13:40
Using Relative References 20:39
Recording Simple Macros 27:51
Multi-Step Macro Recording 39:25
Sort and Filter Macro Recording 45:26
Protecting and Formatting Sheets with the Macro Recorder 51:35
VBA Interface Setup 55:09
Recorder Code vs. Manual Code 1:01:11
Introduction to Editing Macros 1:12:28
Debugging Macros 1:16:53
Grammar in VBA 1:28:00
Macro Scripting Basics 1:33:04
Range 1:40:41
Selection & Color 1:47:14
Value and Clear 1:52:16
ActiveSheet, Sheets, and Name 1:54:01
CurrentRegion 1:56:40
Practice 1:58:08
#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 Full Course Tutorial (7+ Hours)
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
VBA Overview/Getting Started 2:06
Procedures and Functions 1:06:26
Expressions, Variables, and Intrinsic Functions 2:12:27
Controlling Program Execution 3:28:45
Forms and Controls 4:40:59
Pivot Tables in VBA 5:27:53
Code Debugging 6:22:25
#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 Expert 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 Code Debugging 1:23
The Three Types of Errors and Their Causes 3:41
Overview of Debugging Tools 6:26
Overview of Step Debugging Tools 8:27
Forcing and Resolving Two Syntax Errors 9:23
Setting Manual Breakpoints and Entering Break Mode 11:36
Using Step Debugging Tools 14:21
Setting Manual Breakpoints and Running Procedures Until Execution Stops 16:35
Using the Locals Window and the Quick Watch Window in Break Mode 17:07
Overview of Error Handling 20:40
Finding the Source of Run Time Errors 25:09
Using the On Error Go To Statement 26:49
Reviewing Error Handling Code 30:49
Testing Error Traps and Using The On Error Resume Next Statement 32:00
Testing the On Error Resume Next Trap 35:49
Tips for Minimizing Errors 37:45
How to Use the Object Browser38:38
Password Protecting Code 41:57
Code Debugging Recap 43:48
Conclusion 45:26
#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 Advanced 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 Forms and Controls 1:41
UserForm Object-Controls-Properties-Events-Methods 2:36
Reviewing Types of Modules and Inserting UserForm Objects 5:19
Changing Form Properties 8:39
Creating a Label Control and Adjusting its Properties 10:15
Copying a Label Control to Create a New One 13:10
Adding Two Text Box Controls to Forms 14:12
Adding Two Command Button Controls to Forms 16:01
Adding a Combo Box Control and Label 19:21
Adding Two Frame Controls with Three Option Buttons in Each 21:43
Adjusting Option Button Properties 25:16
Aligning and Grouping Form Controls 27:13
Testing and Adjusting Form Tab Order 30:07
Coding the Combo Box to Display Months 34:05
Coding Other Form Controls Using Text Files 38:47
Reviewing Coding in Text Files 41:23
Displaying the Form Programmatically 44:01
Forms and Controls Recap 47:39
Introduction to Pivot Tables in VBA 48:35
Introduction to Creating Pivot Tables 49:18
Creating Pivot Tables by Recording a Macro 52:39
Creating Pivot Tables 57:43
Testing CreatePivot Sub-Procedure 1:01:23
Creating Sub-Procedures to Set Pivot Table Fields 1:02:05
Finalizing Forms 1:09:42
Creating Sub-Procedures to Code Options in the Period Frame on Forms 1:13:17
Reviewing GetLastDate and GetFirstDate Code Blocks from Text Files 1:17:28
Coding Options in the Sales Frame on the Form 1:20:10
Reviewing Text File Procedures - ConsolidateData-GrabCells-FinishReport 1:22:39
Completing Code Modifications for Form Objects 1:26:10
Testing Completed Forms 1:31:12
Adding Icons to the QAT to Run the Form 1:35:55
Pivot Tables Recap 1:38:54
Conclusion 1:41:37
#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.
