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 Access

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 versions …

Microsoft 365 Administration

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 a new Microsoft …
Introduction to Microsoft Excel Training

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 draw …

Introduction to Microsoft Outlook

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 as …

Introduction to Microsoft PowerPoint Training

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 that …

Introduction to Microsoft Word Training

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 that …

SharePoint for Office 365 End User Training

SharePoint for Office 365 End User Training (SHP365.1)

3 days

The SharePoint for Office 365 End User course is designed to provide students with the knowledge and skills necessary to effectively use and navigate SharePoint Online. The course covers a wide range of topics, including SharePoint introduction, list and library basics, working with list and library views, managing sites, creating and editing page content, managing site columns and content types, and setting up and managing site permissions. By the end of the course, students will be able to confidently utilize SharePoint Online within their organizations, enhancing collaboration and productivity.

This is the updated version of 55255AC from the retired Microsoft …

Microsoft Dataverse for Teams Super User

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 by leveraging …

Microsoft Power Automate Super User

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 looking at …

SharePoint Online Administrator

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.

SharePoint Online Super User

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 for both …

Microsoft Power Apps Super User

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

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 the user …

Microsoft 365 Super User

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 Branding Super User

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.

The …

Microsoft Power BI Super User

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)

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 in-class learning as …

Introduction to Microsoft PowerPoint 2019

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

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 2019 Super User

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.

SharePoint 2019 Site Owner Training

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 55299AC from …

Microsoft Project: Digging Deeper

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 earlier …

Introduction to Microsoft Word 2019

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 common …

Introduction to Microsoft Project: Getting Started

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 used …

Introduction to SharePoint 2019

Introduction to SharePoint 2019 (SHP2019.5)

1 day

The Introduction to SharePoint 2019 course provides an in-depth look at the fundamentals of working with SharePoint 2019. It covers topics such as SharePoint versions, site layout and navigation, working with lists and libraries, views, Office integration, and managing sites. The course includes a variety of hands-on exercises to help students gain practical experience and build their skills in using SharePoint 2019 effectively.

This is the updated version of 55298AC from the retired Microsoft Courseware Marketplace.

SharePoint 2019 End User

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.

Microsoft Windows PowerShell v2 for Administrators

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.

SharePoint 2016 Power User

SharePoint 2016 Power User (SHP2016.2)

2 days

This SharePoint 2016 Power User training class is designed for individuals who need to learn the fundamentals of managing SharePoint sites.

This is the updated version of 55200AC from the retired Microsoft Courseware Marketplace.

Introduction to Microsoft Excel 2016

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. Note …

Introduction to Microsoft PowerPoint 2016

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.

SharePoint 2016 End User

SharePoint 2016 End User (SHP2016.1)

3 days

This SharePoint 2016 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 55199AC from the retired Microsoft Courseware Marketplace.

SharePoint 2016 Administrator

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

SharePoint 2016 Site Collection and Site Owner Administration

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 management: …

Introduction to Microsoft Word 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

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

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 2012 …

System Center 2012 Orchestrator

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 real-world …

SQL Server Integration Services (SSIS)

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.

This …

Querying Microsoft SQL Server with Transact-SQL

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 and have …

.NET Foundations

.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, and modular …

Provisioning Databases on SQL Server

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 …

C# Essentials

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, .NET …

Introduction to SQL

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

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

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 Server …

Excel 2019 Pivot Tables

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

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

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 formula …

Object-Oriented Programming in C#

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 bears …

Windows Presentation Foundation

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. This …

Installation, Storage and Compute with Windows Server 2016

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 Administrator and …

SQL Server Reporting Services for Report Writers

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.

Managing Windows Environments with Group Policy

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 and …

Microsoft 365 Copilot Super User

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)

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 PowerShell …

SQL Queries for Analysts

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 course …

iSpring Suite 11: The Essentials

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.

Learn how to publish finished iSpring …

C# and .NET Foundations

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 Windows. …

Intermediate SQL for Microsoft SQL Server

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

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 who wants …

PowerShell for Windows and Linux Administrators

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

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 Active Directory and Exchange Administrators.

This course requires …

PowerShell for Microsoft Endpoint Configuration Manager Administrators

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.

Intermediate Microsoft Excel Training

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 supported …

Intermediate Microsoft Word Training

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 supported …

Introduction to SharePoint for Office 365 Training

Introduction to SharePoint for Office 365 Training (SHP365.5)

1 day

The Introduction to SharePoint for Office 365 course 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.

This is the updated version of 55262AC from the retired Microsoft Courseware Marketplace.

Advanced Microsoft PowerPoint Training

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 attention …

Advanced Microsoft Excel Training

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 features …

Advanced Microsoft Word Training

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, and …

Intermediate Microsoft Excel 2019

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

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 live layout …

Intermediate Microsoft Excel 2016

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 covers Excel …

Intermediate Microsoft Word 2016

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.

Advanced Microsoft Outlook

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 versions …

Advanced Microsoft Access

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, and …

Advanced Microsoft PowerPoint 2019

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

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 provides insight …

Advanced Microsoft Excel 2019

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 PowerPoint 2016

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

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 one that …

Advanced Microsoft Excel 2016

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 …