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
 
This course is designed to teach users the importance of ADA Compliance in an ever more accessible virtual world. The course will provide information on how best to format files within the Microsoft Office suite of applicati…
LNOD 2 h, 15 min
In this course, learn how to develop and monitor service standards to support exceptional customer service; build customer service teams; understand your customers and how they measure service; and how to develop customer lo…
VILT 1 Day
Identify customer types, set customer expectations and maintain a positive attitude when working with customers.
VILT 1 Day
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
In This Course, students will analyze Excel data, create PivotTables, Pivot Charts as well as Analyzing Pivot Tables.
VILT 0.5 Days
In This Course, students will analyze Excel data, create Formulas, Charts and Data to Support Excel Spreadsheets and Workbooks.
VILT 0.5 Days
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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
This course shows OneNote users how to create notebooks, customize different settings, and work with different file types to increase their ease of use and efficiency.
LNL 1 Hour
This course gives an overview of Microsoft OneNote, a versatile note-taking tool that allows users to easily organize information. Students will learn how to create, format, and utilize basic OneNote Notebooks and learn abou…
LNL 1 Hour
This course instructs students how to share notebooks with other users so they can collaborate efficiently within their organizations. Students will learn how to create, manage, and sync shared notebooks and how to work with…
LNL 1 Hour
This is the second course in the custom Power BI Desktop training series. What makes Power BI for such a vast improvement over simple Excel worksheets is the Power Query engine in both Power BI and Excel. Power Query allows …
VILT 1 Day
This course is an introduction to incorporating existing Excel data to create enhanced and dynamic PowerPoint presentations. Students will learn how to prepare spreadsheets, create and insert charts into a presentation, and …
LNL 1 Hour
This course is an introduction to incorporating existing Excel data to create enhanced and dynamic PowerPoint presentations. Students will learn how to prepare spreadsheets, create and insert charts into a presentation, and …
LNL 1 Hour
This course teaches students how to bring together information from a variety of sources into PowerPoint. Students will learn how to create slides from outlines in Word, how to incorporate Excel data into presentations, and …
LNL 1 Hour
This course is an introduction to incorporating existing Excel data to create enhanced and dynamic PowerPoint presentations. Students will learn how to prepare spreadsheets, create and insert charts into a presentation, and …
LNL 1 Hour
This course is an introduction to data management in Microsoft Word. It will teach students how to organize document contents using lists, tables, and embedded Excel objects, allowing them to manipulate and visualize data wi…
LNL 1 Hour
When you nurture and inspire your team, you give them the con?dence to do their jobs well. You want to provide guidance and motivation, while showing integrity and modeling the behaviors you want to see in your team. Learn w…
VILT 2 Days