Course Search | United Training Site Search

Filter by Delivery Method
Live, instructor-led, standard length classes.
Live, instructor-led, one hour classes.
On Demand microlearning videos
 
Microsoft Excel for Office 365 (Desktop or Online) - Part 1
This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation. This course covers Microsoft Office Specialist Program exam o…
VILT 1 Day
Microsoft Excel for Office 365 (Desktop or Online) - Part 2
This course builds upon the foundational knowledge presented in the Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1 course and will help start you down the road to creating advanced workbooks and worksheets tha…
VILT 1 Day
Microsoft Excel for Office 365 (Desktop or Online) - Part 3
In this course, you will build upon the foundational and intermediate knowledge presented in the Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1 and Microsoft® Excel® for Office 365™ (Desktop or Online): Part 2…
VILT 1 Day
Excel for Office 365 - Data Analysis with Pivot Tables
Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze data and gain actionable insight is greater than ever. You already have experience working with Micr…
VILT 1 Day
Excel for Office 365 - Data Analysis with PowerPivot
We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze…
VILT 1 Day
Excel 365 Getting Started with Excel
In this course, students will learn how to create spreadsheets that look professional and work properly. This course includes a tour of the Excel interface as well as lessons on the basics of creating new workbooks, working …
LNL 1 Hour
Excel 365 Advanced Lookup Functions
This course is a more advanced session on lookup functions in Microsoft Excel. Students will use the VLOOKUP function in a variety of different ways to quickly find answers within a dataset. The course will also introduce a …
LNL 1 Hour
Excel 365 Analyzing Excel Data with Lookup Functions
This course is an introduction to lookup functions in Microsoft Excel. Students will learn about a few different types of lookup functions, when to use each one, and how to use them to quickly find answers within a dataset. …
LNL 1 Hour
Excel 365 Automating with Macros
This course gives an introduction to macros in Microsoft Excel. Using macros, you can automate repetitive tasks and gain more control over how you work with data. This course focuses on the basics of creating and running mac…
LNL 1 Hour
Excel 365 Calculating and Analyzing Data with IF Statements
In this course, students will learn how to apply conditional logic to data using formulas, which allows for in-depth data analysis. This can mean anything from checking whether ranges of data meet certain criteria, to applyi…
LNL 1 Hour
Excel 365 Creating Easy to Read Spreadsheets
This course gives an in-depth look at formatting worksheets to make them more professional, more readable, and more user-friendly. Students will learn how to use a variety of tools to improve a worksheet’s design as well as …
LNL 1 Hour
Excel 365 Mastering the XLOOKUP Function
This course is a deep dive into the new XLOOKUP function. Students will learn about the different uses for XLOOKUP. The lessons in this course provide examples of how to use XLOOKUP to do vertical and horizontal lookups, ret…
LNL 1 Hour
Excel 365 New Features
This course discusses the new features and tools within Excel 365. Users will learn about new data enhancements, precision selecting, sharing documents, new chart types, new functions, productivity enhancements, graphic enha…
LNL 1 Hour
Excel 365 PivotTables - Beyond the Basics
This course provides students with the information necessary to create and modify a PivotTable. Students will learn how to calculate, format, and filter within a PivotTable. Information is also included regarding PowerPivot,…
LNL 1 Hour
Excel 365 Using PivotTables to Present Interactive Data
This course is an introduction to using PivotTables, a fast and versatile way to summarize and analyze complex sets of data. This course covers the basics of how to create and organize PivotTables as well as some general inf…
LNL 1 Hour
Excel 365 Working with Dates and Text
In this course, students will learn how to use date and text functions. This will allow users to manipulate text and ensure that formulas using dates are properly calculated. Students will also learn how to utilize the Flash…
LNL 1 Hour
Excel 365 - Advanced
This course will teach students advanced concepts and formulas in Microsoft Excel 365. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. A…
LNOD 4 h, 19 min
Excel 365 - Beginner
Microsoft Excel is one of the major workhorses in the Microsoft 365 suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most…
LNOD 4 h, 46 min
Excel 365 - Intermediate
In this course, students will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. Students will also apply conditional formatting, outline with…
LNOD 4 h, 30 min
Excel 365 VBA - Expert
This course will teach students proper Visual Basic programming techniques along with an understanding of Excel's object structure. Students will learn how to work with variables, how to use various conditional logic stateme…
LNOD 5 h, 5 min
Excel 2019 - Part 1
This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation. Excel can help you organize, calculate, analyze, revise, update,…
VILT 1 Day
Excel 2019 - Part 2
This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2019: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your u…
VILT 1 Day
Excel 2019 - Part 3
This course builds upon the foundational and intermediate knowledge presented in the Microsoft® Office Excel® 2019: Part 1 and Microsoft® Office Excel® 2019: Part 2 courses to help you get the most of your Excel experience. …
VILT 1 Day
Excel 2019 Getting Started with Excel
In this course, students will learn how to create spreadsheets that look professional and work properly. This course includes a tour of the Excel interface as well as lessons on the basics of creating new workbooks, working …
LNL 1 Hour
Excel 2019 Advanced Lookup Functions
This course is a more advanced session on lookup functions in Microsoft Excel. Students will use the VLOOKUP function in a variety of different ways to quickly find answers within a dataset. The course will also introduce a …
LNL 1 Hour
Excel 2019 Analyzing Excel Data with Lookup Functions
This course is an introduction to lookup functions in Microsoft Excel. Students will learn about a few different types of lookup functions, when to use each one, and how to use them to quickly find answers within a dataset. …
LNL 1 Hour
Excel 2019 Automating with Macros
This course gives an introduction to macros in Microsoft Excel. Using macros, you can automate repetitive tasks and gain more control over how you work with data. This course focuses on the basics of creating and running mac…
LNL 1 Hour
Excel 2019 Calculating and Analyzing Data with IF Statements
In this course, students will learn how to apply conditional logic to data using formulas, which allows for in-depth data analysis. This can mean anything from checking whether ranges of data meet certain criteria, to applyi…
LNL 1 Hour
Excel 2019 Creating Easy to Read Spreadsheets
This course gives an in-depth look at formatting worksheets to make them more professional, more readable, and more user-friendly. Students will learn how to use a variety of tools to improve a worksheet’s design as well as …
LNL 1 Hour
Excel 2019 New Features
This course discusses the new features and tools within Excel 2019. Users will learn about the new chart types, precision selecting, new functions, automatic time grouping in PivotTables, new productivity enhancements, new g…
LNL 1 Hour
Excel 2019 PivotTables - Beyond the Basics
This course provides students with the information necessary to create and modify a PivotTable. Students will learn how to calculate, format, and filter within a PivotTable. Information is also included regarding PowerPivot,…
LNL 1 Hour
Excel 2019 Using PivotTables to Present Interactive Data
This course is an introduction to using PivotTables, a fast and versatile way to summarize and analyze complex sets of data. This course covers the basics of how to create and organize PivotTables as well as some general inf…
LNL 1 Hour
Excel 2019 Working with Dates and Text
In this course, students will learn how to use date and text functions. This will allow users to manipulate text and ensure that formulas using dates are properly calculated. Students will also learn how to utilize the Flash…
LNL 1 Hour
Excel 2019 - Advanced
This course will teach students advanced concepts and formulas in Microsoft Excel 2019. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. …
LNOD 3 h, 58 min
Excel 2019 - Beginner
Microsoft Excel is one of the major workhorses in the Microsoft 365 suite of applications and arguably the most widely-used 365 product. A solid understanding of how to use this program is vital to nearly everyone in most in…
LNOD 5 h, 29 min
Excel 2019 - Intermediate
In this course, students will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. Students will also apply conditional formatting, outline with…
LNOD 4 h, 40 min
Excel 2016 - Part 1
This course aims to provide students with a foundation for Excel knowledge and skills, which they can build upon to eventually become an expert in data manipulation.
VILT 1 Day
Excel 2016 - Part 2
This course builds upon the knowledge presented in the Microsoft® Office Excel® 2016: Part 1 course and helps start students down the road to creating advanced workbooks & worksheets that can help deepen their understanding.
VILT 1 Day
Excel 2016 - Part 3
This course builds off of the foundational and intermediate knowledge presented in the Microsoft® Office Excel® 2016: Part 1 and Part 2 courses to help you get the most of your Excel experience. The ability to collaborate wi…
VILT 1 Day
Data Analysis using Excel 2016 – Level 1
Report Builders will learn everything they need to create highly effective PivotTable and PivotChart reports using data sources that are created using Excel. Topics covered include an overview of the PowerPivot add-in, creat…
VILT 2 Days
Data Model Design using Excel 2016 - Level 2
This course is designed for Power BI for Excel Designers who are ready to create custom data models for themselves and for other Power BI Designers.
VILT 1 Day
Excel 2013/2016 Programming with VBA
VILT 3 Days
Excel 2016 - Tables, Pivot Tables and Conditional Formatting
In This Course, students will analyze Excel data, create PivotTables, Pivot Charts as well as Analyzing Pivot Tables.
VILT 0.5 Days
Excel 2016 Formulas & Charts
In This Course, students will analyze Excel data, create Formulas, Charts and Data to Support Excel Spreadsheets and Workbooks.
VILT 0.5 Days
Excel 2016/2019 - Data Analysis with Pivot Tables
Being able to harness the power of PivotTable features & create PivotCharts will help students gain an edge. Not only will students be able to summarize data to analyze, but they can organize the data in a way that can be me…
VILT 1 Day
Excel 2016/2019 - Data Analysis with Power Pivot
Excel provides Power Pivot to help students organize, manipulate, and report on their data in the best way possible. In this course, students gain a solid understanding of Power Pivot to maximize their effectiveness when ana…
VILT 1 Day
Introduction to DAX for Excel 2016 Users - Level 3
This course is built for Power BI for Excel Designers that will be responsible for taking basic PowerPivot data models turning them into power business intelligence solutions.
VILT 2 Days
Excel 2016 Advanced Lookup Functions
This course is a more advanced session on lookup functions in Microsoft Excel. Students will use the VLOOKUP function in a variety of different ways to quickly find answers within a dataset. The course will also introduce a …
LNL 1 Hour
Excel 2016 Analyzing Excel Data with Lookup Functions
This course is an introduction to lookup functions in Microsoft Excel. Students will learn about a few different types of lookup functions, when to use each one, and how to use them to quickly find answers within a dataset. …
LNL 1 Hour
Excel 2016 Automating with Macros
This course gives an introduction to macros in Microsoft Excel. Using macros, you can automate repetitive tasks and gain more control over how you work with data. This course focuses on the basics of creating and running mac…
LNL 1 Hour
Excel 2016 Building a Spreadsheet
In this course, students will learn how to create spreadsheets that look professional and work properly. This course includes a tour of the Excel interface as well as lessons on the basics of creating new workbooks and worki…
LNL 1 Hour
Excel 2016 Calculating and Analyzing Data with IF Statements
In this course, students will learn how to apply conditional logic to data using formulas, which allows for in-depth data analysis. This can mean anything from checking whether ranges of data meet certain criteria, to applyi…
LNL 1 Hour
Excel 2016 Check it and Protect it - Auditing and Protecting Workbooks
This course is designed to teach students how to prevent errors in their worksheets. Students will learn how to use various tools to evaluate formulas and how to encrypt data with passwords to prevent unwanted changes in ord…
LNL 1 Hour
Excel 2016 Creating Easy to Read Spreadsheets
This course gives an in-depth look at formatting worksheets to make them more professional, more readable, and more user-friendly. Students will learn how to use a variety of tools to improve a worksheet’s design as well as …
LNL 1 Hour
Excel 2016 Creating Interactive Reports with PivotCharts
This course is designed to teach students everything they need to know about PivotCharts to use them effectively with their data. Students will learn about how PivotCharts work, as well as how to create, modify, filter, and …
LNL 1 Hour
Excel 2016 Discovering and Presenting Trends with Charts
This course is an introduction to data visualization with charts. Students will learn about the different types of charts, how to create them, and how to modify and format them to best reflect the data they represent. Studen…
LNL 1 Hour
Excel 2016 Ensuring Data Integrity
This course is designed to help students learn to collaborate with other users and edit their work. The tools focused on in the class are targeting at locating and modifying data and working with others to participate in the…
LNL 1 Hour
Excel 2016 Managing and Delivering Workbooks
This course enables students to navigate within the Excel file, while also discussing organizational aspects within a workbook. The class includes proofing tools and options to consider in producing a polished, final product…
LNL 1 Hour
Excel 2016 New Features
This course discusses the new features and tools within Excel 2016. Users will learn about the Tell Me feature, flash fill, new chart options, and other features used to analyze data.
LNL 1 Hour
Excel 2016 PivotTables - Beyond the Basics
This course provides students with the information necessary to create and modify a PivotTable. Students will learn how to calculate, format, and filter within a PivotTable. Information is also included regarding PowerPivot,…
LNL 1 Hour
Excel 2016 Using Automated Analysis Tools
This course is designed to provide students with understanding of the Automated Analysis Tools: Data Tables, Scenarios, Goal Seek, Solver, and the Analysis ToolPak. Each of these components are used to analyze and investigat…
LNL 1 Hour
Excel 2016 Using PivotTables to Present Interactive Data
This course is an introduction to using PivotTables, a fast and versatile way to summarize and analyze complex sets of data. This course covers the basics of how to create and organize PivotTables as well as some general inf…
LNL 1 Hour
Excel 2016 Working Together - Connecting Worksheets and Workbooks
This course focuses on working with worksheets and workbooks, using linking techniques. It provides the user with information regarding efficient and effective methods for analyzing multiple worksheets and workbooks. Student…
LNL 1 Hour
Excel 2016 Working with Dates and Text
In this course, students will learn how to use date and text functions. This will allow users to manipulate text and ensure that formulas using dates are properly calculated. Students will also learn how to utilize the Flash…
LNL 1 Hour
Excel 2016 - Advanced
This course will teach students advanced concepts and formulas in Microsoft Excel 2016. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. …
LNOD 2 h, 18 min
Excel 2016 - Beginner
Microsoft Excel is one of the major workhorses in the Microsoft 365 suite of applications and arguably the most widely-used 365 product. A solid understanding of how to use this program is vital to nearly everyone in most in…
LNOD 3 h, 45 min
Excel 2016 - Intermediate
This course is designed to be the intermediate level of Excel 2016. Students will learn how to link workbooks and worksheets, work with named ranges, and intermediate Logical and Lookup functions and formulas. Students will …
LNOD 4 h, 0 min
Excel 2013 - Data Analysis with Pivot Tables
Analyzing data and gaining insight is important. You have experience creating PivotTables but Excel is capable of doing more. In this course, students will learn how to organize data in a way that can be meaningfully present…
VILT 1 Day
Excel 2013 - Advanced
This course will teach students advanced concepts and formulas in Microsoft Excel 2013. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. …
LNOD 2 h, 52 min
Excel 2013 - Beginner
Microsoft Excel is one of the major workhorses in the Microsoft 365 suite of applications and arguably the most widely-used 365 product. A solid understanding of how to use this program is vital to nearly everyone in most in…
LNOD 4 h, 38 min
Excel 2013 - Intermediate
This course is designed to be the intermediate level of Excel 2013. Students will learn intermediate functions and formulas, be introduced to and work with PivotTables and Tables, work with Charts, work with Flash Fill, work…
LNOD 4 h, 6 min
Excel 2010 - Part 1
In this course, students will use Microsoft Office Excel 2010 to create spreadsheets and workbooks that they can use to store, manipulate, and share data.
VILT 1 Day
Excel 2010 - Advanced
This course delves into a variety of topics beyond the basics. You will learn how to use a wide range of financial, logical, text, and statistical functions; analyze data with the scenario manager; apply conditional formatti…
LNOD 3 h, 6 min
Excel 2010 - Beginner
This course is designed to teach students the fundamentals of Excel. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions …
LNOD 3 h, 46 min
Excel 2010 - Intermediate
In this course, you will learn how to use multiple worksheets and workbooks efficiently. You will also learn how to create outlines and subtotals, how to create and apply Range Names, and how to create and format charts. You…
LNOD 3 h, 31 min
Excel 2007 - Advanced
This course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you learn how to analyze and manage your data. You will explore the many data analysis tools avail…
LNOD 3 h, 13 min
Excel 2007 - Beginner
This class teaches the basic functions and features of Excel 2007. After an introduction to spreadsheet terminology and Excel's window components, you will learn how to use the Help system and navigate worksheets and workboo…
LNOD 3 h, 0 min
Excel 2007 - Intermediate
This course is designed to expand on the skills learned in the Introduction to Excel 2007 training. Specifically, this class will focus on using multiple sheets in a workbook, the advantages of working with range names, crea…
LNOD 2 h, 24 min
Excel VBA 2007 - Expert
This course introduces you to Excel Macro programming using Microsoft's Visual Basic for Applications (VBA). The overall focus of this course is to teach you proper Visual Basic programming techniques along with an understan…
LNOD 4 h, 13 min
Excel VBA 2010 - Expert
The overall focus of this course is to teach the user proper Visual Basic programming techniques along with an understanding of Excel’s object structure. Other topics in this course include: proper variable declaration, co…
LNOD 5 h, 35 min
10994 Data Analysis Fundamentals using Excel
Note: This course is being retired by Microsoft on December 31, 2021.

The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to prov…
VILT 2 Days
20779 Analyzing Data with Excel
Note: This course is being retired by Microsoft on December 31, 2021.

The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes …
VILT 3 Days
Data Analysis and Visualization with Microsoft Excel
Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in v…
VILT 2 Days
Programming and Data Wrangling with VBA and Excel
VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft® Excel® and other applications in the Microsoft® Office application suite. You can use VBA to perform tasks that would be di…
VILT 3 Days
Microsoft Office 365 Online (with Teams for the Desktop)
This course introduces working with shared documents in the familiar Office 365 online apps—Word, PowerPoint®, and Excel®—as an alternative to installing the Microsoft® Office desktop applications. This course also introduce…
VILT 1 Day