Microsoft Courseware
At Courseware Store, we offer an extensive range of Microsoft courseware, designed to empower training programs with top-tier resources. From Microsoft Office for comprehensive productivity, SharePoint for collaboration, PowerShell for task automation, Windows for operating systems, Power Automate for streamlined workflows, and SQL Server for robust database solutions, we have courseware for all your training needs.
Our Microsoft courseware is suitable for learners at all levels, whether beginners just starting out, intermediate users enhancing their skills, or advanced professionals mastering the suite. Our offerings include the latest updates and features to ensure cutting-edge training.
Choose our Microsoft courseware and elevate your training programs with the best resources available. Start delivering more impactful, engaging, and successful training today!
Introduction to Microsoft Outlook (OUT101)
1 day
This Introduction to Outlook course is designed for individuals who want to learn how to use Microsoft Outlook effectively for email communication, calendar management, and contact organization. The course covers key topics such as the Outlook interface, performing popular tasks, working with messages, managing the calendar, and organizing contacts. Through practical exercises and demonstrations, students will gain a solid understanding of Outlook's core features and learn how to streamline their day-to-day tasks, manage their schedules, and maintain an organized list of contacts.
Outlook Version: This course primarily targets Outlook 2019; however, it can be used to teach Outlook 365 …
Introduction to Microsoft Excel Training (EXC365.1)
1 day
The Introduction to Excel course is designed for beginners seeking to learn the fundamentals of Microsoft Excel. This comprehensive course covers various aspects of Excel, such as the Microsoft Office basics, creating and managing workbooks, using the Ribbon and Backstage View, customizing the Quick Access Toolbar, entering and formatting data, editing worksheets, working with rows and columns, using formulas, and finalizing worksheets for printing. By the end of this course, students will have a solid foundation in Excel, enabling them to efficiently manage and analyze data.
Excel Version: This course primarily targets Excel 365 and Excel 2021; however, we …
Introduction to Microsoft Word Training (WRD365.1)
1 day
This Introduction to Word course is designed for beginners who want to develop a solid foundation in using Microsoft Word. The course covers essential topics such as Microsoft Office basics, creating and managing Word documents, navigating the Ribbon and Backstage View, working with the Quick Access Toolbar, formatting and editing documents, and finalizing your work. Through a series of hands-on exercises and practical examples, students will learn how to create, edit, and format professional documents using Microsoft Word's powerful tools and features.
Word Version: This course primarily targets Word 365 and Word 2021; however, we draw attention to features …
Microsoft 365 Administration (M365001WV)
2 days
This course examines the Microsoft 365 platform and includes lessons and lab exercises on the key skills you’ll need for deploying, configuring, and managing a Microsoft 365 environment. You’ll learn how to plan, deploy, and manage a Microsoft 365 tenant by using the Microsoft 365 admin portal, Microsoft Entra admin center, and Windows PowerShell. You’ll also learn how to provision and configure a new Microsoft 365 tenant, create new identities or connect to an existing identity infrastructure, and monitor and support a Microsoft 365 tenant.
By completing this course, you’ll achieve the knowledge and skills to:
- Provision …
Introduction to Microsoft Access (ACC101)
2 days
The Introduction to Access course provides a comprehensive foundation for students looking to learn about the Access database management system. This course covers the basics of Access, including its user interface, fundamentals, tables, queries, forms, and reports. Students will also gain insights into databases, Access terms, and relational databases. By the end of this course, students will have a solid understanding of Access and be prepared to use it effectively for managing and organizing data in various applications.
Access Version: This course primarily targets Access 2019; however, it can be used to teach Access 365 as well as earlier …
SharePoint Online End User Training (SPO101)
3 days
This SharePoint Online training courseware helps trainers and training companies deliver a solid introduction SharePoint Online for end users. The material covers the essential aspects of SharePoint Online setup and management, enabling students to efficiently create, organize, and secure their SharePoint environments. Beginning with foundational knowledge, the course introduces SharePoint Online and guides learners through site layout and navigation. It progresses into practical applications such as creating and managing lists and libraries, complete with detailed exercises to reinforce learning.
It includes content on managing SharePoint list and library views, creating public and personal views, and customizing these views to fit …
Introduction to Microsoft PowerPoint Training (PPT365.1)
1 day
This Introduction to PowerPoint course is designed to help beginners and those new to Microsoft PowerPoint develop the essential skills needed to create, edit, format, and present compelling presentations. The course covers the basics of Microsoft Office, the Ribbon, Quick Access Toolbar, and Backstage View. It also delves into formatting presentations, working with images, tables, charts, and preparing and presenting your slides. Through practical exercises, students will learn the fundamental aspects of PowerPoint, empowering them to create visually appealing and engaging presentations.
PowerPoint Version: This course primarily targets PowerPoint 365 and PowerPoint 2021; however, we draw attention to features …
Microsoft Dataverse for Teams Super User (55304AC)
2 days
This 2-day course will guide students through designing low-code applications, automated processes and chatbots directly in Microsoft Teams by leveraging Microsoft Dataverse for Teams and how to use further tools to design reports. This course is focused on end users, rather than administrations, who are looking to create new ways of working that are consumed within Microsoft Teams which is included in the cost of existing Teams user licenses and additional licensed services.
This course is intended for information workers who wish to create new chatbots, apps, reports and flows to benefit their audiences experience in Microsoft Teams …
Microsoft Power Automate Super User (55268AC)
1 day
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 workflows. Power Automate is designed to interweave the various products in Microsoft 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 workflow logic for your business workflows.
The intended audience for this course would be those who have been using Microsoft 365 for some time and are now …
SharePoint Online Administrator (55238BC)
3 days
This course will introduce the audience to SharePoint Online Administration in Microsoft 365 and explain and demonstrate the configuration options for SharePoint Online. The course is appropriate for existing SharePoint on-premises administrators and new administrators to Microsoft 365 who need to understand how to correctly setup SharePoint Online for their company. The course will also help SharePoint on-premise administrators understand the differences between SharePoint on-premises and SharePoint Online.
This course is designed for Administrators who need to setup, configure and manage SharePoint Online as part of their Microsoft 365 Administration.
Microsoft Power Apps Super User (55265AC)
2 days
This course delivers an instructor-led breakdown of Microsoft Power Apps. 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.
This class has something for everything, from beginners who wish to customise their data entry forms in SharePoint right up to advanced users who need to use advanced formulas to deliver more bespoke actions to their apps.
Microsoft Teams Super User (55300AC)
1 day
Microsoft Teams is a full collaboration platform and offers facilities for peer to peer collaboration as well as full team collaboration. This course will give guidance on how to use the tools for chat, file sharing, meetings and calls. The course will also give direction on best practices for sharing files with external parties and show how to access other services available in the tenant directly from within Teams. There will be a series of labs to practice the methods taught during the course.
The intended audience for this course are Power Users who will need to support …
Microsoft 365 Super User (55283AC)
3 days
The course is designed to help Power Users and end users make the most of the Microsoft 365 apps. Teaching you how to collaborate across the business and understand when to use what and maximize your business adoption of Microsoft 365.
The intended audience for this course are super users who will need to support the user base, advise on functionality and when to use what tool for the right collaboration need.
SharePoint Online Super User (55215BC)
4 days
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 put theory into practice with hands on exercises in SharePoint Online.
This course is intended …
SharePoint Online Branding Super User (55281AC)
1 day
This course delivers an instructor-led walk through of the various options for branding SharePoint Online Sites. SharePoint Online has some non-code options to add logo’s, colour schemes and conditional formatting on sites and apps. There are also options to add in coded customisations. This course will give you guidance on how to use the non-code options available with practical labs to practice these methods. We will also give guidance on the code options giving advice on where to look for the resources to do this. This course will not cover how to write the code for the non-standard customisations.
…
Microsoft Power BI Super User (55400AC)
2 days
This 2-day course will take students who have little to no knowledge of Power BI to the point where they can create, publish and share rich reports and dashboards.
Audience
This course is for students that are looking to learn how to use the range of Microsoft Power BI tools to refine and model their data into a visual and interactive format. Students considering adopting this course are not required to have any prerequisite knowledge of Power BI or experience working on data modeling related tasks.
Windows PowerShell Scripting and Toolmaking (B Version) (55039)
5 days
Build the tools that will allow you to better administer your Windows server and client products.
This five-day instructor-led is intended for IT professionals who are interested in furthering their skills in Windows PowerShell and administrative automation. The course assumes a basic working knowledge of PowerShell as an interactive command-line shell, and teaches students the correct patterns and practices for building reusable, tightly scoped units of automation.
What is the difference between this course and the A version of the course here?
This version of the course is more comprehensive, but is not as conducive to …
Introduction to Microsoft Word 2019 (WRD2019.1)
1 day
This course provides an introduction to Microsoft Word 2019, focusing on the essential skills needed to create, format, and finalize documents. It begins by covering the basics of creating a document, saving, and importing files, and navigating the user interface including the status bar. It then delves into the functionalities of the Ribbon, explaining tabs, groups, and commands.
The course also introduces the Backstage View, also known as the File menu, teaching how to open documents, use templates, print documents, and manage document properties. Participants will also learn about the Quick Access Toolbar, including how to add and organize …
Microsoft Windows PowerShell v2 for Administrators (50414)
4 days
This four-day instructor-led course provides students with the knowledge and skills to leverage Microsoft Windows PowerShell v2 to administer their Windows environment. Both the command line environment and the scripting capabilities inherent in Microsoft’s automation engine are addressed during this hands-on course.
This course is intended for systems administrators responsible for managing Windows platforms who are interested in automating administrative tasks.
Introduction to Microsoft Project: Getting Started (PRJ2019.1)
2 days
This Introduction to Microsoft Project course is designed to familiarize beginners with the essential components and features of the software. The course covers various topics such as navigating the Microsoft Project interface, working with calendars, managing tasks, creating and working with resources, and managing a project. Students will learn how to create, schedule, and monitor projects effectively using Microsoft Project's powerful tools. By participating in practical exercises and working with real-world examples, students will gain valuable experience and confidence in using Microsoft Project to manage projects successfully.
Project Version: This course primarily targets Project 2019; however, it can be …
SharePoint 2019 End User (SHP2019.1)
3 days
This SharePoint End User course offers a comprehensive introduction to the essential features and functionalities of SharePoint for end users. Students will learn how to navigate and manage SharePoint sites, work with lists and libraries, create and customize views, and integrate SharePoint with Microsoft Office applications. The course also covers site columns, content types, permissions, and user communities, ensuring that students gain a solid understanding of the platform and its capabilities.
This is the updated version of 55293AC from the retired Microsoft Courseware Marketplace.
SharePoint 2019 Site Owner Training (SHP2019.6)
2 days
This is the course that was 55299AC in the Courseware Marketplace.
The SharePoint 2019 Site Owner course equips students with the skills necessary to effectively manage and maintain SharePoint sites within their organizations. The course covers various aspects of site management, including working with sites, creating and editing site content, managing site columns and content types, setting up and managing site permissions, and participating in user communities. By the end of the course, students will be able to confidently manage SharePoint sites and effectively collaborate with their colleagues in a SharePoint environment.
This is the updated version of …
SharePoint 2019 Super User (55286AC)
4 days
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. Your goal is to learn how to make SharePoint 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.
Microsoft Project: Digging Deeper (PRJ2019.2)
2 days
This course is designed for experienced users who want to take their project management skills to the next level. The course delves into advanced topics such as starting a project from various sources, advanced methods for managing tasks and resources, managing projects with advanced techniques, customizing and formatting views, reporting, working with templates, and leveraging the Project Cloud. Through hands-on exercises and practical examples, students will master advanced features and techniques, enabling them to manage complex projects more effectively and efficiently using Microsoft Project.
Project Version: This course primarily targets Project 2019; however, it can be used to teach …
Introduction to Microsoft PowerPoint 2019 (PPT2019.1)
1 day
The Introduction to PowerPoint 2019 course offers an extensive exploration of the foundational and intermediate aspects of Microsoft's powerful presentation tool. It covers the creation of presentations, the functionality of the Ribbon, the Quick Access Toolbar, the Backstage View, text formatting, image handling, table/chart management, and finalization processes. This course enables participants to create, modify, and deliver professional presentations.
This is the 55277AC course from the retired Microsoft Courseware Marketplace. Note that we have an updated version that covers PowerPoint 2021 and 365.
Introduction to Microsoft Excel 2019 (EXC2019.1)
1 day
This Introduction to Microsoft Excel 2019 course begins with the fundamentals of creating a workbook and gradually progresses to cover the program's most advanced features. The curriculum is designed to help you navigate Excel's interface, enter and format data efficiently, use formulas, edit your worksheets, and prepare your work for printing.
This is the updated version of 55271AC from the retired Microsoft Courseware Marketplace. Note that we have a newer version that covers Excel 2021 and 365.
SharePoint 2016 Site Collection and Site Owner Administration (55234)
5 days
This five-day instructor-led course is intended for power users and IT professionals who are tasked with working within the SharePoint 2016 environment and conduct site collection and site administration. This course will provide a deeper, narrowly-focused training on the important and popular skills needed to do SharePoint site collection and site administration with SharePoint 2016 deployed on-premise, in Office 365 (SharePoint Online) or a hybrid deployment (on-premise connected to Office 365).
This course is designed to complement skills learned in other Microsoft courses, which focus on overall SharePoint 2016 server administration and deployment as well as overall Office 365 …
Introduction to Microsoft PowerPoint 2016 (PPT2016.1)
1 day
This Introduction to Microsoft PowerPoint 2016 course takes students step-by-step through the process of creating, formatting, and finalizing a presentation, with plenty of opportunities to practice and consolidate their learning along the way.
This is the 55176AC course from the retired Microsoft Courseware Marketplace. Note that we have updated versions: one that covers PowerPoint 2019 and one that covers PowerPoint 2021 and 365.
Introduction to Microsoft Excel 2016 (EXC2016.1)
1 day
In this Introduction to Microsoft Excel 2016 course, you'll start from the very basics of creating a workbook, and gradually work your way up to using advanced features introduced in Excel 2013 and 2016. The course covers how to work with the ribbon, understand the Backstage View, and customize the Quick Access Toolbar. You'll learn how to efficiently enter and format data, use formulas, and edit your worksheets. The course concludes with preparing your worksheets for printing and exploring new features in the latest Excel versions.
This is the updated version of 55165AC from the retired Microsoft Courseware Marketplace. …
SharePoint 2016 Administrator (55355AC)
5 days
This SharePoint 2016 Administrator course is design for Administrators who are new to SharePoint Server Administration or who are upgrading from previous versions of SharePoint including SharePoint 2007 and 2010. There is a separate course for those upgrading from SharePoint 2013.
This course is intended for a IT person wanting to learn about administrating SharePoint 2016
Introduction to Microsoft Word 2016 (WRD2016.1)
1 day
In this course, students learn to create professional documents using Word 2016. By the end of this class, they will be comfortable editing, formatting and printing documents in Microsoft Word.
Target Audience: Students who have little or no familiarity with Word 2016 or more experienced Word users who want to review the basics.
This is the 55173AC course from the retired Microsoft Courseware Marketplace. Note that we have newer versions: one that covers Word 2019 and one that covers Word 2021 and 365.
SharePoint 2013 Site Collection and Site Administration (55033)
5 days
This five-day instructor-led course is intended for power users, who are tasked with working within the SharePoint 2013 environment. This course will provide a deeper, narrowly-focused training on the important and popular skills needed to be an administrator for SharePoint site collections and sites. SharePoint deployment or farm administration skills and tasks, which are required for IT professionals to manage SharePoint 2013, are available in separate Microsoft Official Courseware.
This course is intended for SharePoint site collection administrators, site administrators and power users who are tasked with working within the SharePoint environment.
System Center 2012 Service Manager (55009)
5 days
This five-day course teaches students how to design, deploy and maintain Service Manager 2012 within their organizations. Students are introduced to the various System Center 2012 products and will learn how Service Manager 2012 is designed and deployed within the System Center suite. In addition, students will learn how to customize the end user experience and automate service request responses, as well as learn best practices for using Service Manager 2012. This course incorporates hands-on learning opportunities so students can practice applying business solutions to real-world scenarios. After completion, students will have the skills necessary to manage Service Manager …
System Center 2012 Orchestrator (55007)
3 days
This three-day course provides students with the knowledge necessary to design, deploy, and maintain Microsoft’s System Center 2012 Orchestrator. In this course, students are introduced to the various System Center products, and then learn how Orchestrator 2012 is architected and deployed within the Systems Center suite. In addition, this course includes automation of processes designed to address various scenarios, which may be encountered in the business computing environment. Upon course completion, students will have the skills necessary to manage Orchestrator 2012 for maximum business benefit. This course incorporates hands-on learning opportunities, so students can practice applying business solutions to …
Querying Microsoft SQL Server with Transact-SQL (55366AC)
5 days
This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.
This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts …
.NET Foundations (4012)
2 days
Microsoft .NET is a programming technology that greatly simplifies application development, both for traditional, proprietary applications and for web-based applications and services. The original .NET was a complete restructuring of Microsoft’s whole system infrastructure and represented a major learning challenge for programmers developing applications on Microsoft platforms. Part of .NET included a major new object-oriented programming language, C#. But learning the new programming language is only part of the challenge. The much greater challenge is learning the .NET Class Library and its many capabilities.
A major new restructuring of the .NET platform, .NET Core is cross-platform, open source, …
C# Essentials (4002)
3 days
Microsoft .NET is an advance in programming technology that greatly simplifies application development, both for traditional, proprietary applications and for the emerging paradigm of Web-based services. .NET 6 is a unified platform, for browser, cloud, desktop, IoT, and mobile apps. It is based on .NET Core, the package-based implementation that is cross-platform, running on Mac and Linux besides Windows. It completes the unification of the .NET platform begun with .NET 5.
This three-day course is designed for the experienced programmer to help you quickly come up to speed on the C# language. It is current to Visual Studio 2022, …
Introduction to SQL (SQL101)
2 days
The Introduction to SQL course offers a comprehensive exploration of the fundamentals of SQL, a powerful query language used to interact with relational databases. Students will learn about the history of SQL, relational databases, popular database systems, and basic SQL statements. The course guides learners through simple SELECT statements, advanced SELECT queries, and the use of subqueries, joins, and unions. Additionally, students will explore conditional processing with CASE and learn how to insert, update, and delete records. Throughout the course, practical examples and hands-on exercises are used to reinforce learning and help students apply their knowledge to real-world scenarios.
Creating Reports with Report Builder (REPBLD101)
3 days
In this Report Builder training class, students learn how to create, format, and customize SQL Server 2016 Reporting Services reports using the Report Builder tool. This class is geared toward business analysts and data consumers who need to be able to successfully create reports on a SQL Server Reporting Services server.
SharePoint Server SE Super User (55311AC)
4 days
This 4-day 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 Server Subscription Edition. Your goal is to learn how to make SharePoint Server SE 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 study and put theory into practice with hands on exercises in SharePoint …
Excel 2019 Pivot Tables (0200-500-19-W)
1 day
In this course you will learn how to create and modify PivotTables and PivotCharts, as well as how to filter and modify fields to format and group data. In addition, you will learn to use the advanced features of PivotTables, such as consolidating multiple workbooks as well as creating and using page fields. Finally, you will learn how to generate PivotTables using imported data from external data sources. This information could be in Access, SQL Tables, the Internet, or other database programs. Understanding how to work with PivotTables and PivotCharts to achieve the results you want is one of the …
Introduction to Microsoft Cloud Computing (55195)
1 day
This one-day instructor-led is intended for IT professionals who are interested in expanding their knowledge base and technical skills with an understanding of the Cloud and Microsoft Cloud Products such as Azure, Office 365, One Drive and InTune.
In this course, students learn high level terminology, structure, security, deployment and migration practices as well as the general scope of Microsoft Cloud product offerings.
Audience
This course is intended for both novice and experienced IT professionals and managers of IT professionals who have basic Windows navigation skills and want to get started using cloud resources and products.
Excel 2019 Formulas (0200-240-19-W)
1 day
In this course, you will cover how to: name cells and ranges, use those names in formulas, use Logical and Lookup function formulas, use the IF and IFS formulas, Data Validation, use Match and Indexing formulas, work with Date and Time formulas, and use the formula auditing tools to trouble shoot problems in formulas.
In this course, you will cover how to: name cells and ranges, use those names in formulas, use Logical and Lookup function formulas, use the IF and IFS formulas, Data Validation, use Match and Indexing formulas, work with Date and Time formulas, and use the …
Object-Oriented Programming in C# (4001)
5 days
Microsoft .NET is an advance in programming technology that greatly simplifies application development, both for traditional, proprietary applications and for the emerging paradigm of Web-based services. .NET 6 is a unified platform, for browser, cloud, desktop, IoT, and mobile apps. It is based on .NET Core, the package-based implementation that is cross-platform, running on Mac and Linux besides Windows. It completes the unification of the .NET platform begun with .NET 5.
Part of this technology is the new language from Microsoft, C#. This language combines the power of C++ and the ease of development of Visual Basic 6. It …
Windows Presentation Foundation (4035)
3 days
This course introduces Windows Presentation Foundation or WPF, the .NET technology from Microsoft for building rich Windows applications. WPF includes an XML-based markup language for defining program elements, Extensible Application Markup Language (XAML). WPF applications can be created using only code or a combination of code and XAML pages. This course covers the essentials of WPF, providing an orientation to this technology and a firm foundation for creating applications. The course is current to Visual Studio 2022 and.NET 6, which is the latest version of .NET Core.
WPF is a complex technology that can have a steep learning curve. …
Installation, Storage and Compute with Windows Server 2016 (55324AC)
5 days
This five-day course is intended for information technology (IT) professionals who have a basic knowledge of Windows Server. It is designed for professionals who have the primary responsibility of managing storage and computing with Windows Server 2016, and who need to understand the scenarios, requirements, and storage and compute options that are available in and applicable to Windows Server 2016.
This course is intended for IT professionals who would like to improve their expertise in storage and compute functionality for Windows Server 2016. It will help them prepare for daily use in their role as a Windows Server …
SQL Server Reporting Services for Report Writers (SSRS101)
4 days
This Introduction to SQL Server 2016/2019 Reporting Services (SSRS) training class teaches students how to create, format, and manage SQL Server 2016/2019 Reporting Services reports. This course focuses primarily on the Report Designer tool in the SQL Server Data Tools (SSDT) for Visual Studio. Attendees will also work in and become familiar with Report Builder and Report Manager.
If you wish to have students set up their own machines rather than use the Skillable lab add-on, they can do so following the instructions here.
Managing Windows Environments with Group Policy (50255EC)
5 days
In this course, you will learn how to reduce costs and increase efficiencies in your network. You will discover how to consolidate the administration of an enterprise IT infrastructure with Group Policy, and you will learn to control and manage computer systems and domain users running Windows Server and Windows clients. Create Group Policies, implement administrative and security templates, and determine best practices when deploying software packages. Walk away with the experience and tools needed to optimize your enterprise systems and networks.implement administrative and security templates, and determine best practices when deploying software packages. Walk away with the experience …
Microsoft 365 Copilot Super User (55485CK)
2 days
This course will teach students who are new or unfamiliar with Microsoft Copilot how to use it effectively in common situations. The course focuses on Copilot for Microsoft 365, using the AI in applications like Word, PowerPoint, Excel, Outlook, OneNote and Teams. It also covers other popular Copilot experiences found in Windows 11, Edge and the Copilot website. For those who use the Power Platform, we also explore how to use Copilot in Power Apps, Power Automate, Power BI and Power Pages. We examine Copilot Studio, as service for creating chat experiences and AI builder which can be used to …
Windows PowerShell Scripting and Toolmaking (A Version) (55039A)
5 days
Build the tools that will allow you to better administer your Windows server and client products.
In this course, you will learn to build reusable tools by using Windows PowerShell. This course focuses on the Windows PowerShell scripting language and on the concepts and techniques needed to design tools, including and output requirements and functional requirements. You will learn functions to deal with anticipated errors using standard PowerShell patterns and practices. By course completion, you will be armed with the knowledge and skills to better administer a wide variety of server and client products and technologies that offer Windows …
SQL Queries for Analysts (SQLQFA101)
4 days
This 4-day SQL Server course, Introduction to SQL for Analysts, is designed to teach attendees both beginning and intermediate Transact-SQL (T-SQL). The course covers writing simple and complex queries, working with data types, using built-in functions, and more. Students will also learn how to combine data from multiple tables and result sets using JOIN operations, subqueries, and temporary objects. The course is structured to provide a comprehensive understanding of the Microsoft SQL Server query language and its capabilities. By the end of the course, students will be able to write advanced queries and manipulate data using Data Manipulation Language. The …
Provisioning Databases on SQL Server (55369AC)
5 days
This five-day course provides a comprehensive understanding of SQL Server and its various components. Students will learn about the SQL Server platform, its architecture, and how to configure services, accounts, and networking. The course covers topics such as installation, upgrade strategies, and configuring databases and data files.
Students will gain knowledge about maintaining databases for long-term performance, using techniques like CHECKDB and index rebuilding. The course also delves into optimizing SQL Server performance through storage configuration, including options like fileshares, local storage, and cloud storage, along with the use of SQL Server Stretch Databases.
Additionally, the course explores cloud-based installations …
iSpring Suite 11: The Essentials (ISPRING11)
1 day
iSpring Suite 11 is an eLearning authoring toolkit that allows developers to create mobile-friendly eLearning courses.
Step-by-step instructions guide you through the process of creating new iSpring Suite eLearning projects from PowerPoint presentations.
You’ll learn how to import images, videos, and how to both record and edit voiceover audio.
Record video demonstrations of just about anything you can do on your computer complete with editable annotations.
Create role-play scenarios using supplied iSpring Studio assets including background images, icons, and characters.
Add Learner Interactions and Quizzes to make your eLearning projects as engaging as possible.
…
C# and .NET Foundations (4014)
5 days
This five-day course is designed for the experienced programmer to help you quickly come up to speed on the essentials of the C# language and the .NET Core frameworks. It is current to Visual Studio 2022, .NET 6 and C# 10.
Microsoft .NET is an advance in programming technology that greatly simplifies application development, both for traditional, proprietary applications and for the emerging paradigm of Web-based services. .NET 6 is a unified platform, for browser, cloud, desktop, IoT, and mobile apps. It is based on .NET Core, the package-based implementation that is cross-platform, running on Mac and Linux besides …
Intermediate SQL for Microsoft SQL Server (SQLINT)
1 day
The Intermediate SQL for Microsoft SQL Server course is intended for SQL users in programming roles who have taken an Introduction to SQL course. This course covers creating CTEs, using a Windows function, creating and using Global Variables, and pivoting data. This course is applicable to Microsoft SQL Server. Some topics may be applicable to other Database Management Systems, but most topics will not be supported in other DBMSs.
This course use data from the Adventureworks and OGCBOOKS databases.
SharePoint 2016 Super User (55217AC)
4 days
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. Your goal is to learn how to make SharePoint 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.
This course is intended for anyone …
PowerShell for Windows and Linux Administrators (2023)
5 days
This instructor-facilitated, five-day course provides students with the necessary knowledge to successfully administer Microsoft Windows Server and Client operating systems and Linux operating systems using PowerShell. In this course, students are shown the use of PowerShell commands to create, modify, and maintain various components of Windows and Linux operating systems. This course leans heavily towards hands-on labs to reinforce concepts. Instructional time is minimized in favor of “learning by doing” via the labs. Instructors facilitate a high-level review of concepts, provide guidance for the labs, assist in answering questions or issues with the labs and provide input when required for …
Fundamentals of Active Directory (55152)
1 day
Fundamentals of Active Directory will serve as your leap into the world of Active Directory and infrastructure management. In this one day instructor-led course, you learn how and why Active Directory was developed by Microsoft, the fundamental architecture, basic design, management, as well as security and fundamentals for cloud integration with services like Azure.
This course is intended for both novice and experienced IT Professionals:
- Network Administrators new to Active Directory
- Help Desk Personnel
- Network Support Personnel
- Desktop Support Personnel
- Managers that oversee IT personnel
- Developers that create products that interact with …
PowerShell for Microsoft Endpoint Configuration Manager Administrators (55133D)
3 days
This three-day instructor-led course provides students with the knowledge and skills needed to use PowerShell for Endpoint Configuration Manager (ECM) administration. In this course, students learn how to access the PowerShell cmdlets included with ECM 2203 and use them to perform configuration tasks for a primary site. Individual cmdlets will be used in working with objects such as Boundaries, Boundary Groups, Collections, Software Deployment, Patching, Compliance Settings, OSD Task Sequences, and many others. Basic scripting will also be covered so that students can learn how to put PowerShell to use when working with large sets of objects.
SQL Server Integration Services (SSIS) (55321AC)
5 days
The SQL Server Integration Services (SSIS) course provides a comprehensive overview of SSIS, a powerful data integration and workflow application platform for SQL Server. Students will learn to use the Import/Export Wizard, work with solutions and projects, understand basic control flow, and explore common tasks. The course delves into data flow sources, destinations, transformations, dynamic package creation, containers, troubleshooting, and package reliability. Additionally, students will learn how to deploy to the SSIS Catalog, install and administer SSIS, and secure the SSIS Catalog. Throughout the course, hands-on labs help students gain practical experience and apply their knowledge to real-world scenarios.
…
Intermediate Microsoft Word Training (WRD365.2)
1 day
The Intermediate Microsoft Word course is designed for users who are familiar with basic Word features and are looking to enhance their skills. The course covers advanced topics such as advanced formatting, working with tables, working with images, page layout, working with illustrations, and viewing your documents. Through practical exercises and real-world examples, students will develop a deeper understanding of Microsoft Word's capabilities and learn how to use the software more efficiently to create professional and visually appealing documents.
Word Version: This course primarily targets Word 365 and Word 2021; however, we draw attention to features that are not …
Intermediate Microsoft Excel Training (EXC365.2)
1 day
This Intermediate Excel course builds upon the foundational skills acquired in the Introduction to Excel course, offering a deeper understanding of Excel's capabilities. The course covers common functions like IF, COUNTIF, and TEXTJOIN, as well as working with lists, tables, and advanced formatting. It also provides an introduction to visualizing data through charts, sparklines, and SmartArt. Throughout the course, students will learn how to apply these concepts to real-world scenarios, improving their ability to manage and analyze data effectively.
Excel Version: This course primarily targets Excel 365 and Excel 2021; however, we draw attention to features that are not …
Introduction to SharePoint Online (SPOINTRO)
1 day
The Introduction to SharePoint for Office 365 course is the first day of our SharePoint Online End User Training course. It provides a foundational understanding of SharePoint Online, focusing on essential features and functionalities. Students will learn about SharePoint Online, site layout and navigation, list and library basics, and managing views. The course incorporates hands-on exercises that enable students to gain practical experience in creating and managing SharePoint Online resources. By the end of the course, students will have a solid grasp of the core features of SharePoint Online and be prepared to use it effectively within their organizations.
…
Advanced Microsoft PowerPoint Training (PPT365.2)
1 day
The Advanced PowerPoint course focuses on elevating the skills of experienced PowerPoint users, providing them with a deeper understanding of the software's capabilities. This course covers a wide range of topics, such as customizing presentations, working with Presentation Masters, incorporating special effects, utilizing SmartArt, integrating multimedia elements, setting up slide shows, managing outlines and slides, handling multiple presentations, and finalizing presentations. Through a combination of practical exercises and expert instruction, students will learn how to create engaging, sophisticated presentations using advanced PowerPoint features and techniques.
PowerPoint Version: This course primarily targets PowerPoint 365 and PowerPoint 2021; however, we draw …
Advanced Microsoft Excel Training (EXC365.3)
1 day
The Advanced Excel course is designed for experienced users looking to leverage Excel's powerful features to streamline their work and enhance their data analysis capabilities. The course delves into topics such as PivotTables, advanced functions, auditing workbooks, and data tools. Students will also explore importing and consolidating data, What-If analysis, recording and using macros, and collaborating with others. Through hands-on exercises and real-world examples, students will master advanced Excel techniques, equipping them with the skills needed to tackle complex data analysis tasks efficiently.
Excel Version: This course primarily targets Excel 365 and Excel 2021; however, we draw attention to …
Advanced Microsoft Word Training (WRD365.3)
1 day
The Advanced Microsoft Word course is designed for experienced Word users who want to master the software's most powerful features. The course covers topics such as working with long documents, reviewing and collaborating on documents, comparing and combining documents, creating forms, managing mailings, protecting documents, and using macros. Through hands-on exercises and practical examples, students will learn how to utilize Word's advanced tools and functionalities to create professional and polished documents with ease.
Word Version: This course primarily targets Word 365 and Word 2021; however, we draw attention to features that are not supported in earlier versions of Word, …
Intermediate Microsoft Excel 2019 (EXC2019.2)
1 day
This Intermediate Microsoft Excel 2019 course is designed to deepen your understanding of Excel's powerful features, with a focus on formulas, list management, illustrations, data visualization, table manipulation, and advanced formatting. Each topic is accompanied by practical exercises to reinforce your learning.
This is the same course as 55269AC from the retired Microsoft Courseware Marketplace. Note that we have a newer version that covers Microsoft Excel 2021 and 365.
Intermediate Microsoft Word 2019 (WRD2019.2)
1 day
This course provides in-depth training on advanced formatting techniques in Microsoft Word. It teaches students how to use shading and borders, set line and paragraph spacing, change styles, use paragraph marks and other formatting symbols, and edit PDF documents in Word.
The course also covers working with tables, including inserting, styling, and formatting tables. Students will also learn how to work with images in Word, which includes inserting, sizing, and placing images, wrapping text around images, adjusting images, and adding borders and effects to images.
The page layout section of the course covers orientation and paper size, using …
Intermediate Microsoft Word 2016 (WRD2016.2)
1 day
Ready to take your Microsoft Word skills to the next level? In this class, you will learn to use advanced formatting, drawing tools, tables, column layouts, custom fields and more!
Target Audience: Students who have basic Microsoft Words skills and are ready to create more professional document using sophisticated design features.
This is the updated version of 55174AC from the retired Microsoft Courseware Marketplace. Note that we have newer versions: one that covers Word 2019 and one that covers Word 2021 and 365.
Intermediate Microsoft Excel 2016 (EXC2016.2)
1 day
This Intermediate Microsoft Excel 2016 will take your Excel skills to the next level. Learn how to use advanced formulas, work with lists, illustrations, and tables, and visualize your data with sophisticated charting techniques. Understand how to apply advanced formatting such as conditional formatting and styles, and even get familiar with new features in Excel 2013 and Excel 2016. Throughout the course, you'll get hands-on experience with exercises designed to reinforce what you've learned and build real-world skills.
This is the updated version of 55166AC from the retired Microsoft Courseware Marketplace. Note that we have newer versions: one that …
Advanced Microsoft Outlook (OUT201)
1 day
The Advanced Outlook course is tailored for individuals who are familiar with Microsoft Outlook and want to enhance their skills in managing tasks, notes, inbox, and multiple email accounts. The course delves into advanced features such as using signatures and themes, inbox management, and working with multiple email accounts. Students will participate in hands-on exercises that enable them to become proficient in these advanced Outlook functionalities, leading to increased productivity and improved email management in their professional lives.
Outlook Version: This course primarily targets Outlook 2019; however, it can be used to teach Outlook 365 as well as earlier …
Advanced Microsoft Access (ACC201)
2 days
The Advanced Access course builds upon the foundational skills acquired in the Introduction to Access course, diving deeper into topics such as relationships, queries, table functions, advanced forms, reports, macros, and completing a desktop application. This course equips students with the skills and knowledge to handle more complex Access tasks, further enhancing their data management capabilities and proficiency with the software.
Access Version: This course primarily targets Access 2019; however, it can be used to teach Access 365 as well as earlier versions of Access. We draw attention to features that are not supported in earlier versions of Access, …
Advanced Microsoft PowerPoint 2019 (PPT2019.2)
1 day
This advanced PowerPoint 2019 course is designed to provide a comprehensive understanding of the higher-level functionalities of the software. It covers topics such as the innovative features introduced in the 2013 and 2016 versions of PowerPoint, presentation customization, working with Presentation Masters and SmartArt, multimedia handling, setting up slide shows, exporting outlines and slides, managing multiple presentations, and presentation sharing and security. In addition, it includes practical exercises for hands-on experience.
This is the 55276AC course from the retired Microsoft Courseware Marketplace. Note that we have an updated version that covers PowerPoint 2021 and 365.
Advanced Microsoft Word 2019 (WRD2019.3)
1 day
This course offers in-depth knowledge on managing long documents in Microsoft Word. It covers the creation, updating, and management of elements such as Tables of Contents, Footnotes, Endnotes, Citations, Bibliographies, and Indexes. It also includes instructions on how to create outlines and handle Tables of Figures and Tables of Authorities.
The course also focuses on collaborative features, like adding, tracking, and reviewing comments, and making changes in documents. There's a section on comparing and combining documents for efficient version management. A unit on "Managing Mailings" covers creating envelopes and labels, and using the Mail Merge feature.
The course …
Advanced Microsoft Excel 2019 (EXC2019.3)
1 day
This Advanced Microsoft Excel 2019 course will take you through the key functionalities of Microsoft Excel, from creating Pivot Tables, auditing worksheets, using various data tools, to recording and using macros. You will also learn how to work collaboratively and effectively with others, explore various random useful features, and understand how to harness the power of the cloud. Each module is accompanied by practical exercises to help consolidate your learning.
This is the updated version of 55270AC from the retired Microsoft Courseware Marketplace. Note that we a newer version that covers Excel 2021 and 365.
Advanced Microsoft Excel 2016 (EXC2016.3)
1 day
This Advanced Microsoft Excel 2016 equips you with essential Excel skills for data manipulation and analysis, workbook auditing, and collaborative work. Master the art of creating and working with pivot tables, and learn how to audit worksheets for data dependencies and precedents. Further, delve into various data tools such as text-to-columns conversion, data validation, and goal seeking. Enhance your collaborative work efficiency with workbook and worksheet protection methods, and empower your Excel proficiency with macro recording and editing. Learn to use and customize sparklines, prepare your workbook for internationalization and accessibility, and understand how to import and export data. The …
Advanced Microsoft PowerPoint 2016 (PPT2016.2)
1 day
The Advanced Microsoft PowerPoint 2016 course is designed to help participants further enhance their PowerPoint skills. It covers advanced features of the application, from customizing presentations and working with slide masters, to managing multiple presentations and securing them. The course also covers features new to PowerPoint 2013 and 2016 versions.
This is the 55177AC course from the retired Microsoft Courseware Marketplace. Note that we have updated versions: one that covers PowerPoint 2019 and one that covers PowerPoint 2021 and 365.
Advanced Microsoft Word 2016 (WRD2016.3)
1 day
In this Advanced Microsoft Word class, you will learn about document collaboration, security, navigation, and more. You will practice adding a table of contents, footnotes, endnotes, and comments. You will gain experience tracking changes, comparing and combining documents, creating envelopes and labels, using Mail Merge, and protecting documents. This class is for Word on Windows.
Target Audience:Students who have intermediate Microsoft Word skills and are ready to learn advanced tools and features.
This is the updated version of 55175AC from the retired Microsoft Courseware Marketplace. Note that we have newer versions: one that covers Word 2019 and …