Loading...

Microsoft Courses

* Courses listed below can also be customized based on user demandDon't see a course that you are looking for?
Click Here to Request It.

AZ-900T01- Microsoft Azure Fundamentals

This course will provide students with 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.

 

The course will cover general cloud computing concepts, as well as, general cloud computing models and services such as Public, Private and Hybrid cloud and Infrastructure-as-a-Service (IaaS), Platform-as-a-Service(PaaS) and Software-as-a-Service (SaaS).

 

It will also cover some core Azure services and solutions, as well as, key Azure pillar services concerning security, privacy, compliance and trust. It will finally cover pricing and support services available with Azure.

 

After completing this course, students will be able to:

  • Understand general cloud computing concepts
  • Understand core services available with Microsoft Azure
  • Understand security, privacy, compliance and trust with Microsoft Azure
  • Understand pricing and support models available with Microsoft

Related Certifications: Microsoft Certified: Microsoft Azure Fundamentals

  • In-class
  • Instructor Led Online
Enroll Now

DP-200T01 – Implementing an Azure Data Solution

In this course, the students will implement various data platform technologies into solutions that are in line with business and technical requirements including on-premises, cloud, and hybrid data scenarios incorporating both relational and No-SQL data. They will also learn how to process data using a range of technologies and languages for both streaming and batch data.

 

The students will explore how to implement data security including authentication, authorization, data policies and standards. They will also define and implement data solution monitoring for both the data storage and data processing activities. Finally, the students will manage and troubleshoot Azure data solutions which includes the optimization and disaster recovery of big data, batch processing and streaming data solutions.

 

Related Certifications: Exam DP-200: Implementing an Azure Data Solution

  • In-class
  • Instructor Led Online
Enroll Now

EXC13L3 – Microsoft Excel 2013 – Level 3 / Advanced

In this course students will learn more of the advanced features of Excel. Attendees will look at working with scenarios, using Solver, VLookup, the Analysis ToolPak, PivotTable features and developing macros. Other features, such as conditional formatting, slicers, the Inquire Add-In, and tracking changes are also covered. If time allows, an introductory lesson on Power Pivot and Power View will be covered.

 

Students will learn how to:

  • Work with Scenarios
  • Use Goal Seek, Solver, and VLookup
  • Analyze Data
  • Manage Data
  • Work with Slicers
  • Work with PivotTable
  • Use the Inquire Add-In
  • Use Macros
  • In-class
  • Instructor Led Online
Enroll Now

EXC16L3: Microsoft Excel 2016 – Level 3/Advanced

This course teaches students how to analyze and report data frequently as well as work in collaboration with others to deliver actionable insights. Students will learn how to keep and maintain workbooks for all purposes, as well as automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions that will put the power of Excel at their fingertips. Students will also learn how to perform advanced data analysis, and automate workbook functionality.

  • In-class
  • Instructor Led Online
Enroll Now

EXCL1: Microsoft Excel – Level 1 / Intro (2013, 2016)

This course teaches students the foundations of Microsoft Office Excel. Students will gain the knowledge, the skills and the confidence to create, format, enhance and print simple spreadsheets. They will learn to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of their organization.

Instruction will be personalized by version. Students have the option to progress through the course using Microsoft Excel 2010, Microsoft Excel 2013, or Microsoft Excel 2016.

  • In-class
  • Instructor Led Online
Enroll Now

EXCL2: Microsoft Excel – Level 2 / Med (2010, 2013, 2016, 2019, O365)

This course will teach students how to use formulas and advanced functions, create and format tables, sort and filter, visualize your data with charts. Students will learn how to leverage the power of data calculations and presentation in order to make informed, intelligent organizational decisions. They will work with functions and lists, create advanced formulas, protect spreadsheets and work with custom view.

  • In-class
  • Instructor Led Online
Enroll Now

EXCL3 – Microsoft Excel (2010 , 2013) Level 3 – Data List Management

In this course students will learn to organize data in tables, use various methods to sort and filter data, analyze data with PivotTables, as well as use database functions.

Instruction will be personalized by version. Students have the option to progress through the course using Microsoft Excel 2010 Level 3-Data List Management or Microsoft Excel 2013 Level 3- Data List Management.

 

Students Will Learn To: 

  • Create and use Excel tables, as well as add, edit, search for, and delete records in a data list using a form, as well as look up data.
  • Sort records in a data list using a variety of methods
  • Filter data in a list using a variety of methods, as well as work with filtered data
  • Create and work with subtotaled lists, as well as use various database functions to summarize data
  • Create, modify, and work with PivotTables, PivotCharts and Slicers
  • Import external data from a variety of sources into Excel
  • In-class
  • Instructor Led Online
Enroll Now

M10961 – Automating Administration with Windows PowerShell

In this training course, students will gain the fundamental knowledge and skills to use Windows PowerShell for automating the administration of your Windows-based servers. Students will focus on primary Windows PowerShell command line features and techniques. Learn to execute and monitor scripts more efficiently with more robust session connectivity, workflow capabilities, improved job scheduling, and Windows PowerShell Web Access.

This course incorporates materials from the Official Microsoft Learning Product M10961: Automating Administration with Windows PowerShell, and is taught by official Microsoft instructors.

  • In-class
  • Instructor Led Online
  • Self-Paced Virtual Classroom
Enroll Now

M10962 – Advanced Automated Administration with Windows PowerShell

Learn how to automate administrative tasks using Windows PowerShell 5.1. Students will develop core scripting skills such as creating advanced functions, writing controller scripts, and handling script errors, and 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.

  • In-class
  • Instructor Led Online
Enroll Now

M10982 – Supporting and Troubleshooting Windows 10

This course is designed to provide students with the knowledge and skills required to support and troubleshoot Windows 10 PCs and devices in a Windows Server domain environment. These skills include understanding of Windows 10 features, how they can be used in an Active Directory environment and how to troubleshoot them.

  • In-class
  • Instructor Led Online
  • Self-Paced Virtual Classroom
Enroll Now