All Office Applications Courses
Filter by Topic
Filter by Vendor
Microsoft Project 2016: Level 2
Course Description: Welcome to Microsoft Project 2016: Level 2 This …
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 Project 2016: Level 1
Course Description: Welcome to Microsoft Project 2016: Level 1 This …
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.
Identify project management concepts and navigate the Project 2016 environment.
Create and define a new project plan.
Create and organize tasks.
Manage resources in a project plan.
Finalize a project plan.
Microsoft Office 365 Online (With Teams)
Course Description: This course is an introduction to Microsoft Office …
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
Keep Going With QuickBooks 2021 for Windows
Course Description First-time QuickBooks users will learn the basic features …
Get Going With QuickBooks 2021 for Windows
Course Description First-time QuickBooks users will learn the basic features …
Get Smart With QuickBooks 2021 for Windows
Course Description First-time QuickBooks users will learn the basic features …
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.