TOTAL DAYS: 4 | TOTAL HOURS: 28

55215 SharePoint Online Power User

This course delivers the complete site owner story from start to finish in an engaging and practical way to ensure you have the confidence to plan and create new sites or manage your existing sites in SharePoint Online. Your goal is to learn how to make SharePoint online relevant to your team by using a sites functionality to help you share information and collaborate with your colleagues. During the class, you will also learn best practices and ‘what not to do’ as you watch live, interactive demonstrations and put theory into practice with hands on exercises in SharePoint Online.

TOTAL DAYS: 3 | TOTAL HOURS: 21

55232 Writing Analytical Queries for Business Intelligence

This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence.

TOTAL DAYS: 2 | TOTAL HOURS: 14

55265 Microsoft PowerApps

Students will be taught how to design, test and publish new apps that work with a variety of data sources. We will take users through a selection of well-crafted lessons to help them build new applications for their business.

TOTAL DAYS: 1 | TOTAL HOURS: 8

55268 Microsoft Power Automate for End Users

This course delivers an instructor-led product showcase for Microsoft Power Automate from start to finish in an engaging and practical way. Power Automate is a diverse product, turning business processes into automated, consistent and visual workPower Automates. Power Automate is designed to interweave the various products in Office 365 as well as connect to other on-premises and web-based solutions. This course will give you the confidence to select the right actions and workPower Automate logic for your business workPower Automates.

TOTAL DAYS: 3 | TOTAL HOURS: 24

55315 Introduction to SQL Databases

This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs. This course updates and replaces course 10985C previously published under the same title.

TOTAL DAYS: 2 | TOTAL HOURS: 14

MB-300T00 Microsoft Dynamics 365: Core Finance and Operations

This course covers the following core features in Dynamics 365: core common features, core configuration, data migration, and preparing to go live.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office PowerPoint 2016: Part 1

It’s hard to imagine a day going by without people passing along large amounts of information. Messages are everywhere, and the number of messages we receive seems to be increasing each day. Whether via phone, email, mass media, or personal interaction, we are subjected to a constant stream of information. With so much communication to contend with, it can be difficult to grab people’s attention. But, we are often called upon to do just that. So, how do you grab and maintain an audience’s focus when you’re asked to present important information? By being clear, organized, and engaging. And, that is exactly what Microsoft® Office PowerPoint® 2016 can help you do.

Gone are the days of flip charts or drawing on a white board to illustrate your point. Today’s audiences are tech savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within PowerPoint 2016, you will gain the ability to organize your content, enhance it with high-impact visuals, and deliver it with a punch. In this course, you will use PowerPoint 2016 to begin creating engaging, dynamic multimedia presentations.

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft PowerPoint 2016.

This course is the first part of a two-course series that covers the skills needed to gain a foundational understanding of PowerPoint.
Microsoft Office PowerPoint 2016: Part 1 (this course)
Microsoft Office PowerPoint 2016: Part 2

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office PowerPoint 2016: Part 2

Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all the variables, it may seem an overwhelming task to deliver your content, on time, to all audiences, and to only those who need to see it. Oh, and by the way, you need to make it interesting, informative, and memorable. So, how do you do it? Without the help of a robust set of tools, it would be nearly impossible. But Microsoft® Office PowerPoint® 2016 provides you with a variety of such tools that can help you deliver content in nearly any situation, while saving time and effort. By taking advantage of these tools, you will be creating presentations that not only stand out from the crowd, but also don’t consume all of your available time.

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft PowerPoint 2016.

This course is the second part of a two-course series that covers the skills needed to gain a foundational understanding of PowerPoint.
Microsoft Office PowerPoint 2016: Part 1
Microsoft Office PowerPoint 2016: Part 2 (this course)

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office PowerPoint 2019: Part 1

It’s hard to imagine a day going by without people passing along large amounts of information. With so much communication to contend with, it can be difficult to grab people’s attention. But, we are often called upon to do just that. So, how do you grab and maintain an audience’s focus when you’re asked to present important information? By being clear, organized, and engaging. And, that is exactly what Microsoft® Office PowerPoint® 2019 can help you do.

Gone are the days of flip charts or drawing on a white board to illustrate your point. Today’s audiences are tech savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within PowerPoint 2019, you will gain the ability to organize your content, enhance it with high-impact visuals, and deliver it with a punch. In this course, you will use PowerPoint 2019 to begin creating engaging, dynamic multimedia presentations.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the PowerPoint Associate (Office 365 and Office 2019): Exam MO-300.

This course is the first part of a two-course series that covers the skills needed to gain a foundational understanding of PowerPoint.
Microsoft Office PowerPoint 2019: Part 1 (this course)
Microsoft Office PowerPoint 2019: Part 2

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office PowerPoint 2019: Part 2

Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all the variables, it may seem an overwhelming task to deliver your content, on time, to all audiences, and to only those who need to see it. Oh, and by the way, you need to make it interesting, informative, and memorable. So, how do you do it? Without the help of a robust set of tools, it would be nearly impossible. But Microsoft® Office PowerPoint® 2019 provides you with a variety of such tools that can help you deliver content in nearly any situation, while saving time and effort. By taking advantage of these tools, you will be creating presentations that not only stand out from the crowd, but also don’t consume all of your available time.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the PowerPoint Associate (Office 365 and Office 2019): Exam MO-300.

This course is the second part of a two-course series that covers the skills needed to gain a foundational understanding of PowerPoint.
Microsoft Office PowerPoint 2019: Part 1
Microsoft Office PowerPoint 2019: Part 2 (this course)

Completion of this course will earn 0.6 CEUs.