Most popular
Microsoft Project 2016: Level 2
What you'll learn
Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.
Update a project plan to reflect progress as you execute the project.
Monitor project progress in the project plan.
Adjust the project plan to control constraints.
Create project reports to share project status.
Customize project settings and share customizations with other projects.
Microsoft Office Access 2019: Part 2
What you'll learn
Provide input validation features to promote the entry of quality data into a database.
Organize a database for efficiency and performance, and to maintain data integrity.
Improve the usability of Access tables.
Create advanced queries to join and summarize data.
Use advanced formatting and controls to improve form presentation.
Use advanced formatting and calculated fields to improve reports.
Microsoft Office OneNote 2016
What you'll learn
In this course, you will develop digital note-taking skills by creating, modifying, and managing OneNote notebooks that work with other Microsoft Office programs.
Navigate and customize the OneNote interface and environment.
Add and format text, images, audio, links, and drawing objects to a notebook.
Embed Excel spreadsheets and attach other files to a notebook.
Categorize, organize, and search notebook content.
Check spelling in, print, and password-protect notebooks.
Use Outlook and OneDrive to send and share notebook content.
Export notebook content and manage notebook history and backups.
Microsoft Office Access 2019: Part 3
What you'll learn
Share data across applications.
Use action, unmatched, and duplicate queries to manage data.
Create complex reports and forms.
Use macros to improve user interface design.
Use VBA to extend database capabilities.
Perform database management tasks such as backup, compacting, repairing, performance analysis, checking object dependencies, and documenting.
Implement security strategies and distribute a database to multiple users.
55293-A: SharePoint End User 2019
What you'll learn
Learn to navigate a SharePoint 2019 Team Site.
Learn to create SharePoint lists.
Learn to customize SharePoint lists.
Learn to create SharePoint libraries.
Learn to manage library document versions.
Learn to create SharePoint lists and library views.
Learn to create sub sites using various SharePoint templates
Learn to create and edit Web page content.
Learn to create InfoPath Forms and Form libraries.
Learn to create Site columns and content types.
Learn to integrate Office applications with SharePoint 2019.
Learn to manage basic permissions of SharePoint 2019 resources.
Understand the versions of SharePoint.
Understand SharePoint site hierarchy.
Understand Team Site layout.
Understand navigation within a team site.
Understand List Templates.
Work with default lists in a Team Site.
Create a new list from a List Template.
Create a custom list.
Add columns to a list.
Control and validate input into list fields.
Create new libraries using library templates
Add columns to a library
Check out documents for editing.
Delete and restore documents from document libraries.
Enable versioning on a library.
Revert a library document to an earlier version.
Use default views built into lists and libraries.
Create shared views.
Configure views.
Set the default view for a list or library.
Understand what Site Templates are.
Understand the different types of Site Templates that come “out of the box” with different versions.
Create a new site using Site Templates.
Create a Project Site.
Create a Team site.
Create a Community Site
Create a Blog site.
Manage the sites listed in the Top Link Bar.
Understand what site pages are.
Understand what wiki pages are.
Understand what Web Parts are.
Add content to the Site Home page.
Create a wiki page library
Add Web Parts.
Manage Web Parts.
Understand what a Form Library is.
Create a Form Library.
Use InfoPath Designer to design a basic form template.
Publish an InfoPath Designer form template to a Form Library
Designate for templates fields as library columns.
Create instances of documents in a Form Library.
Understand Site Columns.
Understand Content Types.
Create Site Columns.
Create Content Types.
Create a document template for a Content Type.
Assign a Content Type to a list or library.
Create new items based on a custom Content Type.
Create a list from an Excel Spreadsheet.
Create an alert in Outlook.
Understand SharePoint groups.
Create SharePoint groups.
Assign permission in SharePoint.
View permission levels.
Manage permission inheritance at the site level.
Manage permission inheritance at the list or library level.
Edit a personal profile.
Microsoft Office Outlook 2019: Part 1
What you'll learn
In this course, you will use Outlook to manage your email communications, including composing, reading, and responding to emails; schedule appointments and meetings; manage contact information; schedule tasks and create notes; customize message response options; and organize your mail.
Navigate Outlook to read and respond to email.
Use the Address Book and format and spell check new messages.
Attach files and insert illustrations to messages.
Customize read and response options.
Use flags, categories, and folders to organize messages.
Create and work with Contacts.
Create appointments and schedule meetings in Calendar.
Create and work with Tasks and Notes.
Related products
55298-A: Introduction to SharePoint 2019
What you'll learn
Learn to navigate a SharePoint 2019 Team Site.
Learn to create SharePoint lists.
Learn to customize SharePoint Lists.
Learn to create SharePoint libraries.
Learn to manage library document versions.
Learn to create SharePoint list and library views.
Learn to integrate Office Outlook and Excel applications with SharePoint 2019.
Understand the versions of SharePoint
Understand the SharePoint site hierarchy.
Understand Team Site layout.
Understand navigation with a Team Site.
Understand List Templates.
Work with default lists in a Team Site.
Create a new list from a List Template.
Create a custom list.
Add columns to a list.
Control and validate input into list fields.
Create new libraries using library templates.
Add columns to a library.
Check out documents for editing.
Delete and restore documents from document libraries.
Enable versioning on a library.
Revert a library document to an earlier version.
Use default views built into lists and libraries.
Create shared views.
Configure views.
Set the default view for a list or library.
Create a list from an Excel spreadsheet.
Create an alert in Outlook.
Understand what Site Templates are.
Understand different types of Site Templates that come “Out of the Box” with different versions
Create a new site using Site Templates.
Create a Project site.
Create a Team site.
Create a Community site.
Create a Blog site.
Manage the sites listed in the Top Link Bar.
Microsoft Office Outlook 2019: Part 2
What you'll learn
In this course, you will use Outlook’s advanced features to customize and manage your email communications, including using advanced features to organize emails; managing calendar settings and options; managing contact information; scheduling tasks; and managing Outlook archives and data file settings.
Insert objects in messages, and modify properties and global options.
Organize, search, and manage messages.
Protect your mailbox and manage its size.
Use rules and Quick Steps to automate message management.
Work with advanced calendar settings.
Import and forward contacts.
Manage activities by assigning tasks to others.
Delegate access to and share Outlook items with others.
Archive and back up Outlook items using data files.
MS-700T00-A: Managing Microsoft Teams
What you'll learn
Understand the discipline of project management as it applies to using Microsoft Project 2013.
Create a Work Breakdown Structure.
Identify Task Types & Relationships.
Define Resources within Project.
Make Work Package Estimates.
Create an Initial Schedule.
Create a Resource Leveled Schedule.
Create Projects from templates, Excel files.
Create Global templates.
Create formulas and graphical indicators.
The steps to record a macro.
Format Output and Print Reports.
Integrate Multiple Projects.
Set up a Project with a Calendar, Start date, and scheduling method.
Understand Manually Schedule vs. Auto Schedule.
Manage multiple projects.
Be able to create a master project list with shared resources.
Have a fundamental understanding of how Microsoft Project will help them track their projects.
Understand what is new in Project 2013 and how it will increase their productivity.
Learn how the ribbon will help them get the most of out of this productivity tool.
Learn how to quickly change views and see what is going on with their projects.
Understand the 5 essential steps in building a successful project plan.
Prepare a new project plan and set the date and other basic information.
Enter detailed project information.
Understand how to sequence tasks.
Understand and define basic resource types.
Assign resources to tasks.
Understand the benefits of baselining a project or specific tasks.
Understand the basics of how to track project progress.
Create a new project using a template, Excel, a SharePoint Tasks List or a new Project file.
Establish one or more calendars to constrain resource availability.
Configure Microsoft Project to calculate the schedule from the Start Date forward or from the Finish Date backward.
Understand how to turn on Manually Schedule and Auto Schedule.
Understand when to use Manually Schedule.
Understand the limitations of Manually Scheduling.
Build and use summary and subordinate tasks.
Understand and use milestones.
How to organize the WBS.
How to format the WBS.
Develop WBS outlines.
Assign completion criteria.
Evaluate the WBS.
Understand and use WBS outlines.
Understand how to link Project artifacts to their projects.
Understand how to create notes on tasks.
Understand the different types of task relationships.
Understand and use various methods to create relationships.
Determine and display task sequence.
Understand how to use Lag, Lead and Delay.
Define the different types of resources.
Define individual resources that will be used on the project.
Record the cost(s) of using each type of resource.
Record the limit of availability for each type of resource by establishing a resource calendar and defining the maximum units of that resource.
Assign values for resources, duration and work.
Understand task types.
Understand Effort Driven scheduling.
Understand material resources and their costs to a project plan.
Identify the critical path.
Understand difference between slack and slippage.
Calculate float.
How to leverage constraints.
How to get the benefit from the Task Inspector, and the impact of changes on a project schedule.
Adjust a project schedule to account for limited resources.
View the overall cost and schedule of a project.
Identify resources that are over- allocated for a project schedule.
Use multiple ways to adjust tasks and assignments to remove over- allocation for any resource.
Set a baseline.
Enter and manage project performance data.
Pick a tracking method.
Perform variance analysis.
Sync Projects results with SharePoint.
Create standardized views, with the power of sorting, filtering and grouping.
Customize a variety of standard reports.
Learn how to use Visual Reports.
Export reports in a variety of formats.
Use common resources among multiple projects.
Link tasks between multiple projects.
Create a consolidated view of multiple projects and shared resources.
Take advantage of the advance features of Microsoft Project 2013.
Be able to create a Macro.
Share common settings among all future projects.
Featured
Microsoft Office PowerPoint 2019: Part 1
What you'll learn
Identify the basic features and functions of PowerPoint.
Develop a PowerPoint presentation.
Perform advanced text editing operations.
Add graphical elements.
Format graphical elements.
Prepare to deliver your presentation.
Trending
55299-A: SharePoint 2019 Site Owner Training
What you'll learn
Learn to navigate a SharePoint 2019 Team Site.
Learn to create and edit web page content.
Learn to create site columns and content types.
Learn to integrate Office applications with SharePoint 2019.
Learn to manage basic permissions
Understand what Site Templates are.
Understand the different Tpes of Site Templates that come “Out of the Box”
Creating a new site using Site Templates
Create a Project site.
Create a Team site.
Create a Community site.
Create a Blog site.
Manage the sites listed in the Top Link Bar.
Understand what site pages are.
Understand what wiki pages are.
Understand what Web Parts are.
Understand how to add content to the Site Home page.
Understand how to create a wiki page library.
Understand how to add Web Parts.
Understand how to manage Web Parts.
Understand Site Columns.
Understand Content Types.
Understand how to create Site Columns.
Understand how to create Content Types.
Understand how to create a document template for a Content Type.
Understan how to assign a Content Type to a list or library.
Understand how to create new items based on a custom Content Type.
Understand SharePoint groups.
Understand how to create SharePoint groups.
Understand how to assign permission in SharePoint.
Understand how to view permission levels.
Understand how to manage permission inheritance at the site level.
Understand how to manage permission inheritance at the list or library level.
Understand how to edit a personal profile.
Microsoft Visio 2019: Part 1
What you'll learn
In this course, you will design, modify, and manage basic diagrams.
Identify the basic elements of Visio and their use.
Create a workflow diagram.
Build organization charts.
Design a floor plan.
Build a cross-functional flowchart.
Design a network diagram.
Style a diagram.
Featured
Microsoft Office Excel (2019-2016-2013): Basic
What you'll learn
Get started with Microsoft Office Excel.
Perform calculations.
Modify a worksheet.
Format a worksheet.
Print workbooks.
Manage workbooks.
Microsoft Visio 2019: Part 2
What you'll learn
In this course, you will examine advanced features to make you more efficient and effective.
Design advanced plans and diagrams.
Enhance the look of drawings.
Create shapes, stencils, and templates.
Connect drawings to external data.
Leverage development tools.
Share drawings.
Featured
Microsoft Office Excel (2019-2016-2013): Intermediate
What you'll learn
Work with functions.
Work with lists.
Analyze data.
Visualize data with charts.
Use PivotTables and PivotCharts.
Featured
Microsoft Office Word 2019: Part 1
What you'll learn
Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application.
Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles.
Enhance lists by sorting, renumbering, and customizing list styles.
Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art.
Create and format tables.
Format text and paragraphs.
Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout.
Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility.
Microsoft Office 365 Online (With Teams)
What you'll learn
Sign in, navigate, and identify components of the Office 365 environment
Create, edit, and share documents with team members using the Office Online apps, SharePoint, OneDrive for Business, and Delve
Collaborate and work with colleagues using the Yammer and Planner apps
Use email and manage contacts with Outlook on the web
Collaborate using Teams
Configure Teams
Featured
Microsoft Office Excel (2019-2016-2013): Advanced
What you'll learn
Work with multiple worksheets and workbooks.
Share and protect workbooks.
Automate workbook functionality.
Use Lookup functions and formula auditing.
Forecast data.
Create sparklines and map data.
Featured Courses
Featured
Microsoft Office Word 2019: Part 3
Course Description: Microsoft® Word enables you to do far more …
Microsoft Office Word 2019: Part 3
What you'll learn
Use images in a document.
Create custom graphic elements.
Collaborate on documents.
Add reference marks and notes.
Secure a document.
Create and manipulate forms.
Create macros to automate tasks.
Featured
Microsoft Office Word 2019: Part 2
Course Description: After you master the basics of creating, editing, …
Microsoft Office Word 2019: Part 2
What you'll learn
Organize content using tables and charts.
Customize formats using styles and themes.
Insert content using Quick Parts.
Use templates to automate document formatting.
Control the flow of a document.
Simplify and manage long documents.
Use mail merge to create letters, envelopes, and labels.
Featured
Microsoft Office Word 2019: Part 1
Course Description: These days, most people take electronic word processing …
Microsoft Office Word 2019: Part 1
What you'll learn
Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application.
Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles.
Enhance lists by sorting, renumbering, and customizing list styles.
Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art.
Create and format tables.
Format text and paragraphs.
Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout.
Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility.
Featured
Microsoft Office PowerPoint 2019: Part 2
Course Description: Meetings, instruction, training, pitches; these are all a …
Microsoft Office PowerPoint 2019: Part 2
What you'll learn
Customize design templates.
Use ink to hand draw elements.
Add tables.
Add charts.
Work with media.
Build advanced transitions and animations.
Finalize a presentation.
Customize presentation navigation.
Secure and distribute a presentation.
Featured
Microsoft Office PowerPoint 2019: Part 1
Course Description: It’s hard to imagine a day going by …
Microsoft Office PowerPoint 2019: Part 1
What you'll learn
Identify the basic features and functions of PowerPoint.
Develop a PowerPoint presentation.
Perform advanced text editing operations.
Add graphical elements.
Format graphical elements.
Prepare to deliver your presentation.
Featured
Microsoft Office Excel (2019-2016-2013): Advanced
Course Description: Clearly, you use Excel a lot in your …
Microsoft Office Excel (2019-2016-2013): Advanced
What you'll learn
Work with multiple worksheets and workbooks.
Share and protect workbooks.
Automate workbook functionality.
Use Lookup functions and formula auditing.
Forecast data.
Create sparklines and map data.
Featured
Microsoft Office Excel (2019-2016-2013): Intermediate
Course Description: Whether you need to crunch numbers for sales, …
Microsoft Office Excel (2019-2016-2013): Intermediate
What you'll learn
Work with functions.
Work with lists.
Analyze data.
Visualize data with charts.
Use PivotTables and PivotCharts.
Featured
Microsoft Office Excel (2019-2016-2013): Basic
Course Description: Organizations the world over rely on information to …
Microsoft Office Excel (2019-2016-2013): Basic
What you'll learn
Get started with Microsoft Office Excel.
Perform calculations.
Modify a worksheet.
Format a worksheet.
Print workbooks.
Manage workbooks.
All Office Applications Courses
Microsoft Office Applications Online Training Courses - Live
Office applications are used by everyone everywhere. From writing letters to team collaboration to presentations to tracking data, MS Office applications are the most common set of productivity applications on the planet. Professionals in today’s business environment have to be proficient in them. We provide comprehensive training in all the common MS Office productivity tools, including Microsoft Office 365.
Filter by Topic
Filter by Vendor
55286-A: SharePoint 2019 Power User
Course Description This course delivers the complete site owner story …
What you'll learn
Understand the benefits of using SharePoint in real world scenarios
Create new SharePoint sites to store business information
Create pages to share news and documents
Customize the structure of a site to meet specific business requirements
Create and mange view, columns and apps
Manage the security of a site
Use social tools to communicate with groups of people or the entire organization
Use search to find business information including people to documents
Describe popular reasons to use SharePoint 2019
Understand user roles in SharePoint 2019
Navigate SharePoint 2019
Manage your OneDrive and MySite
Understand the benefits of using site templates when creating new sites
Correctly use Site Collections and Sites
Control site navigation
Delete and Restore sites
Know when to create pages
Create all types of pages
Add content to a page including images and videos
Use publishing page content such as renditions and reuable content
Understand the App template available in SharePoint 2019
Create new apps to store business information
Customize apps with Columns, Views and App settings to make them relevant to specific business
Use SharePoint Apps with other Office applications including Excel and Outlook
Sort and Filter documents
Understand how to create a new approval flow
Understand how to create a new powerapp
Understand and instating a business process
Understand how to share content ina library and associated permissions
Understand how to create new permission levels and security groups
Understand how to add and remove users
Describe the key features of search
Use search to find content including people, sites and videos
Use search web parts to roll up content from multiple locations
Describe the benefits of using SharePoint social tools
Create social content including blog posts, discussions and newsfeed posts
MS-700T00-A: Managing Microsoft Teams
Course Description: The Managing Microsoft Teams course is designed for …
What you'll learn
Understand the discipline of project management as it applies to using Microsoft Project 2013.
Create a Work Breakdown Structure.
Identify Task Types & Relationships.
Define Resources within Project.
Make Work Package Estimates.
Create an Initial Schedule.
Create a Resource Leveled Schedule.
Create Projects from templates, Excel files.
Create Global templates.
Create formulas and graphical indicators.
The steps to record a macro.
Format Output and Print Reports.
Integrate Multiple Projects.
Set up a Project with a Calendar, Start date, and scheduling method.
Understand Manually Schedule vs. Auto Schedule.
Manage multiple projects.
Be able to create a master project list with shared resources.
Have a fundamental understanding of how Microsoft Project will help them track their projects.
Understand what is new in Project 2013 and how it will increase their productivity.
Learn how the ribbon will help them get the most of out of this productivity tool.
Learn how to quickly change views and see what is going on with their projects.
Understand the 5 essential steps in building a successful project plan.
Prepare a new project plan and set the date and other basic information.
Enter detailed project information.
Understand how to sequence tasks.
Understand and define basic resource types.
Assign resources to tasks.
Understand the benefits of baselining a project or specific tasks.
Understand the basics of how to track project progress.
Create a new project using a template, Excel, a SharePoint Tasks List or a new Project file.
Establish one or more calendars to constrain resource availability.
Configure Microsoft Project to calculate the schedule from the Start Date forward or from the Finish Date backward.
Understand how to turn on Manually Schedule and Auto Schedule.
Understand when to use Manually Schedule.
Understand the limitations of Manually Scheduling.
Build and use summary and subordinate tasks.
Understand and use milestones.
How to organize the WBS.
How to format the WBS.
Develop WBS outlines.
Assign completion criteria.
Evaluate the WBS.
Understand and use WBS outlines.
Understand how to link Project artifacts to their projects.
Understand how to create notes on tasks.
Understand the different types of task relationships.
Understand and use various methods to create relationships.
Determine and display task sequence.
Understand how to use Lag, Lead and Delay.
Define the different types of resources.
Define individual resources that will be used on the project.
Record the cost(s) of using each type of resource.
Record the limit of availability for each type of resource by establishing a resource calendar and defining the maximum units of that resource.
Assign values for resources, duration and work.
Understand task types.
Understand Effort Driven scheduling.
Understand material resources and their costs to a project plan.
Identify the critical path.
Understand difference between slack and slippage.
Calculate float.
How to leverage constraints.
How to get the benefit from the Task Inspector, and the impact of changes on a project schedule.
Adjust a project schedule to account for limited resources.
View the overall cost and schedule of a project.
Identify resources that are over- allocated for a project schedule.
Use multiple ways to adjust tasks and assignments to remove over- allocation for any resource.
Set a baseline.
Enter and manage project performance data.
Pick a tracking method.
Perform variance analysis.
Sync Projects results with SharePoint.
Create standardized views, with the power of sorting, filtering and grouping.
Customize a variety of standard reports.
Learn how to use Visual Reports.
Export reports in a variety of formats.
Use common resources among multiple projects.
Link tasks between multiple projects.
Create a consolidated view of multiple projects and shared resources.
Take advantage of the advance features of Microsoft Project 2013.
Be able to create a Macro.
Share common settings among all future projects.
55293-A: SharePoint End User 2019
Course Description: This SharePoint 2019 End User class is for …
What you'll learn
Learn to navigate a SharePoint 2019 Team Site.
Learn to create SharePoint lists.
Learn to customize SharePoint lists.
Learn to create SharePoint libraries.
Learn to manage library document versions.
Learn to create SharePoint lists and library views.
Learn to create sub sites using various SharePoint templates
Learn to create and edit Web page content.
Learn to create InfoPath Forms and Form libraries.
Learn to create Site columns and content types.
Learn to integrate Office applications with SharePoint 2019.
Learn to manage basic permissions of SharePoint 2019 resources.
Understand the versions of SharePoint.
Understand SharePoint site hierarchy.
Understand Team Site layout.
Understand navigation within a team site.
Understand List Templates.
Work with default lists in a Team Site.
Create a new list from a List Template.
Create a custom list.
Add columns to a list.
Control and validate input into list fields.
Create new libraries using library templates
Add columns to a library
Check out documents for editing.
Delete and restore documents from document libraries.
Enable versioning on a library.
Revert a library document to an earlier version.
Use default views built into lists and libraries.
Create shared views.
Configure views.
Set the default view for a list or library.
Understand what Site Templates are.
Understand the different types of Site Templates that come “out of the box” with different versions.
Create a new site using Site Templates.
Create a Project Site.
Create a Team site.
Create a Community Site
Create a Blog site.
Manage the sites listed in the Top Link Bar.
Understand what site pages are.
Understand what wiki pages are.
Understand what Web Parts are.
Add content to the Site Home page.
Create a wiki page library
Add Web Parts.
Manage Web Parts.
Understand what a Form Library is.
Create a Form Library.
Use InfoPath Designer to design a basic form template.
Publish an InfoPath Designer form template to a Form Library
Designate for templates fields as library columns.
Create instances of documents in a Form Library.
Understand Site Columns.
Understand Content Types.
Create Site Columns.
Create Content Types.
Create a document template for a Content Type.
Assign a Content Type to a list or library.
Create new items based on a custom Content Type.
Create a list from an Excel Spreadsheet.
Create an alert in Outlook.
Understand SharePoint groups.
Create SharePoint groups.
Assign permission in SharePoint.
View permission levels.
Manage permission inheritance at the site level.
Manage permission inheritance at the list or library level.
Edit a personal profile.
