10961 Automating Administration with Windows PowerShell

TOTAL DAYS: 1 | TOTAL HOURS: 35

This course provides students with the fundamental knowledge and skills to use Windows PowerShell for administering and automating administration of Windows servers. This course provides students the skills to identify and build the command they require to perform a specific task. In addition, students learn how to build scripts to accomplish advanced tasks such as automating repetitive tasks and generating reports. This course provides prerequisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Microsoft Exchange Server, Microsoft SharePoint Server, Microsoft SQL Server, System Center, and more. In keeping with that goal, this course will not focus on any one of those products, although Windows Server, which is the common platform for all of those products, will serve as the example for the techniques this course teaches.

10962 Advanced Automated Administration with Windows PowerShell

TOTAL DAYS: 3 | TOTAL HOURS: 21

This is a three-day course that will teach students how to automate administrative tasks using Windows PowerShell 5.1. Students will learn core scripting skills such as creating advanced functions, writing controller scripts, and handling script errors. Students will learn how to works with Windows PowerShell Workflow, the REST API and XML and JSON formatted data files, Students will also learn how to use new administration tools such Desired State Configuration (DSC) and Just Enough Administration (JEA) to configure and secure servers.

20703-1 Administering System Center Configuration Manager

TOTAL DAYS: 5 | TOTAL HOURS: 35

This five-day course describes how to use Configuration Manager and its associated site systems to efficiently manage network resources. In this five-day course, you will learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. You also will learn how to optimize System Center Endpoint Protection, manage compliance, and create management queries and reports.

55215 SharePoint Online Power User

TOTAL DAYS: 4 | TOTAL HOURS: 28

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

55265 Microsoft PowerApps

TOTAL DAYS: 2 | TOTAL HOURS: 14

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.

AZ-104T00 - Microsoft Azure Administrator

TOTAL DAYS: 4 | TOTAL HOURS: 28

This course teaches IT Professionals how to manage their Azure subscriptions, secure identities, administer the infrastructure, configure virtual networking, connect Azure and on-premises sites, manage network traffic, implement storage solutions, create and scale virtual machines, implement web apps and containers, back up and share data, and monitor your solution.

AZ-900T01 Microsoft Azure Fundamentals

TOTAL DAYS: 1 | TOTAL HOURS: 7

This class is free of charge with the purchase of a Microsoft exam voucher for $99.

This course will provide foundational level knowledge of cloud services and how those services are provided with Microsoft Azure. The course can be taken as an optional first step in learning about cloud services and Microsoft Azure, before taking further Microsoft Azure or Microsoft cloud services courses.

DA-100T00 Analyzing Data with Power BI

TOTAL DAYS: 4 | TOTAL HOURS: 28

This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.

Data Analysis & Visualization with Microsoft Excel (D.A.V.E.)

TOTAL DAYS: 2 | TOTAL HOURS: 13

Technology and the data that it both collects and makes accessible is now interwoven with businesses and lives. The era of “big data” has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage.

Analyzing data to find issues, insights, and opportunities is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways.

Microsoft® Excel® is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis, and create diverse and robust data-backed visualizations to show insights and trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action.

Completion of this course will earn 1.15 CEUs.

Excel 2013/2016 Programming with VBA

TOTAL DAYS: 3 | TOTAL HOURS: 19.5

Prerequisite

Proficient knowledge of Microsoft Excel. Knowledge of PivotTables helpful but not required.

Completion of this course will earn 1.725 CEUs.