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.

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.

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.

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.

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.

We start with the basics, giving you an overview of what you can do with VBA and its advantages over recording macros in the Excel interface. We'll record a macro, which produces VBA code in the background, and learn the Visual Basic editor environment before editing the code generated by our macro. Throughout this section, you will learn some key terminology that will help you along the way.

You will learn how to get VBA context-specific help from within the editor. A key component of VBA is language elements. We will learn about this important topic by going over variables, their scope, and how to declare them. You will also gain an understanding of VBA data types, intrinsic functions, and the With-End With structure and how it provides efficiency in your code. You will also learn to create message boxes and input boxes in this lesson, as well as gain an understanding of object variables.

This lesson begins with an overview of structures and Boolean expressions. You will then learn how to utilize conditional branching, with the lesson ending with looping constructs. We move into creating a form and programming its controls. During this lesson, you will learn about form properties, events, and methods, and learn how to add controls to the form and modify control properties. You will ultimately launch a form with code.

This lesson will take you through the steps necessary to create a Pivot Table programmatically in VBA. The series ends with you learning how to deal with code errors (debugging) and how to write error-handling code. By the end of this training series, you will be equipped with the basics to start writing your own VBA code, modify macros you’ve recorded, and have an understanding of how VBA lends itself to creating efficiency in your daily tasks.

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.

This course is a collection of 10 topics that cover various advanced features of Microsoft Office. You will learn how to use features that will significantly boost productivity, such as the quick access toolbar, templates, Outlook rules and quicksteps, macros, slide master, and more. By the end of the course, participants will have a better understanding of these key features and will be able to use them to increase their productivity and efficiency in the workplace.

In this series of short videos, you'll learn all of the features of OneDrive, including simultaneous collaboration on documents, syncing your library to your computer, and accessing files shared with you by others.

Learn about the amazing integration between OneNote and the rest of the digital world. Users in this series will learn how to create and collaborate on notebooks both in and out of the office. They’ll develop strategies on when to create sections rather than pages, as well as utilize and even build their own templates. Finally, users will learn how to secure, save, and share their work.

If you’re new to Outlook, you’ll learn how easy it is to use the program to manage your email and daily calendar. If you’re already using Outlook, you’re probably not using it to its highest potential.

You will learn how to automate everyday tasks, set remote meetings, stay on top of your responsibilities, and integrate Outlook with other software in the Office Suite.

First, simplify and streamline the Outlook interface with custom layouts. Next, get started with helpful tools like the Quick Access Toolbar, To-Bar Bar, and Quick Steps to improve the way you work. Then, learn new features like Scheduling Polls, Booking, and Loop Components to make Outlook more interactive than ever before. Lastly, take advantage of Tasks to stay on top of your day-to-day responsibilities.

This course is designed for app makers/creators, app users, and some other minor roles. You’ll learn about different types of apps (canvas, model-driven, and portal apps). We’ll create a new canvas app from scratch that will be used to review pertinent financial data. You’ll learn about the Power Apps interface, connecting to a data source, working with app screens, changing properties, saving an app, and playing an app.

We start with an overview of workflow concepts and then move on to accessing Power Automate from SharePoint, OneDrive, and Office 365. Then, we jump into reviewing the Power Automate interface and learn how to navigate within it. We create Power Automate flows using a template and from scratch. We learn about and use triggers, conditions, and actions to perfect our flows before activating and testing them.

We will move onto integrating Power Automate with Microsoft Forms, Planner, Project, Teams, and Power Apps. Lastly, we monitor flow statistics and metrics.

Users will be introduced to the foundational concepts of building queries and prepping data for analysis. Users will learn to build relationships across multiple databases using Power Pivot, all the while learning useful functions to help take data to the next level. Become familiar with building and navigating live dashboards and interactive reports, and much more.

In this series, users will be introduced to the foundational concepts of building queries and prepping data for analysis. Users will learn to build relationships across multiple databases using Power Pivot, all the while learning useful functions to help take data to the next level. Become familiar with building and navigating live dashboards and interactive reports, and much more.

In this series, users will be introduced to the foundational concepts of building queries and prepping data for analysis. Users will learn to build relationships across multiple databases using Power Pivot, all the while learning useful functions to help take data to the next level. Become familiar with building and navigating live dashboards and interactive reports, and much more.

In this series, users will be introduced to the foundational concepts of building queries and prepping data for analysis. Users will learn to build relationships across multiple databases using Power Pivot, all the while learning useful functions to help take data to the next level. Become familiar with building and navigating live dashboards and interactive reports, and much more.

In this series, users will be introduced to the foundational concepts of building queries and prepping data for analysis. Users will learn to build relationships across multiple databases using Power Pivot, all the while learning useful functions to help take data to the next level. Become familiar with building and navigating live dashboards and interactive reports, and much more.

In this series, users will be introduced to the foundational concepts of building queries and prepping data for analysis. Users will learn to build relationships across multiple databases using Power Pivot, all the while learning useful functions to help take data to the next level. Become familiar with building and navigating live dashboards and interactive reports, and much more.

In this course, we’ll take a deep dive into some of PowerPoint’s most useful features, like shape editing, SmartArt design, and grouping. Once the basics are covered, we’ll explore the slide master and learn how to save a ton of time with templates.

We will go over some of Microsoft's most powerful PowerPoint features, like recording presentations, collaborating with colleagues, and customizing slideshows, animations, layouts, and more.

Get started with the tools and knowledge needed to start using and working within the SharePoint environment.

This course is designed from the ground up to introduce students to standard navigation and practices.

Students will learn to engage with and contribute to files, projects, and other collaborative resources that are fundamental to the SharePoint experience.

Become proficient in the foundational concepts necessary to build, manage, and support a SharePoint Online site.

This course has been designed from start to finish to provide the latest information on tools available, as well as effective strategies for implementation in the areas of metadata, permissions, site structure, and more.

Become proficient in the foundational concepts necessary to build, manage, and support a SharePoint Online site. This course has been designed from start to finish to provide the latest information on tools available, as well as effective strategies for implementation in the areas of metadata, permissions, site structure, and more.

Learn how to create teams in order to group, manage, and communicate with your colleagues. Make content readily available by adding channels for different projects or topics. Then, add tabs for easy access to files, so you and your team members can seamlessly collaborate across multiple documents.

In this course, we expand on what you learned in our standard Teams training. We explore advanced topics like downloading meeting attendance lists. We also show off some new ways to get the most out of Teams, like using background effects or pop out chat windows.

Make remote teaching and learning just as effective as the in-person alternative. Gain confidence in your online teaching by creating and running online presentations and workshops that truly shine, taking advantage of the best features in Teams and using them to make thoughtful, engaging training.

Without understanding the right way to use Word, you are guaranteed to unnecessarily spend many hours reformatting and tweaking documents to get them to look right. In this course, we cover all the basics of Word, along with some powerful, advanced tools to help you increase efficiently and create documents "the right way."

As Microsoft’s flagship word processor has evolved over the years, it has changed so much that you can no longer just launch it and start typing up documents. Without understanding the right way to use Word, you are guaranteed to unnecessarily spend many hours reformatting and tweaking documents to get them to look right. In this course, we cover all the basics of Word, along with some powerful, advanced tools to help you increase efficiently and create documents "the right way."