This course will provide you with the knowledge and skills to configure and manage a Microsoft® Exchange Server 2010 messaging environment. This course will teach you how to configure Exchange Server 2010, as well as provide guidelines, best practices, and considerations that will help you optimise your Exchange server deployment.
This course teaches participants how to install, configure, and administer Microsoft® SharePoint® and also how to manage and monitor sites and users by using Microsoft SharePoint 2010. It will also cover the new features and functionality introduced with SharePoint 2010 Service Pack 1 (SharePoint) as well as Offices 365's SharePoint Online.
This course provides existing .NET developers with practical information and labs that enables them to build solutions on the Microsoft® SharePoint® 2010 platform.
This course is intended for Microsoft® SharePoint® Development professionals who are responsible for leading projects, designing solutions, and identifying problems. In this course, participants learn the skills and best practices that are required to help organizations design and develop effective SharePoint applications.
In this course, experienced developers who know the basics of data access (CRUD) in Windows® client and Web application environments will learn to optimize their designs and develop better performing data access code by using the ADO.NET Entity Framework, LINQ, WCF Data Services, the Sync Framework, and ADO.NET.
This course describes how to configure and manage a System Centre 2012 R2 Configuration Manager site and its associated site systems. It focuses on day-to-day management tasks for the System Centre 2012 R2 Configuration Manager.
Participants will learn how to plan for the deployment of the central administration site, one or more primary sites and secondary sites, and all associated site systems. They will also learn how to migrate from System Centre 2012 Configuration Manager to System Centre 2012 R2 Configuration Manager.
This course equips participants with the skills they require to deploy and configure the System Centre 2012 R2 Operations Manager
This course will provide participants with the key knowledge required to deploy and configure the System Centre 2012 R2 Service Manager.
This intensive course provides participants with the knowledge and experience to implement Office 365® in a large corporate environment using the FastTrack three-phase delivery process of Pilot, Deploy, and Enhance. The course consists of two distinct parts, Lectures/Labs and a Case Study.
In this course, participants will learn the basics of computer programming through the use of Microsoft® Visual Studio® and either the Visual C#® or Visual Basic® programming languages. The focus will be on core programming concepts such as computer storage, data types, decision structures, and repetition by using loops. The course also covers an introduction to object-oriented programming with topics such as classes, encapsulation, inheritance, and polymorphism. Other topics that are also covered include exception handling, application security, performance, and memory management.
This course describes fundamental database concepts including database types, database languages, and database designs
This course provides attendees, who manage and maintain SQL Server® databases, with the knowledge and skills to performance tune and optimize their databases.
This course teaches attendees how to implement a SQL Server® 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.
The main purpose of this course is to give participants the ability to add analysis capabilities to Excel® spreadsheets. It also provides participants with a foundation to learn about more advanced data analytics with Excel or Power BI®.
This is a course that targets the needs of information technology (IT) professionals who take part in administering, configuring, troubleshooting, and operating Office 365® services, including its identities, dependencies, requirements, and supporting technologies. This course focuses on skills required to administer and troubleshoot Office 365 tenant and key services of Office 365, such as Exchange Online, SharePoint® Online and Skype® for Business. It also covers security and compliance features of Office 365.
This course equips participants with the skills they require to configure and deploy a cloud using Microsoft® System Center 2012 R2.
This course will provide participants with the knowledge and skills to configure and manage a Microsoft® SharePoint® Server 2013 environment. It will teach them how to configure SharePoint Server 2013, as well as provide guidelines, best practices, and considerations that will help participants optimize their SharePoint server deployment.
This course examines how to plan, configure, and manage a Microsoft® SharePoint® Server 2013 environment. Special areas of focus include implementing high availability, disaster recovery, service application architecture, Business Connectivity Services, social computing features, productivity and collaboration platforms and features, business intelligence solutions, enterprise content management, web content management infrastructure, solutions, and apps. The course also examines how to optimize the search experience, how to develop and implement a governance plan. and how to perform an upgrade or migration to SharePoint Server 2013.
This course provides participants with the knowledge and skills required to plan, deploy, configure, and administer a Microsoft® Skype® for Business solution. Participants will learn how to deploy a multi-site and universally available Skype for Business infrastructure that supports instant messaging (IM), conferencing, enterprise voice, archiving, and monitoring. Participants will also learn how to manage, maintain, and troubleshoot issues in the infrastructure. This course focuses primarily on the on-premises deployment of Skype for Business but does include information on how to integrate the on-premises deployment with Teams or Skype for Business Online as well as how to migrate from previous versions of Skype for Business Server.
This course will provide participants with the knowledge and skills to plan and administer a Microsoft® SharePoint® 2016 environment. The course teaches participants how to deploy, administer, and troubleshoot their SharePoint environment. This course also provides guidelines, best practices, and considerations that help them optimize their SharePoint deployment. NOTE: This course is the first in a sequence of two courses for IT professionals.
This course will teach participants how to plan, configure, and manage the advanced features in a SharePoint® 2016 environment. The special areas of focus for this course include implementing high availability, disaster recovery, service application architecture, and Microsoft® Business Connectivity Services. This course also focuses on social computing features, productivity, and collaboration platforms and features. Participants also will learn about Business Intelligence (BI) solutions, Enterprise Content Management, web content management infrastructure, solutions, and apps. This course also covers how to develop and implement a governance plan, and how to perform an upgrade or a migration to SharePoint 2016. NOTE: This course is the second in a sequence of two courses for IT Professionals.
This course will provide you with the knowledge and skills to plan, deploy, manage, secure, and support Microsoft® Exchange Server 2013. This course will teach you how to configure Exchange Server 2013 and supply you with the information you will need to monitor, maintain, and troubleshoot Exchange Server 2013. This course will also provide guidelines, best practices, and considerations that will help you optimize performance and minimize errors and security threats in Exchange Server 2013.
This course will provide you with the knowledge and skills to configure and manage a Microsoft® Exchange Server 2013 messaging environment. It will teach them how to configure Exchange Server 2013. This course will provide guidelines, best practices, and considerations that will help attendees optimize their Exchange Server deployment.
This course teaches participants how to administer and support a Microsoft® Exchange Server. It covers how to install and configure Exchange Server, how to manage mail recipients and public folders, including how to perform bulk operations by using Exchange Management Shell. In addition, the course covers how to manage client connectivity, message transport and hygiene, and highly available Exchange Server deployments. Lastly, it will also cover how to implement disaster recovery solutions, how to maintain and monitor an Exchange Server deployment and how to administer Exchange Online in an Office 365® deployment.
This course provides participants with the knowledge to design and implement a Microsoft® Exchange Server messaging environment. It covers how to design and configure advanced components in an Exchange Server deployment such as site resiliency, advanced security, compliance, archiving and discovery solutions, coexistence with other Exchange organizations or Exchange Online, and migration from previous versions of Exchange server. The course also provides guidelines, best practices, and considerations that will help optimize Exchange Server deployments.
This is a course that targets the needs of IT professionals who take part in evaluating, planning, deploying, and operating Office 365® services, including its identities, dependencies, requirements, and supporting technologies. This course focuses on the skills required to set up an Office 365 tenant, including federation with existing user identities, and skills required to sustain an Office 365 tenant and its users.
Get hands-on instruction and practice installing and configuring Windows Server® 2012, including Windows Server 2012 R2, in this Microsoft® Official Course. This course focuses on the initial implementation and configuration of core services, such as Networking, Storage, Active Directory® Domain Services (AD DS), Group Policy, File and Print Services, and Hyper-V®. NOTE: This course is part one in a series of three courses that provides the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment.
Get hands-on instruction and practice administering Windows Server® 2012, including Windows Server 2012 R2, in this Microsoft® Official Course. This course focuses on the administration tasks necessary to maintain a Windows Server 2012 infrastructure such as configuring and troubleshooting name resolution, user and group management with Active Directory® Domain Services (AD DS) and Group Policy, implementing Remote Access solutions such as DirectAccess, VPNs and Web Application Proxy, implementing Network Policies and Network Access Protection, Data Security, deployment and maintenance of server images, as well as update management and monitoring of Windows Server 2012 environments. NOTE: This course is part two in a series of three courses that provides the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment.
Get hands-on instruction and practice configuring advanced Windows Server® 2012, including Windows Server 2012 R2, services in this Microsoft® Official Course. This course focuses on advanced configuration of services necessary to deploy, manage and maintain a Windows Server 2012 infrastructure, such as advanced networking services, Active Directory® Domain Services (AD DS), Active Directory Rights Management Services (AD RMS), Active Directory Federation Services (AD FS), Network Load Balancing, Failover Clustering, business continuity and disaster recovery services as well as access and information provisioning and protection technologies such as Dynamic Access Control (DAC), and Web Application Proxy integration with AD FS and Workplace Join. NOTE: This course is part three in a series of three courses that provides the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment.
Get hands-on instruction and practice planning, designing and deploying a physical and logical Windows Server® 2012 R2 enterprise infrastructure in this Microsoft® Official Course. This course covers the knowledge and skills needed to provide an enterprise solution that supports manual and automated server installations in a physical and virtual environment including the supporting file and storage services. Participants will also learn the skills necessary to provide enterprise networking solutions such as DHCP, IPAM, VPN, and DirectAccess. They will also learn the skills necessary to design and implement a forest and domain infrastructure including multi domains/forest and branch office scenarios. NOTE: This course is part one in a series of two courses that provides the skills and knowledge necessary to design and implement a Windows Server® 2012 R2 infrastructure in an enterprise environment.
Get hands-on instruction and practice planning, designing and deploying a physical and logical Windows Server® 2012 R2 enterprise infrastructure in this Microsoft® Official Course. This course covers the knowledge and skills to plan and implement a highly available, secure infrastructure with a focus on Active Directory® Federation Service (AD FS), Public Key Infrastructure (PKI), and Active Directory Rights Management Services (AD RMS). Participants will also learn the skills needed to plan and deploy virtual machines including self-service and automation of virtual machine deployments as well as planning and implementing a monitoring strategy that includes Microsoft System Center 2012 R2-Operations Manager. NOTE: This course is part two in a series of two courses that provides the skills and knowledge necessary to design and implement a Windows Server® 2012 R2 infrastructure in an enterprise environment.
This course provides participants with the technical skills required to write basic Transact-SQL queries for Microsoft® SQL Server® 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
This course provides participants with the knowledge and skills to maintain a Microsoft® SQL Server® 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.
This course describes how to implement a data warehouse platform to support a BI solution. Participants will learn how to create a data warehouse with Microsoft® SQL Server® 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. NOTE: It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
This course introduces participants to SQL Server® and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course.
The focus of this course is on planning and implementing enterprise database infrastructure solutions by using SQL Server® and other Microsoft® technologies. It describes how to consolidate SQL Server workloads and how to plan and implement high availability and disaster recovery solutions.
The focus of this course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft® SQL Server® Reporting Services, create dashboards with Microsoft SharePoint® Server PerformancePoint Services, and discover business insights by using data mining.
This course teaches participants how to plan and design a BI solution that is based on Microsoft® SQL Server® 2014 and other Microsoft BI technologies.
This course provides an introduction to HTML5, CSS3, and JavaScript®. It helps attendees gain basic TML5/CSS3/JavaScript programming skills. This course is an entry point into both the Web application and Windows Store apps training paths. The course focuses on using HTML5/CSS3/JavaScript to implement programming logic, define and use variables, perform looping and branching, develop user interfaces, capture and validate user input, store data, and create a well-structured application. The lab scenarios in this course are selected to support and demonstrate the structure of various application scenarios. They are intended to focus on the principles and coding components/structures that are used to establish an HTML5 software application. This course uses Visual Studio 2017, running on Windows 10.
This training course teaches developers the programming skills that are required for creating Windows® applications using the C# language. Candidates will review the basics of C# program structure, language syntax, and implementation details, and then consolidate their knowledge throughout the week as they build an application that incorporates several features of the .NET Framework 4.5. At the end of the course, candidates should leave the class with a solid knowledge of C# and how to use it to develop .NET Framework 4.5 applications.
In this course, attendees will learn to develop advanced ASP.NET Core MVC applications using .NET Core tools and technologies. The focus will be on coding activities that enhance the performance and scalability of the Web site application. This course will also prepare participants for the certification exam.
In this course, participants will learn how to design and develop services that access local and remote data from various data sources. Participants will also learn how to develop and deploy services to hybrid environments, including on-premises servers and Microsft® Azure®.
In this course, participants learn core skills that are common to almost all Microsoft® SharePoint® development activities. These include working with the server-side and client-side object models, developing and deploying features, solutions, and apps, managing identity and permissions, querying and updating list data, managing taxonomy, using workflow to manage business processes, and customizing the user interface.
This course provides participants with the information needed to implement Microsoft® SharePoint® solutions. Participants will be using Enterprise Search, Managed Metadata Service (MMS), Business Connectivity Services (BCS), Enterprise Content Management (ECM), Web Content Management (WCM), Social Computing Features and SharePoint Apps to do this.
This course is intended for IT professionals who are familiar with managing on-premises IT deployments that include AD DS, virtualization technologies, and applications. Participants typically work for organizations that are planning to locate some or all of their infrastructure services on Azure®.
This course will provide participants with the key knowledge required to deploy and configure Microsoft® Azure® Stack.
Get expert instruction and hands-on practice administering and configuring Windows® 8.1 in this Microsoft® Official Course. Participants will learn the skills they need to administer Windows 8.1 in a Windows Server domain environment and also provide secure, managed access to users from their non-domain joined Windows devices. As part of the learning experience, participants will perform hands-on exercises in a virtual lab environment.
Gain the knowledge and skills you need to support the Windows 8.1 operating system and solve technical troubleshooting problems in a Windows 8.1 and Windows Server® 2012 R2 networking environment. Through this Microsoft® Official Course, with extensive hands-on labs, participants will learn how key components of the Windows Operating system work in order to aid in troubleshooting system problems. They will also learn how to identify and resolve issues with networking, Windows Store apps, security, group policy, Internet Explorer, remote access, and support of mobile devices. This course uses new versions of Desktop Optimization Package (MDOP), Application Compatibility Toolkit (ACT), Windows Performance Toolkit (WPT), Microsoft Message Analyzer, and is the first course that uses the popular Sysinternals tools, and other tools.
This course describes how to assess the operating system and application deployment options, determine the most appropriate deployment strategy, and then implement a deployment solution for Windows® devices and apps that meets participants’ environment’s needs. This course details solutions that include operating system deployment scenarios ranging from high-touch solutions to zero-touch solutions. It also discusses the technologies that they would use to implement these solutions, including the MDT and Configuration Manager.
This course provides participants with the knowledge and skills required to install and configure Windows® 10 desktops and devices in a corporate Windows Server® domain environment. The skills that this course details include learning how to install and customize Windows 10 operating systems and apps and configure local and remote network connectivity and storage. Participants also will learn how to configure security for data, devices, and networks, and maintain, update, and recover Windows 10.
This course provides administrators with the knowledge and skills necessary to deploy and manage Windows® 10 desktops, devices, and applications in an enterprise environment. Participants will learn how to plan and implement Windows 10 deployments in large organizations. They will also learn how to manage the Windows 10 installations after deployment to provide secure identity and data access by using technologies related to User Experience Virtualization (UE-V), Group Policy, Work Folders and Client Hyper-V®. To support a variety of device and data management solutions, Microsoft Azure® Active Directory® (Azure AD), Microsoft Intune®, Microsoft Store for Business and Office 365® are used for device management. These services are part of the Enterprise Mobility + Security, which provides identity and access management, cloud-based device management, application and update management and more secure data access to information stored both on the cloud and onsite within a corporate network.
This course provides participants with the knowledge and skills required to install and configure Windows® 10 desktops in a Windows Server® small to medium-sized AD DS domain environment. These skills include learning how to install and customize Windows 10 operating systems and apps, configure local and remote network connectivity, and configure local and online storage. Participants will also learn how to configure security in addition to how to maintain, update, and recover Windows 10.
This course describes how to use the Configuration Manager and its associated site systems to efficiently manage network resources. Participants 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. They will also learn how to optimize System Centre Endpoint Protection, manage compliance, and create management queries and reports.
This course will help participants update their knowledge and skills related to storage and compute for Windows Server® 2016/2019. They will understand the scenarios, requirements, and storage and compute options that are available and applicable to it.
This course provides the fundamental networking skills required to deploy and support Windows Server® 2016/2019 in most organizations. It covers IP fundamentals, remote access technologies, and more advanced content including Software Defined Networking.
This course teaches participants how to deploy and configure Active Directory® Domain Services (AD DS) in a distributed environment, how to implement Group Policy, how to perform backup and restore, and how to monitor and troubleshoot Active Directory-related issues with Windows Server® 2016/2019. Additionally, this course teaches participants how to deploy other Active Directory server roles, such as Active Directory Federation Services (AD FS) and Active Directory Certificate Services (AD CS).
This course explains how to implement and configure new Windows Server® 2016 features and functionality. This course is for Information Technology (IT) professionals who want to upgrade their technical skills from Windows Server 2008 or 2012 to Windows Server 2016. This course is not a product upgrade course, rather, it provides updates to participants’ existing Windows Server knowledge and skills, as they pertain to Windows Server 2016.
This course teaches attendees how they can enhance the security of the IT infrastructure that they administer. It begins by emphasizing the importance of assuming that network breaches have occurred already, and then teaches attendees how to protect administrative credentials and rights to ensure that administrators can perform only the tasks that they need to when they need to. This course also details how attendees can mitigate malware threats, identify security issues by using auditing and the Advanced Threat Analysis feature in Windows Server® 2016, secure their virtualization platform, and use new deployment options, such as Nano server and containers to enhance security. The course also explains how attendees can help protect access to files by using encryption and dynamic access control, and how they can enhance their network’s security.
This course explains how to implement and manage virtualization infrastructure in a software-defined data centre by using System Center 2016 Virtual Machine Manager. The course also describes how to monitor the infrastructure by using System Center Operations Manager and protect it by using Data Protection Manager. The main focus of this course is on managing Hyper-V® virtualization infrastructure in Windows Server® 2016, although the course also covers other virtualization platforms that can be managed by using Virtual Machine Manager 2016.
This course is designed to introduce participants to Transact-SQL and give a good understanding of the language. This course also teaches the skills required to take the certification exam.
This course provides participants with the knowledge and skills to develop a Microsoft® SQL Server® 2016 database. It focuses on teaching individuals how to use SQL Server® 2016 product features and tools related to developing a database.
This course provides participants who administer and maintain SQL Server® databases with the knowledge and skills to administer a SQL Server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.
This course is designed to teach participants how to provision SQL Server® databases both on-premise and in SQL Azure®.
This course provides attendees with the knowledge and skills to provision a Microsoft® SQL Server® database. It covers SQL Server provision both on-premise and in Azure®, and covers installing from new and migrating from an existing install.
The focus of this course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course also helps you prepare for the certification exam.
This course teaches participants to design, build, and troubleshoot Microsoft® Azure® Cosmos DB solutions that meet business and technical requirements.
This course provides participants with the knowledge and skills to analyse data with Power BI®.
The main purpose of the course is to give participants the ability to add BI techniques to Excel® data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI®.
This course will teach participants knowledge of fundamental Windows operating system concepts in a Windows 10 environment. It will show them how to configure the operating system and install and upgrade client systems. The training also focuses on the management of applications, files and folders, devices, and the operating system (OS). The understanding of various modules is imparted through the hands-on labs.
This course is designed to help business professionals, who work in technical environments, learn the fundamentals and gain a better understanding of software development and application life cycle management. In this course, participants will learn how desktop and web applications are developed and the programming logic behind them. This course is also designed to help them prepare for the certification exam.
In this course, participants will be introduced to database design and administration. They will gain an understanding of core database concepts, creation of database objects, manipulation of data, data storage, and administration of a database. This course also helps participants prepare for the Microsoft® Technology Associate certification exam.
This course teaches participants how to administer and manage a Windows Server®. They will build an understanding through topics such as Server Installation, Server Roles, Active Directory, Storage, Server Performance Management, and Server Maintenance. This course also helps participants prepare for the Microsoft® Technology Associate certification exam.
This course helps you build an understanding of these topics: Network Infrastructures, Network Hardware, and Protocols and Services.
This course helps you build an understanding of these topics: Security Layers, Operating System Security, Network Security, and Security Software.
This course provides an understanding of HTML5, CSS3, and JavaScript™ and helps participants build the necessary development skills needed in using these technologies. It also helps participants prepare for the Microsoft® Technology Associate certification exam.
This course introduces HTML, JavaScript™ and CSS as programming and markup languages that are used to create web applications. Attendees will gain experience with each language individually and then combine them together to create compelling web application solutions. They will have an opportunity to use Visual Studio Code on their operating system of choice to create and test their web applications. This course teaches basic tasks that are necessary to create web applications with a strong semantic structure, re-usable style components and custom interactive features. This course also enables attendees to build basic HTML pages that are the components of a web application used to solve real-world problems.
In this course, participants will work with a media publishing company to design a hybrid cloud disaster recovery solution. They will design the solution to handle large spikes in load and harden the security to include encryption of Payment Card Industry (PCI) data. Additionally, they will implement an archival strategy to keep databases sizes in check.
This course provides insight into security practices to improve the security posture of an organization. The course examines the concept of Red Team vs. Blue Team security professionals, where one group of security pros, the red team, attacks some part or parts of a company’s security infrastructure, and an opposing group, the blue team, defends against the attack. Both teams work to strengthen a company’s defences. Since the goal of the two teams is to help the business attain a higher level of security, the security industry is calling this function, the Purple Team.
In this workshop, participants will work as a group to set up and configure a serverless architecture within Azure® using a combination of Azure Functions, Logic Apps, Event Grid, Cosmos DB, and Azure Storage. The focus is on removing server management from the equation, breaking down the solution into smaller components that are individually scalable, and allowing the customer to only pay for what they use.
This course will teach participants how to use PowerPivot to access data sources, create relationships, use the PowerPivot DAX expressions and generate and format reports. They will also explore how PowerPivot workbooks can be integrated with SharePoint®.
This course explores all the end user features of SharePoint® 2010 including all out of the box lists and sites. Learn to use the new ribbon effectively to manage list items and explore the new Office integration features and tools.
This course explores advanced topics of working with SharePoint® 2010 sites. Topics include SharePoint® Server site definitions (Business Intelligence, Search Center, etc.), in-depth coverage of Workflows, My Sites and Social Computing, Site Administration, Site Customization and Site Collection Administration.
This course is designed for the site owner/”power user” of a SharePoint® site who needs to know how to create sites and lists, manage user access and customize lists and pages. This class uses the SharePoint® Server 2010 version of SharePoint®. While it is of equal value for users of SharePoint® Foundation, it does include a few features not found in Foundation.
This course gives participants who have Microsoft® SharePoint® 2010 Owner permissions for a site the ability to manage, administer and modify a SharePoint 2010 site based on business needs and objectives. This course also provides IT Business Analysts with the necessary information to advise business units on which features are the best fit for their business processes. The course will provide participants with the necessary information on SharePoint 2010 features and capabilities including how to implement and best practices for implementing the feature. It will also focus on different aspects of governance, Office 2010 integration, workflows, web parts and much more, to help participants understand the depth and breadth of SharePoint 2010.
This course provides participants with the knowledge and skills to write basic Microsoft® Excel® lookup formulas as well as in-depth nesting of advanced array and reference functions. The course will also show that certain functions exist and what they look like but will show the diversity and usefulness of those functions. This is a very hands-on approach with constant examples, practices and problem-solving provided to the participants.
This class is designed for SharePoint® team members who need to know how to use the team collaboration and document management features of a Microsoft® SharePoint® 2010 Team Site.
This course teaches participants the fundamentals of managing SharePoint® 2013 sites.
This course is for end users working in a Microsoft® SharePoint 2013 environment. The course teaches SharePoint® basics such as working with lists and libraries as well as basic page customizations.
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. This course is also designed to complement skills such as SharePoint deployment or farm administration skills and tasks, which are required for IT professionals to manage SharePoint 2013, taught in other Microsoft Official Courseware.
This course will show participants how to work with Microsoft® Project Server 2013. Participants will also create and manage projects and schedules, resources, tasks and timesheets with Project Web App. As well as create and configure Business Intelligence for customized project reporting and how-to backup and restore and troubleshoot Project Server 2013.
This course teaches participants how to manage the team collaboration, document management and social features of Microsoft SharePoint 2013. NOTE: This course is an excellent prerequisite for IT Professionals who work as SharePoint Server Administrators and would like to attend the 20331: Core Solutions of Microsoft SharePoint Server 2013 course.
This course will help participants to further their skills in Windows® PowerShell® and administrative automation. It will teach them the correct patterns and practices for building reusable, tightly scoped units of automation.
This course is intended for individuals who are interested in expanding their knowledge base and technical skills about Microsoft® Project. The course begins with the basic concepts and leads students through all the functions they’ll need to plan and manage a small to medium-size project, including how to level resources and capture both cost and schedule progress.
This course will show participants how to develop applications using the various APIs available in Project Server including Project Server Interface (PSI), .NET Client-Side Object Model, JavaScript Object Model and REST. In addition, participants will learn how to extend on-premise Project Server installs via web parts, local and remote event handlers, Apps via the new App Model and workflows.
This course provides participants with the knowledge and skills necessary to effectively manage projects using Microsoft® Project Server 2010.
Explore Yammer® from various roles of End User, IT Pro and Developer with an emphasis on development.
This course is intended for project team member or project managers who build an easy-to-maintain and reusable work schedule for team members and partners. Managing task status and evaluate the work schedule in terms of time, man-hours, tasks, budgets on demand. Also would like to improve effective project team communication and collaboration.
The goal of this three-day instructor-led course is to provide students with the knowledge and skills necessary to effectively plan, deploy and manage Microsoft® Project Server 2010.
The goal of this course is to provide participants with the knowledge and skills necessary to effectively plan, deploy and administer Microsoft® Project Server 2013.
This course begins with project management basics and follows with a complete examination of project creation, management, troubleshooting and closure. Finally, sharing project progress and the options available will be discussed.
In this course, participants will learn how and why Active Directory (AD) was developed by Microsoft. They will also learn the fundamental architecture, basic design, and management for AD. Participants will learn about the security, and fundamentals of cloud integration with services like Azure® as well.
This course is designed for information workers who are using or will use Office 365®. It will provide participants with the knowledge and skills to efficiently use Office 365 on a day-to-day basis. The course is designed with real world scenarios in mind. Participants will learn how to use Outlook® Online, Skype® for Business, OneDrive® for Business, SharePoint® Online, and OneNote®. At the end of this course, participants will be able to effectively navigate Office 365 and make use of all of the features of Office 365.
This course is designed to introduce participants to the SQL Business Intelligence Semantic Model (BISM) Tabular model, data modelling, and DAX.
This course teaches participants how to combine the functionality of Power View, PowerPivot, Power Query, and Power BI® into graphs, charts, KPIs, reports, and other visualizations for use in their business.
This course is designed for participants new to working with Microsoft® Word in Windows®. Participants will learn to create, edit, format, and print Microsoft Word documents.
In this course, participants will learn advanced formatting, use Microsoft® Word 2016 drawing tools, create and manage tables, and work with column layouts.
In this course, participants will learn advanced techniques, such as working with tables of contents, footnotes, and endnotes, adding comments, tracking changes, comparing and combining documents, creating envelopes and labels, using Mail Merge, and protecting Microsoft® Word documents.
In this course, participants will spend time getting comfortable with the Project 2016 user interface, including project views and the ribbon. They will also learn to enter, organize, and link tasks, work with resources, create basic reports, and create projects independently. The course allows time to practice fundamental basic skills essential for efficient use of this program.
This course takes an in-depth approach to key features of Project 2016 including task entry and linking, resource and resource management, and examining and updating projects. Participants will learn to efficiently manage projects, create master projects and sub-projects, create and customize visual reports, work with resource pools, and learn about costing.
This course teaches participants to manage a schedule but NOT manage cost within Microsoft® Project. By focusing only on the SCHEDULING capabilities of Project, this course dramatically simplifies this powerful application.
This course 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®, OneDrive® and Intune. In this course, participants will learn high-level terminology, structure, security, deployment, and migration practices as well as the general scope of Microsoft® Cloud product offerings.
This course teaches participants the basics of SharePoint® such as working with sites, lists and libraries, basic page customizations as well as managing the different permissions of SharePoint.
This course is intended for individuals who are interested in expanding their knowledge base and technical skills about Microsoft® Project. The course begins with the basic concepts and leads students through all the functions they’ll need to plan and manage a small to medium-size project, including how to level resources and capture both cost and schedule progress.
This course delivers the complete site owner story engagingly and practically. This will ensure that participants have the confidence to plan and create new sites or manage their existing sites in SharePoint® Online. The goal is to teach participants how to make SharePoint Online relevant to their team using a site’s functionality to help them share information and collaborate with their colleagues. During the class, participants will also learn best practices and ‘what not to do’ as they watch live, interactive demonstrations and put theory into practice with hands-on exercises in SharePoint Online.
This course delivers the complete site owner story engagingly and practically. This will ensure participants have the confidence to plan and create new sites or manage their existing sites. The goal is to teach participants how to make SharePoint® relevant to their team using a site’s functionality to help them share information and collaborate with their colleagues. During the class, participants will also learn best practices and ‘what not to do’ as they watch live, interactive demonstrations and put theory into practice with hands-on exercises.
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 also 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 such as either 20339-1: Planning and Administering SharePoint 2016, 20339-2: Advanced Technologies of SharePoint 2016 or 20347: Enabling and Managing Office 365.
This course will introduce participants to the SharePoint® Online Administration in Office 365®. It will explain and demonstrate the configuration options for SharePoint Online. The course is appropriate for. The course will also help participants understand the differences between SharePoint on-premises and SharePoint Online.
This course will show participants how to design, create, customize, and support business solutions and apps built on Microsoft Dynamics 365® Customer Engagement (CRM) and the Power Platform.
This course will teach participants to design and implement database solutions in SQL Server and on Microsoft® Azure®. Participants will be acquainted with disaster recovery, security, monitoring, troubleshooting and availability options.
This course is designed to teach participants an overview of the roles and responsibilities of a SharePoint® Site Owner. They will learn how to add and configure sites and subsites, create and configure libraries and lists, create and customize columns, as well as create and manage content types. Participants will also learn the basics of permissions and how to manage the various permission levels, create and modify site pages, and work with web parts and app parts.
This course is an abbreviated version of the complete SharePoint® End-User course, 55199. In this course, participants will learn about the SharePoint basics such as working with sites, lists and libraries.
Microsoft® SharePoint® 2016 provides a business collaboration platform that streamlines document management, simplifies access to information, and provides the ability to deploy solutions quickly and securely. In this course, participants will gain a comprehensive overview of the SharePoint 2016 on-premise and SharePoint online platform. They will learn to create, manage, and customize SharePoint 2016 to the requirements of their organization.
This course is for end-users and site owners/managers new to working in a SharePoint® environment in Office 365®. The course teaches participants SharePoint basics such as working with lists and libraries, basic page customization, working with forms and managing site permissions and users.
This course teaches participants SharePoint® in Office 365® basics such as working with lists and libraries, basic page customization and managing site permissions and users.
This course is an abbreviated version of the complete course 55255: SharePoint® for Office 365® End-User. In this course, participants will learn about the SharePoint basics such as working with sites, lists and libraries.
This course will teach participants how to write Python code that logically solves a given problem. They will learn how to write, debug, maintain and document Python code.
This course delivers an instructor-led breakdown of Microsoft® PowerApps®. Participants will be taught how to design, test and publish new apps that work with a variety of data sources. The course will take them through a selection of well-crafted lessons to help them build new applications for their business.
This course delivers an engaging and practical product showcase of Microsoft® Flow from start to finish. Flow is a diverse product, turning business processes into automated, consistent and visual workflows. Flow is designed to interweave the various products in Office 365® as well as connect to other on-premises and web-based solutions. This course will give participants the confidence to select the right actions and workflow logic for their business workflows.
This course delivers a walkthrough of the various options for branding SharePoint® Online Sites. SharePoint Online has some non-code options to add logo’s, corporate colour schemes and conditional formatting on Apps. There are also options to add in coded customisations. This course will give participants guidance on how to use the non-code options available with practical labs to practice these methods. The course will also give participants guidance on the code options and advise where to look for the resources to do this. NOTE: The course will not cover how to write the code for the non-standard customisations.
This course is designed to help power users and end-users make the most of the Microsoft® Office 365® apps. It will teach participants how to collaborate across the business and understand when to use which of the Office 365 apps. This will help maximize your business adoption of Office 365 which is also known as Microsoft 365®.
In this course, participants will learn to program in Python. The course is aimed at participants new to the language who may or may not have experience with other programming languages. This course is taught using the latest version of Python; however, differences between the latest version of Python and older versions are noted.
In this course, participants will learn advanced Python techniques. This course is taught using the latest version of Python; however, differences between the latest version of Python and older versions are noted.
This course delivers the complete site owner story from start to finish engagingly and practically. This will ensure that participants have the confidence to plan and create new sites or manage their existing sites. Their goal is to learn how to make SharePoint® relevant to their team by using a site’s functionality to help them share information and collaborate with their colleagues. During the class, participants will also learn best practices and ‘what not to do’ as they watch live, interactive demonstrations and put theory into practice with hands-on exercises.
In this course, participants will spend time getting comfortable with the Microsoft® Project 2019 or Project 365 user interface, including project views and the ribbon. They will learn to enter, organize, and link tasks, work with resources, create basic reports, and create projects independently. The course also allows time to practise fundamental basic skills essential for efficient use of this program.
This course takes an in-depth approach to key features of Microsoft® Project 2019 or Project 365. These features include task entry and linking, resource and resource management, and examining and updating projects. Participants will learn to efficiently manage projects, create master projects and sub-projects, create and customize visual reports, work with resource pools, and analyze project costs.
This course teaches participants the SharePoint® basics such as working with lists and libraries, basic page customization, working with forms and managing site permissions and users.
In this course, participants will learn the fundamentals of managing SharePoint® sites by creating custom workflows using SharePoint Designer 2013, using Metadata Navigation, using Information Management Policies, etc.
This course is an abbreviated version of the complete SharePoint® End-User course, 55293. In this course, participants will learn about the SharePoint basics such as working with sites, lists and libraries.
This course is designed to teach participants an overview of the roles and responsibilities of a SharePoint® Site Owner. They will learn how to add and configure sites and subsites, create and configure libraries and lists, create and customize columns, as well as create and manage content types. Participants will also learn the basics of permissions and how to manage the various permission levels, create and modify site pages, and work with web parts and app parts.
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.
This course delivers the complete site owner story from start to finish in an engaging and practical way to ensure participants have the confidence to plan and create new sites or manage their existing sites in SharePoint® Server SE (Subscription Edition). The goal is to learn how to make SharePoint Server SE relevant to your team by using a site's functionality to help you share information and collaborate with your colleagues. During the class, participants will also learn best practices and ‘what not to do’ as they study and put theory into practice with hands-on labs in SharePoint Server SE.
The course describes fundamental database concepts including database types, database languages, and database designs.
This course teaches participants how to use basic Transact-SQL statements and other languages to query modern editions of Microsoft® SQL Server® and Azure® SQL Server. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. By using demonstrations and hands-on labs, participants will learn to perform these tasks using SQL Server, Azure Data Studio, and other database tools.
This course teaches participants how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages. The course will also teach them to use SSIS to extract, transform, and load data to and from SQL Server®.
In this course, participants will learn the basics of computer programming using Microsoft® Visual Studio® and the Visual C# and Visual Basic programming languages. The course assumes no prior programming experience and introduces the concepts needed to progress to the intermediate courses on programming, Programming in C#. The focus will be on core programming concepts such as computer storage, data types, decision structures, and repetition by using loops. The course also covers an introduction to object-oriented programming covering classes, encapsulation, inheritance, and polymorphism. Coverage is also included around exception handling, application security, performance, and memory management.
This course teaches developers the programming skills that are required to create applications using the C# language. During the course, participants will review the basics of C# program structure, language syntax, and implementation details. They will then consolidate their knowledge throughout the course as they build an application that incorporates several features of .NET.
In this course, participants will learn to develop advanced ASP.NET Core applications using .NET tools and technologies. The focus will be on coding activities that enhance the performance and scalability of the Web site application.
This course is for participants who need to understand the scenarios, requirements, and storage and computing options that are available and applicable to Windows Server®. Although this course and the associated labs are written for Windows Server 2022, the skills taught will also be backwards compatible with Server 2016 and 2019.
This course provides the fundamental networking skills required to deploy and support Windows Server® in most organizations. It covers IP fundamentals, remote access technologies, and more advanced content including Software Defined Networking. Although this course and the associated labs are written for Windows Server 2022, the skills taught will also be backwards compatible with Server 2016 and Server 2019.
This course teaches IT professionals how to deploy and configure Active Directory® Domain Services (AD DS) in a distributed environment, how to implement Group Policy, how to perform backup and restore, and how to monitor and troubleshoot Active Directory-related issues with Windows Server®. Additionally, this course teaches students how to deploy other Active Directory server roles, such as Active Directory Federation Services (AD FS) and Active Directory Certificate Services (AD CS). Although this course and the associated labs are written for Windows Server 2022, the skills taught will also be backwards compatible with Server 2016 and 2019.
This course is designed to provide participants with the knowledge and skills required to install and configure Windows 11® desktops and devices in an on-premises Windows Server Active Directory® domain environment.
In this course, participants will learn day-to-day management tasks. These include how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. They also will learn how to optimize Endpoint Protection, manage compliance, and create management queries and reports.
This course provides participants with the knowledge and skills to administer a SQL Server® database infrastructure.
This course describes how to set up, configure and manage an Office 365™ tenant including identities, and the core services of Microsoft 365. Participants will learn how to plan the configuration of an Office 365 tenant including integration with existing user identities; plan, configure and manage core services; and report on key metrics.
This course examines the services and features of Microsoft® SQL from 2012 to 2022, including lessons and lab exercises on key attributes participants will need on the job. It’s designed for novices and professionals who are interested in interacting with databases using Structured Query Language (SQL) and seek foundational knowledge and skills. This audience typically includes people who are moving into a database role or expect their role to require interacting with a database server that uses SQL.
This course covers the administration of core components and technologies in Windows Server® 2022. The course begins with an administration techniques overview and then continues to topics such as identity services, networking, virtualization, high availability, disaster recovery, and others. This is a very extensive course, with copious content and labs, and it can serve as a helpful guide when administering a Windows Server environment.
In this course, participants will learn how to provision SQL Server® databases for both on-premises and in Azure®. The course covers new installations and migrations from existing installations. It also covers the concepts, techniques, and best practices for creating, configuring, and managing databases on Microsoft SQL Server.
In this course, participants will learn about SharePoint® Online Administration. SharePoint Online is part of Microsoft 365 and underpins all the file experiences in Microsoft 365™.
This course will give participants a more in-depth knowledge of Microsoft® Azure® services. Participants will learn how to administer and architect a solution. Other lessons include virtualisation, automation, networking, storage, identity, security, data platform, and application infrastructure. This course outlines how decisions in each of these areas affect an overall solution.
In this course, participants will begin to understand the complexities of cybersecurity. including the cybersecurity landscape and cryptography. Participants will also be shown how users, devices, applications, and networks can influence the effectiveness of the security perimeter. They will then see how the use of a Zero Trust framework as an overarching strategy can bolster and improve their cybersecurity perimeter.
This course will provide insight into the development techniques and approaches that can be applied to solutions built on the Microsoft® Power Platform®. Participants will learn the necessary skills to extend, integrate and implement Power Platform solutions. Participants will also learn about the Application Lifecycle Management (ALM) frameworks available to help support and maintain Power Platform implementations, including the Microsoft Power Platform Build Tools for Azure® DevOps and the PowerApps® Center of Excellence (CoE).
This course will take participants on a journey from the concepts of a Microsoft® Power BI® project right through to the end result in an engaging and structured format. Participants will get hands-on with a wealth of data to practise the techniques taught in this course.
This course will teach participants to build AI-infused applications that leverage Azure® AI Services, Azure AI Search, and Azure OpenAI. The course will use C# or Python as the programming language.
This course introduces fundamentals concepts related to artificial intelligence (AI), and the services in Microsoft® Azure® that can be used to create AI solutions. The course is not designed to teach participants to become professional data scientists or software developers, but rather to build awareness of common AI workloads and the ability to identify Azure services to support them.
This course provides knowledge and skills to deploy an application infrastructure in DevOps pipelines. Students will learn how to implement infrastructure as code and configuration management, how to provision Azure infrastructure using common automation tools, and how to deploy an application infrastructure using various Azure services and deployment methodologies. Participants will also learn how to integrate third-party deployment tools with Azure, such as Chef and Puppet, to incorporate compliance and security into the release pipeline.
This course will help participants learn how Azure® is different from AWS, and how Azure is administered. The course combines lecture with hands-on practical exercises and discussion/review. During the course, participants will build an end-to-end architecture that demonstrates the main features discussed.
This course is designed to teach participants how to prepare end-to-end solutions in Microsoft® Azure®. In this course, participants will construct Azure App Service Web App solutions and Azure Functions, use blob or Cosmos DB storage in solutions, implement secure cloud solutions that include user authentication and authorization, implement API management, and develop event- and message-based solutions, monitor, troubleshoot, and optimize their Azure solutions. They will also learn how developers use Azure services, with additional focus on features and tasks that differ from AWS, and what that means for them as they develop applications that will be hosted by using Azure services.
This course teaches participants how to translate business requirements into secure, scalable, and reliable solutions for Microsoft® Azure®. Lessons include virtualization, automation, networking, storage, identity, security, data platform, and application infrastructure. This course also outlines how decisions in each of these areas affect an overall solution.
This course teaches participants how to manage their Microsoft ® 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 their solution.
This course teaches participants how to leverage Azure resources which will include deployment and configuration of virtual machines, virtual networks, storage accounts, and Azure Active Directory® (AD) that includes implementing and managing hybrid identities. Participants will learn through concepts, scenarios, procedures, and hands-on labs on how to best plan and implement migration and operation of an SAP solution on Azure. They will receive guidance on subscriptions, create and scale virtual machines, implement storage solutions, configure virtual networking, back up and share data, connect Azure and on-premises sites, manage network traffic, implement Azure AD, secure identities, and monitor their solution.
This course teaches participants how to plan, deliver, and manage virtual desktop experiences and remote apps, for any device, on Azure. They will learn through a mix of demonstrations and hands-on lab experiences to deploy virtual desktop experiences and apps on Azure Virtual Desktop (formerly Windows Virtual Desktop) and optimize them to run in multi-session virtual environments.
This course teaches participants how to create end-to-end solutions in Microsoft® Azure®. They will learn how to implement Azure compute solutions, create Azure Functions, implement, and manage web apps, develop solutions utilizing Azure storage, implement authentication and authorization, and secure their solutions by using Key Vault and Managed Identities. Participants will also learn how to connect to and consume Azure services and third-party services and include event- and message-based models in their solutions. The course also covers monitoring, troubleshooting, and optimizing Azure solutions.
This course teaches participants how to translate business requirements into secure, scalable, and reliable solutions. Lessons include virtualization, automation, networking, storage, identity, security, data platform, and application infrastructure. This course outlines how decisions in each of these areas affect an overall solution.
This course teaches Solutions Architects how to translate business requirements into secure, scalable, and reliable solutions. Lessons include design considerations related to logging, cost analysis, authentication and authorization, governance, security, storage, high availability, and migration. This role requires decisions in multiple areas that affect an overall design solution.
This course provides the knowledge and skills to design and implement Microsoft® DevOps processes and practices. Participants will learn how to Plan for DevOps, Use source control, Scale Git for an enterprise, Consolidate artefacts, Design a dependency management strategy, Manage secrets, Implement continuous integration, Implement a container build strategy, Design a release strategy, Set up a release management workflow, Implement a deployment pattern, and Optimize feedback mechanisms.
This course provides participants with the knowledge and skills needed to implement security controls, maintain an organization’s security posture, and identify and remediate security vulnerabilities. This course also looks at security for identity and access, platform protection, data and applications, and security operations in Microsoft® Azure®.
This course teaches participants how to plan, deploy, package, update, and maintain the Azure® Stack Hub infrastructure. Lessons include deploying Azure Stack Hub, managing the Azure Stack Hub Marketplace, offering App Services and Event Hub resource providers, managing Azure Stack Hub registration, and maintaining system health.
This course teaches participants how to design, implement, and maintain secure Azure networking solutions. They will also learn how to establish hybrid connectivity, routing, private access to Azure services, and monitoring in Azure.
This course will provide foundational level knowledge of cloud services and how those services are provided with Microsoft® Azure®. It 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. Finally, it will also cover pricing and support services available with Azure. This course provides an Azure pass and time for participants to participate in hands-on labs. NOTE: If you do not need hands-on experience, consider the AZ-900T01: Microsoft® Azure Fundamentals (1 day) course. The content for both courses aligns with the AZ-900 exam objective domain.
This course will provide foundational level knowledge of cloud services and how those services are provided with Microsoft® Azure®. It 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. Finally, it will also cover pricing and support services available with Azure. NOTE: This course DOES NOT provide an Azure pass or time for students to participate in hands-on labs. If you are interested in a more interactive hands-on lab experience, consider the AZ-900T00: Microsoft Azure Fundamentals (2 days) course, which includes trainer-directed hands-on labs. The content for both courses aligns with the AZ-900 exam objective domain.
This course has been designed to help participants gain maximum exposure to this platform so that they can learn its installation, configuration, controls and web services. Participants will learn how to use Xamarin Studio and build mobile applications using C#. They will be able to write code to access the database and application resources, and the basics of testing and publishing.
This course builds on the foundational knowledge of the Microsoft® Office 365® online apps. It introduces the desktop, online and mobile versions of the Microsoft Teams™ application to participants. Participants will learn how to collaborate on shared files and conduct online meetings.
This course teaches participants how to build cross-platform mobile apps using Xamarin and C#. They will explore all the layers of a Xamarin app, from design to deployment. This course will also teach participants design practices that maximize code reuse and isolate device-specific code, making it a snap to incorporate the unique features of each OS. By the end, participants will be able to build a quality, production-ready Xamarin app on iOS and Android from scratch with a high level of code reuse.
This course will discuss the various methods and best practices that are in line with business and technical requirements for modelling, visualizing, and analysing data with Microsoft® Power BI®. The course will also show participants 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 participants how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.
Analysing 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. This course will show participants how to use Excel to 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. At the end of this course, these capabilities will enable participants to turn data into thoughtful action.
In this course, participants will explore the objectives of data platform modernization and how it is suitable for given business requirements.
This course will enable participants to understand the Azure® SQL Database and educate them on what is required to migrate MySQL and PostgreSQL workloads to Azure SQL Database.
This course will teach participants how to use Transact-SQL. They will learn to query and modify data in relational databases hosted in Microsoft SQL Server-based database systems, including Microsoft SQL Server, Azure SQL Database and Azure Synapse Analytics.
In this course, participants will implement various data platform technologies into solutions that are in-line with business and technical requirements. This will include on-premises, cloud, and hybrid data scenarios incorporating both relational and NoSQL data. Participants will also learn how to process data using a range of technologies and languages for both streaming and batch data. They 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, they will manage and troubleshoot Azure® data solutions which include the optimization and disaster recovery of big data, batch processing, and streaming data solutions.
In this course, participants will design various data platform technologies into solutions that are in line with business and technical requirements. This includes on-premises, cloud, and hybrid data scenarios which incorporate relational, NoSQL, or Data Warehouse data. They will also learn how to design process architectures using a range of technologies for both streaming and batch data. The participants will also explore how to design data security, including data access, data policies, and standards. They will also design Azure® data solutions, which includes the optimization, availability, and disaster recovery of big data, batch processing, and streaming data solutions.
In this course, participants will learn about data engineering as it pertains to working with batch and real-time analytical solutions using Azure data platform technologies. They will learn how to create, manage, use, and configure data services in the Azure portal. Through a blend of hands-on labs and interactive lectures, participants will learn to build and maintain secure and compliant data processing pipelines by using different tools and techniques. Participants will learn to use various Azure data services and languages to store and produce cleansed and enhanced datasets for analysis. Lastly, participants will be able to create a real-time analytical system to create real-time analytical solutions.
This course provides participants with the knowledge and skills to administer a SQL Server® database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft® PaaS relational database offerings.
In this course, participants will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft® Azure®.
Welcome. Whether you’re new to computers or have used them in the past, this class will help you become more comfortable using a personal computer (PC) and, more specifically, the Windows® 10 interface. This course will help you to define what a PC is, and familiarize you with the Windows 10 user interface and its basic capabilities. In this course, you will explore Windows 10 and learn how to create documents, send email, browse the Internet, and share information between applications and with other users.
In this course, participants will explore Microsoft® Windows 11. They will learn how to work with locally installed apps as well as cloud-based apps. They will also learn to browse the Internet and manage basic Windows 11 settings.
Welcome to Introduction to Personal Computers Using Microsoft® Windows® 7. Whether you’re new to computers or have used them in the past, this class will help you become more comfortable using a personal computer (PC) and, more specifically, the Windows® 7 interface. This course will help you to define what a PC is, log on to Windows® 7, explore the Windows® 7 interface, manage files and folders, use the common tools and programs available in Windows® 7, customize the Windows® 7 desktop, and browse the Internet.
Welcome to Introduction to Personal Computers Using Microsoft® Windows® 8. Whether you’re new to computers or have used them in the past, this class will help you become more comfortable using a personal computer (PC) and, more specifically, the Windows® 8 interface. This course will help you to define what a PC is, and familiarize you with the Windows 8 user interface and its basic capabilities. In this course, you will explore Windows 8 and learn how to create documents, send email, browse the Internet, and share information between applications and with other users.
Welcome to Introduction to Personal Computers Using Microsoft® Windows® 8.1. Whether you’re new to computers or have used them in the past, this class will help you become more comfortable using a personal computer (PC) and, more specifically, the Windows 8.1 interface. This course will help you to define what a PC is, and familiarize you with the Windows 8.1 user interface and its basic capabilities. In this course, you will explore Windows 8.1 and learn how to create documents, send email, browse the Internet, and share information between applications and with other users.
In this course, participants will learn how to support and configure Windows 10 desktops in an organizational environment. They will develop skills that include learning how to install, customize, and update Windows® 10 operating systems (OS). Participants will also learn how to manage storage, files, and devices as well as how to configure network connectivity for Windows 10. Finally, they will learn how to secure the Windows 10 OS and protect the data on the device, and how to manage and troubleshoot Windows 10. NOTE: This course is a compilation of the following four courses — MD-100T01: Installing Windows 10, MD-100T02: Configuring Windows 10, MD-100T03: Protecting Windows 10 and MD-100T04: Maintaining Windows 10. Clients have the option of updating their knowledge in one go with this course or doing so in four stages with the four aforementioned courses.
In this course, participants will learn how to support the installation tasks associated with Windows® 10. They will develop skills such as learning how to install and customize Windows 10 operating systems. They will also learn about the new Windows servicing model and methods for keeping Windows up to date. The course will conclude with common post-installation tasks. NOTE: Clients can take this course on its own or take the MD-100T00: Windows 10 course which is a combination of the following courses — MD-100T01: Installing Windows 10, MD-100T02: Configuring Windows 10, MD-100T03: Protecting Windows 10 and MD-100T04: Maintaining Windows 10.
In this course, participants will learn how to support the configuration tasks associated with Windows® 10. They will develop skills such as managing storage, files, drivers, and printers as well as how to configure network connectivity for Windows 10 as well. This course will also cover managing and deploying applications. NOTE: Clients can take this course on its own or take the MD-100T00: Windows 10 course which is a combination of the following courses — MD-100T01: Installing Windows 10, MD-100T02: Configuring Windows 10, MD-100T03: Protecting Windows 10 and MD-100T04: Maintaining Windows 10.
In this course, participants will learn how to secure the Windows® 10 OS and protect the data on the device. They will be introduced to common methods used for authentication and access control as well. This course will teach participants how to configure file and folder permissions and creating security policies. They will also be introduced to the different types of external threats and how to leverage features like encryption and firewalls, as well as tools like Windows Defender. NOTE: Clients can take this course on its own or take the MD-100T00: Windows 10 course which is a combination of the following courses — MD-100T01: Installing Windows 10, MD-100T02: Configuring Windows 10, MD-100T03: Protecting Windows 10 and MD-100T04: Maintaining Windows 10.
In this course, participants will learn how to manage and troubleshoot Windows® 10. Additionally, this course will deep-dive into the architecture and tools used for managing, monitoring, and troubleshooting the operating system, applications, and hardware. Participants will also learn about proactive and troubleshooting methodology, and how to identify and mitigate common issues. NOTE: Clients can take this course on its own or take the MD-100T00: Windows 10 course which is a combination of the following courses — MD-100T01: Installing Windows 10, MD-100T02: Configuring Windows 10, MD-100T03: Protecting Windows 10 and MD-100T04: Maintaining Windows 10.
In this course, participants will learn how to plan and implement an operating system deployment strategy using modern deployment methods, as well as how to implement an update strategy. They will be introduced to key components of modern management and co-management strategies. This course also covers what it takes to incorporate Microsoft Intune® into an organization. Participants will also learn about methods for deployment and management of apps and browser-based applications. Then, they will be introduced to the key concepts of security in modern management including authentication, identities, access, and compliance policies. Finally, participants will be introduced to technologies such as Azure® Active Directory® (AD), Azure Information Protection and Windows® Defender Advanced Threat Protection, as well as how to leverage them to protect devices and data. NOTE: This course is a compilation of the following three courses — MD-101T01: Deploying the Modern Desktop, MD-101T02: Managing Modern Desktops and Devices and MD-101T03: Protecting Modern Desktops and Devices. Clients have the option of updating their knowledge in one go with this course or doing so in three stages with the three aforementioned courses.
As desktops have evolved, so have methods for deploying and updating them. In this course, participants will learn how to plan and implement an operating system deployment strategy. Additionally, this course will help them understand the various methods available, the scenarios they're suited for, as well as how to deploy Windows® using modern methods. This course will also cover planning and implementing an update strategy for Windows. NOTE: Clients can take this course on its own or take the MD-101T00: Managing Modern Desktops course which is a combination of the following courses — MD-101T01: Deploying the Modern Desktop, MD-101T02: Managing Modern Desktops and Devices and MD-101T03: Protecting Modern Desktops and Devices.
As demand for organizations to enable workforces to be more mobile, a desktop administrator’s role is really is no longer about just “desktop” management. With “Bring Your Own Device” (BYOD) becoming commonplace and the need for employees to access line of business apps on personal devices, the scope of desktop administration must include both desktop and mobile devices, regardless of ownership. During this course, participants will be introduced to key components of modern management and co-management strategies. They will examine what it takes to incorporate Microsoft Intune® into their organization and how to use it to manage modern desktops and devices. They will also learn about methods for deployment and management of apps and browser-based applications. NOTE: Clients can take this course on its own or take the MD-101T00: Managing Modern Desktops course which is a combination of the following courses — MD-101T01: Deploying the Modern Desktop, MD-101T02: Managing Modern Desktops and Devices and MD-101T03: Protecting Modern Desktops and Devices.
In this course, participants will be introduced to the key concepts of security in modern management. This course covers authentication, identities, and access, as well as how to protect these categories. They will also be introduced to the Azure® Active Directory® and learn how to use Microsoft Intune® to protect devices and data with compliance policies. Finally, this course will cover the key capabilities of Azure Information Protection and Windows Defender Advanced Threat Protection and how to implement these capabilities. NOTE: Clients can take this course on its own or take the MD-101T00: Managing Modern Desktops course which is a combination of the following courses — MD-101T01: Deploying the Modern Desktop, MD-101T02: Managing Modern Desktops and Devices and MD-101T03: Protecting Modern Desktops and Devices.
This course is an introduction to Microsoft 365® cloud-based tools and can be used as an orientation to the full suite. Using the Microsoft 365 suite of productivity apps, users can easily communicate and collaborate through Microsoft Outlook® mail and Teams® messaging and meeting functionality. Additionally, the Microsoft® SharePoint® team site provides a central storage location for accessing and modifying shared documents. This course introduces working with shared documents in the familiar Microsoft 365 web apps—Word, PowerPoint®, and Excel®—as an alternative to installing the Microsoft Office desktop applications.
This course builds on your foundational knowledge of the Microsoft® 365 core apps and takes a deeper look at some of the productivity apps beyond Microsoft Word, Excel®, and PowerPoint®. Knowing that productivity often begins with assembling the right people, this course starts with the Teams® app that is used to collaborate on shared files and conduct online meetings. The connection between Planner and Teams is established to keep the group's work on schedule. The Forms app is introduced as a tool for collecting information that can be used to help determine your next course of action.
Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft® Access® for Office 365™can help participants and their organization with this task. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access.
In this course, participants will expand their knowledge of relational database design. They will learn how to promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending their knowledge of Microsoft® Access® for Office 365™ will result in a robust, functional database for their users.
Once participants have covered many of the basic functions of Microsoft® Access® for Office 365™, they are ready to learn advanced Access features. In this course, features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more will be covered. Knowledge of these features separate database professionals from casual database users or occasional designers.
Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyse data and gain actionable insight is greater than ever. Microsoft® Excel® for Office 2021 can do this and so much more. This course will teach participants how to harness the power of advanced PivotTable features and create PivotCharts Participants will not only learn to summarize data for analysis but also organize the data in a way that can be meaningfully presented to others.
Microsoft® Excel® for Office 365™ can help participants organize, calculate, analyse, revise, update, and present their data in ways that will steer their decision-makers in the right direction. With this specialized software these tasks are made much easier for participants to accomplish, and in much less time as well. This course aims to provide participants with a foundation in Excel knowledge and skills. Eventually, they can build upon that foundation and become an expert in data manipulation.
This course builds upon the foundational knowledge presented in the course, Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1. It will help participants in creating advanced workbooks and worksheets that can help deepen their understanding of organizational intelligence. This course also aims to help participants extract actionable organizational intelligence from their raw data. Participants will be shown how to analyse massive amounts of data, extract actionable information from it, and present that information.
This course builds upon the foundational and intermediate knowledge presented in the courses, Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1 and Part 2. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at their fingertips. This course aims to help participants to get Excel to do more for them so they can focus on what is important: staying ahead of the competition.
With the tremendous amount of available data, the ability to make sense of it continues to be an ongoing challenge. You already know how to use Excel to perform simple calculations and modify worksheets to make them easier to read, interpret, and present to others. But Excel can do so much more. This course introduces the basics of data analysis and how to use Excel to create informative dashboards. This allows participants to be able to extract actionable organizational intelligence from their raw data and present it in a visually compelling format that enables decision-makers to view key trends and gain insights. Note: This course builds upon the foundational knowledge presented in the Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1 course and introduces the basics of data analysis and how to use Excel to create informative dashboards.
With the tremendous amount of available data, the ability to make sense of it continues to be an ongoing challenge. This course introduces the basics of data analysis and how to use Microsoft® Excel® to create informative dashboards. This allows participants to be able to extract actionable organizational intelligence from their raw data and present it in a visually compelling format that enables decision-makers to view key trends and gain insights.
Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze data and gain actionable insight is greater than ever. You already have experience working with Microsoft® Excel® and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.
Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Microsoft® Excel® provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.
Participants will learn how to use Microsoft® InfoPath® 2010/2013 to gather and share information by creating and implementing XML-based forms.
A relational database application such as Microsoft® Office Access® 2010 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, participants will learn how to use Access 2010 to manage their data, including creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.
Your training and experience using Microsoft® Access® 2010 has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, participants will expand their knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access 2010 will result in a robust, functional database for your users.
You've covered many of the basic functions of Microsoft® Office Access® and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more. Knowledge of these features separate database professionals from casual database users or occasional designers. This course, adds on to the knowledge and skills participants have gained previously and, rounds out their Access education and provides them with marketable job skills.
This course will teach participants how to exchange data with other applications, automate business processes by using VBA code, and secure and share databases.
A relational database application such as Microsoft® Office Access® 2013 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, participants will learn how to use Access 2013 to manage their data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
Your training and experience using Microsoft® Access® 2013 has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, participants will expand their knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access 2013 will result in a robust, functional database for your users.
You've covered many of the basic functions of Microsoft® Office Access® and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more. Knowledge of these features separate database professionals from casual database users or occasional designers. This training, added to that which participants have gained from the previous two levels or experience, rounds out their Access education and provides them with marketable job skills.
A relational database application such as Microsoft Office Access 2016 can help attendees and their organizations collect and manage large amounts of data. Access is a versatile tool. Attendees can use it as a personal data management tool (for their use alone), or they can use it as a construction set to develop applications for an entire department or organization. In this course, attendees will use Access 2016 to manage data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
In this course, attendees will expand their knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users.
In this course, attendees will learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. Today's training will round out attendees’ Access education and provides them with marketable job skills.
Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft® Office Access® can help you and your organization with this task. This course focuses on the design and construction of an Access database which entails viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports. NOTE: This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access 2019.
Previous training and experience using Microsoft® Office Access® should have given participants basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, they will expand their knowledge of relational database design, promote quality input from users, improve database efficiency and promote data integrity, and implement advanced features in tables, queries, forms, and reports. Extending their knowledge of Access will result in a robust, functional database for their users. This course focuses on the optimization of an Access database, including optimizing performance and normalizing data, data validation, usability, and advanced queries, forms, and reports. NOTE: This course is the second part of a three-course series that covers the skills needed to perform database design and development in Access 2019.
Participants have covered many of the basic functions of Microsoft® Office Access®, and now they are ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separate database professionals from casual database users or occasional designers. NOTE: This course is the third part of a three-course series that covers the skills needed to perform database design and development in Access 2019.
This course will focus on the design and construction of an Microsoft® Office Access® database. Therefore, participants will learn how to view, navigate, search, and enter data in a database. They will also learn basic relational database design and create simple tables, queries, forms, and reports.
Your training and experience using Microsoft® Office Access® have given you basic database management skills. In this course, participants will expand their knowledge of relational database design. They will learn to promote quality input from users, improve database efficiency and promote data integrity, and implement advanced features in tables, queries, forms, and reports. At the end of this course, participants will be able to create a robust, functional database for their users.
Microsoft® Excel® has the power to help persons organize, calculate, analyze, revise, update, and present their data in ways that will help the decision-makers in their organization to steer the company in the right direction. To do this, first, one needs to know exactly how to ask Excel the questions that need to be answered, which questions to ask and how to interpret the answers Excel gives. Beyond that, this course aims to provide participants with the foundational knowledge and skills necessary to make data easier to read, interpret, and present to others.
The ability to analyze massive amounts of raw data, extract actionable intelligence from it, and present that information to decision-makers is the cornerstone of a successful organization that can compete at a high level. Microsoft® Excel® enables knowledgeable users to excel in these tasks. This is exactly what this course aims to help participants with. It also builds upon the foundational knowledge presented in the previous level course as well as help participants start down the road to creating advanced workbooks and worksheets that can help deepen their organizational intelligence.
This course aims to help participants use Microsoft® Excel® to do more for them. There is no wasting time scouring over workbooks to resolve issues or performing repetitive, monotonous tasks. They can focus on what is important: staying ahead of the competition. This course builds off of the foundational and intermediate knowledge presented in the previous two-level courses so that participants can get the most out of their Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at their fingertips. The more participants learn about how to use Excel to do the hard work for them, the more they'll be able to focus on getting the answers they need from the vast amounts of data their organization generates.
Excel® can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision-makers in your organization steer you in the right direction. Of course, knowing exactly how to ask Excel the questions that you need answered, which questions you can even ask, and how to interpret the answers Excel gives is necessary before you can even begin to embark on the journey ahead. This course aims to provide you with the foundational Excel knowledge and skills necessary to begin that journey.
This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2013: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.
This course builds off of the foundational and intermediate knowledge presented in the Microsoft® Office Excel® 2013: Part 1 and Part 2 courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.
This course builds upon the foundational knowledge presented in either of the Microsoft® Office Excel® 2016: Part 1 (Desktop/Office 365™) courses. It will help participants start down the road to creating advanced workbooks and worksheets that they can use to create dashboards. The ability to analyse massive amounts of data, extract actionable intelligence from it, and present that information to decision-makers is the cornerstone of driving a successful organization that can compete at a high level.
This course aims to provide attendees with a foundation for Excel knowledge and skills, which they can build upon to eventually become an expert in data manipulation. Excel can help persons organize, calculate, analyse, revise, update, and present their data in ways that will help the decision makers to steer the organization in the right direction.
This course builds upon the foundational knowledge presented in the Microsoft Office Excel 2016: Part 1 course. It will help start participants down the road to creating advanced workbooks and worksheets that can help deepen their understanding of organizational intelligence. Persons need to be able to extract actionable organizational intelligence from their raw data. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.
This course builds off of the foundation and intermediate knowledge presented in the Microsoft Office Excel 2016: Part 1 and Part 2 courses to help you get the most out of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips.
Microsoft® Office Excel® can help persons organize, calculate, analyze, revise, update, and present their data in ways that will help the decision makers in their organization steer them in the right direction. It will also make these tasks much easier for persons to accomplish, and in much less time, than if they had used traditional pen-and-paper methods or non-specialized software. This course aims to provide participants with a foundation for Excel knowledge and skills, which they can build upon to eventually become an expert in data manipulation.
This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2019: Part 1 course. It will also help participants start down the road to creating advanced workbooks and worksheets that can help deepen their understanding of organizational intelligence. The ability to analyse massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.
This course builds upon the foundational and intermediate knowledge presented in the previous two level courses to help attendees get the most of their Excel® experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.
This course aims to provide participants with a foundation in Microsoft® Office® Excel 2021 knowledge and skills. Participants can eventually build upon them to become an expert in data manipulation.
This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2021: Part 1 course. It will help start participants down the road to creating advanced workbooks and worksheets that can help deepen their understanding of organizational intelligence. This course will teach participants to analyse massive amounts of data, extract actionable information from it, and present that information to decision-makers. At the end of this course, participants will be able to use Excel to provide the answers to any questions they may have about their data.
This course builds upon the foundational and intermediate knowledge presented in the Microsoft® Office Excel® 2021: Part 1 and Microsoft® Office Excel® 2021: Part 2 courses to help participants maximise their Excel experience. This course aims to teach participants how to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic and dynamic arrays to construct and apply elaborate formulas and functions. This knowledge will put the full power of Excel right at their fingertips. At the end of this course, participants will know how to use Excel to do more for them so that they can focus on getting the answers needed from the vast amounts of data their organization generates.
This course is designed to familiarise existing users of Microsoft® Excel® in the building of dashboards that can be used to create compelling Excel reports. It provides participants with in-depth coverage of the necessary individual functions and tools. It will walk attendees through the most effective ways to present and report data as well as cover the fundamental knowledge and skills needed to create dashboards and interactive controls. Through this training, participants will go from reporting data with simple tables full of dull numbers to presenting key information using high-impact, meaningful reports and dashboards that will wow management both visually and substantively.
Advances in technology have made it possible to store ever increasing amounts of data. Along with this, the need to analyse that data and gain actionable insight is greater than ever. You already have experience working with Excel® and creating basic PivotTables to summarize data. But, Excel® is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyse, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance of success for everyone involved.
We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyse large amounts of data quickly. Fortunately, Excel® provides Power Pivot to help users organize, manipulate, and report on their data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analysing data.
This course will help participants learn about the advanced features of Microsoft® Excel® to attain proficiency as an Excel power user.
This course is designed to give experienced Excel® users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code whether in Microsoft® Office Excel® 2010, 2013 or 2016.
This course is intended for advanced professionals who need to automate spreadsheet tasks using Visual Basic for Applications (VBA) in Microsoft® Office Excel® 2010/2013/2016/2019.
You will use Microsoft® Outlook® to compose and send emails, schedule appointments and meetings, manage contact information, schedule tasks, and create notes.
You will customize the Microsoft® Outlook®environment, calendar, and mail messages, and will also track, share, assign, and quickly locate various Outlook items.
In this course, you will explore the Microsoft® Outlook® interface and when you are familiar with it, you will use Outlook to manage all aspects of email communications; use the Outlook calendar to manage appointments and meetings; use Outlook's People workspace to manage your contact information; create Tasks and Notes for yourself in Outlook; and customize the Outlook interface to serve your own personal needs.
In this course, participants will explore the advanced features provided with the Microsoft® Outlook® interface, such as advanced message, calendar, and contacts management. They will use the Tasks and Journal workspaces provided in the application to manage tasks assigned to them and others and to record interactions they will have with their colleagues. Lastly, participants will also share their workspaces with other users and use Outlook data files to save and back up their important information.
In this course, participants will learn to use Microsoft® Outlook®. They will learn the basic skills needed to start using Outlook to manage their e-mail communications, contact information, calendar events, tasks, and notes. It will also teach participants to customize the Outlook interface to suit their working style. This course is the first in a series of two Outlook courses.
In this course, participants will customize command sets, configure e-mail accounts, set global options, and perform advanced searches. They will also learn how to apply filters to intercept mail and control spam, create rules to automate many management tasks as well as work with calendars and contacts. Lastly, participants will manage tasks, protect data with archiving and data files, and share and delegate access to their workspaces. In short, participants will work with a wide range of features and options and, in so doing, understand why Microsoft® Outlook® is a leading personal management system.
In this course, participants will use Microsoft® Outlook® to send, receive, and manage e-mail messages. They will also learn to manage their contact information, schedule appointments and meetings, and create tasks and notes for themselves. Participants will also customize the Outlook interface to suit their working style. This course is the first in a series of two Outlook 2019 courses. It will provide participants with the basic skills needed to start using Outlook to manage their e-mail communications, contact information, calendar events, tasks, and notes.
In this course, participants will customize command sets, configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate mail management tasks, work with calendars and contacts, manage tasks, preserve data with archives and data files, as well as share and delegate access to their Outlook items. In short, participants will work with a wide range of features and options and, in so doing, understand why Outlook is a leading personal management system. This course builds upon the foundational knowledge presented in the Microsoft® Office Outlook® 2019: Part 1 course and will help participants customize a communication system well-suited to their work style.
In this course, participants will use Microsoft® Office Outlook® to send, receive, and manage e-mail messages. participants will also learn to manage their contact information, schedule appointments and meeting. Lastly, they will also learn to create tasks and notes for themselves and customize the Outlook interface to suit their working style.
In this course, participants will customize command sets, configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate mail management tasks, work with calendars and contacts, manage tasks, preserve data with archives and data files, as well as share and delegate access to their Outlook items. In short, they will work with a wide range of features and options and, in so doing, understand why Microsoft® Office Outlook® is a leading personal management system.
Participants will explore the Microsoft® PowerPoint® environment and create a presentation. They will format text on slides to enhance clarity. To enhance the visual appeal, participants will also add graphical objects to a presentation and modify them. Thirdly, they will also add tables and charts to a presentation to present data in a structured form. Then, participants will finalize a presentation to deliver it.
This course teaches participants how to enhance their presentations by using features that will transform it into a powerful means of communication. They will customize the Microsoft® PowerPoint® interface to suit their requirements and use features to create dynamic and visually appealing presentations. Participants will then finalize a presentation and secure it to authenticate its validity.
Today's audiences are tech-savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within Microsoft® PowerPoint® 2013, participants will gain the ability to organize their content, enhance it with high-impact visuals, and deliver it with a punch. In this course, participants will use PowerPoint 2013 to begin creating engaging, dynamic multimedia presentations.
Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all these variables, a robust set of tools such as Microsoft® PowerPoint® 2013 is needed. It provides the user with a variety of tools that can help them deliver content in nearly any situation while saving time and effort. In this course, participants will be shown how to take advantage of these tools to create interesting, informative, and memorable presentations that will deliver their content, on time, to all audiences, and to only those who need to see it.
When persons are asked to present important information so that the audience's focus is grabbed and maintained, Microsoft Office PowerPoint 2016 is the tool to use. Gone are the days of flip charts or drawing on a whiteboard to illustrate your point. Today's audiences are tech-savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within PowerPoint 2016, participants will gain the ability to organize their content, enhance it with high-impact visuals, and deliver it with a punch. In this course, participants will use PowerPoint 2016 to begin creating engaging, dynamic multimedia presentations.
Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all the variables, it may seem an overwhelming task to deliver your content, on time, to all audiences, and to only those who need to see it. Oh, and by the way, you need to make it interesting, informative, and memorable. So, how do you do it? By using Microsoft Office PowerPoint 2016 robust set of tools which can help you deliver content in nearly any situation while saving time and effort. By taking advantage of these tools, you will be creating presentations that not only stand out from the crowd but also don't consume all your available time.
Today's audiences are tech-savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within Microsoft® PowerPoint® 2019, participants will gain the ability to organize their content, enhance it with high-impact visuals, and deliver it with a punch. In this course, participants will use PowerPoint 2019 to begin creating engaging, dynamic multimedia presentations.
Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all these variables, a robust set of tools such as Microsoft® Office PowerPoint® 2019 is needed. It provides the user with a variety of tools that can help them deliver content in nearly any situation while saving time and effort. In this course, participants will be shown how to take advantage of these tools to create interesting, informative, and memorable presentations that will deliver their content, on time, to all audiences, and to only those who need to see it.
Today's audiences are tech-savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within Microsoft® Office PowerPoint® 2021, participants will gain the ability to organize their content, enhance it with high-impact visuals, and deliver it with a punch. In this course, participants will use PowerPoint to begin creating engaging, dynamic multimedia presentations.
Microsoft® PowerPoint® 2021 is needed. It provides the user with a variety of tools that can help them deliver content in any situation while saving time and effort. In this course, participants will be shown how to take advantage of these tools to create interesting, informative, and memorable presentations that will deliver their content, on time, to all audiences, and to only those who need to see it.
Microsoft® Office Publisher 2010 is a desktop publishing software program that comes with the Microsoft Office suite. While Microsoft Word is a word processing program, Microsoft Office Publisher is used for page layout and design. Participants can use Publisher to create brochures, flyers, menus, business cards, certificates, and any number of things that you want to design for either use on the computer or to print — personally or by a commercial printer. In this course, participants will create, format, edit, and distribute publications.
Microsoft® Office Publisher is a desktop publishing software application capable of producing greeting cards, certificates, newsletters, and other printed publications. Publisher offers a large selection of "building blocks" that can be dragged into your documents, helping you to create page elements such as calendars, newsletter sidebars, and borders. Publisher integrates mail merge features, which is handy when you need to send publications to a list of customers, and it's possible to export publications as HTML web pages or PDF documents. In this course, participants will create, format, edit, and distribute publications.
Microsoft® Office Publisher 2016 is a desktop publishing software application capable of producing greeting cards, certificates, newsletters, and other printed publications. The software includes a large collection of templates that provide a great way to start a new publication. It offers a large selection of "building blocks" that can be dragged into your documents, helping you to create page elements such as calendars, newsletter sidebars, and borders. Publisher integrates online sharing and mail merge features, which is handy when you need to send publications to a list of customers, and it's possible to export publications as HTML web pages or PDF documents. In this course, participants will create, format, edit, and distribute publications.
Microsoft® Office Publisher is a desktop publishing software application capable of producing greeting cards, certificates, newsletters, and other printed publications. Publisher includes a large collection of templates that provide a great way to start a new publication. Publisher offers a large selection of "building blocks" that can be dragged into your documents, helping you to create page elements such as calendars, newsletter sidebars, and borders. Publisher integrates online sharing and mail merge features, which are handy when you need to send publications to a list of customers, and it's possible to export publications as HTML web pages or PDF documents. With a user-friendly interface, Publisher makes it easy to create and edit publications.
This course is designed for students who wish to learn the basic operations of the Microsoft® Word to perform their day-to-day responsibilities, and who want to use the application to be more productive in their work. It provides the fundamental knowledge and techniques needed to advance to using more complex Word features such as protecting your documents and usage of ligatures.
This course is designed for persons who are able to create and modify standard business documents in Microsoft® Word 2010 but need to know how to create or modify complex business documents and customized Word efficiency tools. It also aims to assist persons preparing for the Microsoft Office Specialist exams for Microsoft Word 2010.
This course is designed for persons who want to gain skills necessary to manage lengthy documents, collaborate with others, and secure documents using Microsoft® Word 2010.
Microsoft® Word 2013 is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, participants will learn how to use Word 2013 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.
Microsoft® Word can be used to create complex documents that are nearly as complicated as those created using a desktop publishing application. Using Word, you can control how the text flows between paragraphs and pages, you can link a story on page one to the rest of the story later in the document, and you can add graphics and specify how the text and graphic appear together on the page.
Microsoft® Word 2013 enables participants to do more than simple word processing. It can be used to collaborate on complicated documents and manage how the documents are accessed and distributed. Advanced features of Word 2013 enable participants to revise, manage, and secure theirr business documents.
Microsoft® Word 2016 is designed to help persons move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, participants will learn how to use Word 2016 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.
After you master the basics of using Microsoft® Word 2016, you're ready to move on to tackling the more advanced features. These features enable persons to create complex and professional documents with a consistent look and feel. They also enable you to automate tedious tasks such as preparing a letter to send to every customer of your organization. This course will introduce participants to these advanced features as well as help them master the techniques for implementing them.
Microsoft® Word 2016 enables you to do far more than simple word processing. This includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production.
Microsoft® Word 2019 is designed to help persons move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make work easy, and even fun. In this course, participants will learn how to use Word 2019 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.
After the basics of creating, editing, and printing Microsoft® Word documents have been mastered, it is time to move on to tackling the more advanced features. In this course, participants will work with features such as formats, styles, and templates to create professional documents with a consistent look and feel. They will also add visual interest to their documents using the tables and charts features. Then, participants will learn about Quick Parts and templates to provide efficiency and consistency when adding content as well as learn how long complex documents can be simplified and managed in Master Documents. Finally, participants will use the mail merge feature to automate sending individual letters to customers. Participants should note that mastering these techniques will help make them a valued employee in your organization.
Microsoft® Word enables you to do far more than simple word processing. Word includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production.
In this course, participants will learn how to use Microsoft® Word 2021. They will learn to create and edit simple documents, format documents, add tables and lists, add design elements and layout options, and proof documents.
After the basics of creating, editing, and printing Microsoft® Word documents have been mastered, it is time to move on to tackling the more advanced features. In this course, participants will work with features such as formats, styles, and templates to create professional documents with a consistent look and feel. They will also learn to add visual interest to their documents by using the tables and charts features. Then, participants will learn about Quick Parts and templates to provide efficiency and consistency when adding content as well as learn how long complex documents can be simplified and managed in Master Documents. Finally, they will use the mail merge feature to automate sending individual letters to customers.
Microsoft® Word enables you to do far more than simple word processing. Word includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production. This course will teach participants image manipulation, collaboration, and revision tracking, cross-referencing, and linking, document security, forms, and process automation through macros.
Microsoft® OneDrive® for Business (formerly SkyDrive Pro) is an amazing cloud storage service that apart from storing, sharing, collaborating and syncing files, also allows users to create their own documents through Office Online. Office Online is the web-based version of some of the Microsoft Office suite of applications such as Word, Excel®, PowerPoint® and OneNote®. In this course, participants will learn how to use both the online web interface and the Desktop sync client. Participants will also learn how to store documents, pictures and other files safely and access them from any device connected to the Internet, including their phones and/or tablets.
In this fast-paced digital world, there is an ever-present need to capture ideas, meeting notes, and to-do items. This course provides a way for participants to efficiently create and collect their notes in an electronic notebook. It will introduce them to using Microsoft® OneNote® notebooks to store a wide variety of content in an organized structure, access the content from anywhere, and also share it with others.
In this course, participants will learn to use Microsoft® Outlook® for Office 365™. They will learn to send, receive, and manage email messages; manage their contact information; schedule appointments and meetings; create tasks and notes for themselves, and customize the Outlook interface to suit their working style.
In this course, participants will customize command sets, configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate mail management tasks, work with calendars and contacts, manage tasks, preserve data with archives and data files, as well as share and delegate access to their Outlook items. In short, participants will work with a wide range of features and options and, in so doing, understand why Microsoft® Outlook® for Office 365™ is a leading personal management system.
Data scientists, or any professional, use the creation of data-backed visualizations to explore, analyze, and report insights and trends from data. Microsoft® Power BI® software is designed for this purpose. Power BI was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Its data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. This course teaches attendees how to use Power BI to leverage (“big”) data effectively so that it provides timely insights and competitive advantage.
Data scientists, or any professional, use the creation of data-backed visualizations to explore, analyze, and report insights and trends from data. Microsoft® Power BI® software is designed for this purpose. Power BI was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Its data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. This course teaches attendees how to use Power BI to leverage (“big”) data effectively so that it provides timely insights and competitive advantage.
Today's audiences are tech-savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within Microsoft® PowerPoint® for Office 365™, participants will gain the ability to organize their content, enhance it with high-impact visuals, and deliver it with a punch. In this course, participants will use PowerPoint to begin creating engaging, dynamic multimedia presentations.
Microsoft® PowerPoint® for Office 365™ provides you with a variety of such tools that can help you deliver content in nearly any situation while saving time and effort. By taking advantage of these tools, participants will be creating presentations that not only stand out from the crowd but also do not consume all their available time.
Participants will create and manage a project schedule using Microsoft® Project 2010.
Participants will manage and customize project plans during the implementation stage of a project.
This course is designed to familiarise you with the basic features and functions of Microsoft® Project Professional 2013 so that you can use it effectively and efficiently in a real-world environment. It covers the critical knowledge and skills a project manager needs to create a project plan with Project 2013 during the planning phase of a project. In other words, if your supervisor assigns you to lead a project, this course will enable you to draft a project plan with Project 2013 and share it with your supervisor (and others) for review and approval.
This course is designed to familiarise you with the advanced features and functions of Microsoft® Project Professional 2013 so that you can use it effectively and efficiently in a real-world environment. It covers the advanced knowledge and skills a project manager needs to update a project plan in Project 2013 during the execution, monitoring, and controlling phases of a project. In other words, once your project plan is approved by the project sponsor, this course will enable you to manage the project so that it is completed on time, within budget, and according to scope. Each lesson in this course is built around the executing, monitoring, and controlling tasks that can be accomplished using the advanced commands found on one of these Project 2013 tabs: PROJECT, TASK, VIEW, or REPORT. This will enable you to become a "power user" and leverage the full potential of the application.
Welcome to Microsoft® Project 2016: Part 1. This course is designed to familiarize you with the basic features and functions of Microsoft Project Professional 2016 so you can use it effectively and efficiently in a real-world environment. This course covers the critical knowledge and skills a project manager needs to create a project plan with Project 2016 during the planning phase of a project. In other words, if your supervisor assigns you to lead a project, this course will enable you to draft a project plan with Project 2016 and share it with your supervisor (and others) for review and approval.
Welcome to Microsoft® Project 2016: Part 2. This course is designed to familiarize you with the advanced features and functions of Microsoft Project Professional 2016 so that you can use it effectively and efficiently in a real-world environment. In Microsoft Project 2016: Part 1, you learned the basic features of Microsoft Project 2016 during the planning phase of a project. Microsoft Project 2016: Part 2 covers the advanced knowledge and skills a project manager needs to update a project plan in Project 2016 during the execution, monitoring, and controlling phases of a project. In other words, once your project plan is approved by the project sponsor, this course will enable you to manage the project so that it is completed on time, within budget, and according to scope.
This course is designed to familiarize you with the basic features and functions of Microsoft Project so you can use it effectively and efficiently in a real-world environment. It covers the critical knowledge and skills a project manager needs to create a project plan Project during the planning phase of a project. In other words, if you are assigned to lead a project, this course will enable you to draft a project plan with Project and share it with your superior (and others) for review and approval. This course will give you the fundamental understanding of Microsoft Project necessary to construct basic project plans.
This course is designed to familiarize you with some of the advanced features and functions of Microsoft Project so you can use it effectively and efficiently in a real-world environment. In Microsoft® Project® 2019 (On-Premise or Online Editions): Part 1, you learned the basic features of Microsoft Project during the planning phase of a project. This course covers the advanced knowledge and skills a project manager needs to update a project plan Project during the execution, monitoring, and controlling phases of a project. In other words, once your project plan is approved by the project sponsor, this course will enable you to manage the project so that it is completed on time, within budget, and according to scope.
This course is designed to familiarize participants with the basic features and functions of Microsoft® Project so they can use it effectively and efficiently in a real-world environment. The course covers the critical knowledge and skills a project manager needs to create a project plan with Project during the planning phase of a project. In other words, this course will enable participants to draft a project plan with Project and share it with their supervisor (and others) for review and approval, if they are assigned to lead a project.
This course covers the advanced knowledge and skills a project manager needs to update a project plan in Microsoft® Project during the execution, monitoring, and controlling phases of a project. In other words, once the project plan is approved by the project sponsor, this course will enable participants to manage the project so that it is completed on time, within budget, and according to scope.
Microsoft® Publisher for Office 365™ is a desktop publishing software application capable of producing greeting cards, certificates, newsletters, and other printed publications. Publisher includes a large collection of templates that provide a great way to start a new publication. Publisher offers a large selection of "building blocks" that can be dragged into your documents, helping you to create page elements such as calendars, newsletter sidebars, and borders. Publisher integrates online sharing and mail merge features, which are handy when you need to send publications to a list of customers, and it's possible to export publications as HTML web pages or PDF documents. With a user-friendly interface, Publisher makes it easy to create and edit publications.
In this course, participants will learn how to create, configure, and manage a Microsoft® SharePoint® site so that their team or organization can collaborate effectively, manage the flow of digital information, meet governance and compliance needs, and create rich websites for their organization's needs.
In this course, participants will learn how to create, configure, and manage Microsoft® SharePoint®sites so that their team or organization can share information and collaborate effectively.
In this course, participants will learn about and use Microsoft® SharePoint®to access, store, share, and collaborate with information and documents.
This course is designed to help participants master Microsoft® Teams®, the key communications tool in the suite of Microsoft 365® productivity apps. Participants will learn to use Teams to have a quick chat with a colleague or individual, participate in a virtual meeting, make an online call, share files and resources, and collaborate with persons. They will learn how to use the Microsoft Teams app across the three versions: desktop, web, and or mobile app. On completion of this course, participants will be able to easily work in any version of the software and be able to take advantage of connecting through Teams wherever their work takes them.
Attendees will learn how to design and manage basic diagrams, workflow, and flowcharts.
Attendees will learn how to create custom elements and a custom template, represent external data as a drawing, and share their work with others.
In today’s workplace, visual diagrams are an essential part of communication, from road maps to sales flows to process charts. Microsoft® Visio® provides you with an intuitive, customizable tool to easily create a professional-looking visual product by using its extensive gallery of shapes. By following the exercises in this course, participants will create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend.
Microsoft® Visio® stands out among similar applications because of its unique ability to draw a wide variety of diagrams, flowcharts, workflows, and organization structures—anything that can be represented by shapes connected by lines. Most importantly, these shapes can be rearranged with corresponding lines remaining intact. Microsoft® Visio® has improved over the years as features common to Microsoft® Office applications have been added. Today, Microsoft® Visio® is well integrated with other members of the Office family as well as Microsoft's cloud-based services. This greatly enriches the sharing and publishing of Visio® drawings. In this course, participants will learn about more advanced features—making them a more efficient and effective Visio® user.
In today’s workplace, visual diagrams are an essential part of communication, from road maps to sales flows to process charts. Microsoft® Visio® provides you with an intuitive, customizable tool that easily creates professional-looking visual products by using its extensive gallery of shapes. By following the exercises in this course, participants will create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend.
Microsoft® Visio® stands out among similar applications because of its unique ability to draw a wide variety of diagrams, flowcharts, workflows, and organization structures—anything that can be represented by shapes connected by lines. Most importantly, these shapes can be rearranged and the corresponding lines remain intact. Microsoft Visio is well integrated with other members of the Office family as well as Microsoft's cloud-based services. This greatly enriches the sharing and publishing of Visio drawings. In this course, participants will learn about more advanced features—making participants more efficient and effective Visio users.
In today’s workplace, visual diagrams are an essential part of communication, from road maps to sales flows to process charts. Microsoft® Visio® provides you with an intuitive, customizable tool to easily create a professional-looking visual product by using its extensive gallery of shapes. In this course, participants will create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend.
Microsoft® Visio® stands out among similar applications because of its unique ability to draw a wide variety of diagrams, flowcharts, workflows, and organization structures—anything that can be represented by shapes connected by lines. In this course, participants will learn about more advanced features—making them more efficient and effective Visio users. They will learn to create complex graphics and illustrations such as floor plans, custom maps, and scientific illustrations. They will also learn to link these illustrations to external data sources and insert them into other Microsoft Office files.
Microsoft® Word for Office 365™ is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, participants will learn how to use Word on the desktop to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.
After you master the basics of using Microsoft® Word for Office 365™ such as creating, editing, and saving documents; navigating through a document; and printing, you're ready to move on to tackling the more advanced features. These features enable you to create complex and professional documents with a consistent look and feel. They also enable you to automate tedious tasks such as preparing a letter to send to every customer of your organization. Creating professional-looking documents can help you give your organization a competitive edge. Implementing time-saving features such as document templates and automated mailings helps your organization reduce expenses. Mastering these techniques will make you a valued employee in your organization.
This course will focus on managing the database and supporting complex database designs. Participants will learn to import and export data, use action queries to manage data, create complex forms and reports, macros and VBA, and tools and strategies to manage, distribute, and secure a database. NOTE: Knowledge of these features separates database professionals from casual database users or occasional designers
Microsoft® Word for Office 365™ enables participants to do far more than simple word processing. Being able to manipulate graphics and efficiently create, manage, revise, and distribute long documents and forms can help your organization create important and interesting documents. Implementing time-saving features that enable you to work well in a collaborative mode will benefit both you and your organization. Constructing document elements that ensure your readers have access to pertinent information at the click of a button, while at the same time protecting sensitive information, is another important skill. Mastering these skills and techniques will make you a valued employee in your organization
This course focuses on skills required to set up an Office 365® tenant, including federation with existing user identities, and skills required to sustain an Office 365 tenant and its users.
The business climate has changed. People want to communicate without collaborative barriers. Businesses want solutions that are both cost-effective and flexible. Organizations start to configure hybrid environments and migrate content to the cloud as the solution. In this course, participants will learn how to deploy and configure the SharePoint® Server 2019, designed to meet the demands of modern workstyles. They will also learn how to configure and manage various SharePoint service applications to prepare for a hybrid deployment. Then, participants will learn how to plan and implement SharePoint hybrid scenarios that provide seamless users’ experience. Eventually, they will learn how to design the content migration process and available resources and tools to use while migrating content to SharePoint and OneDrive® in Microsoft® 365.
This course covers the three central elements of Microsoft® 365 enterprise administration – Microsoft 365 Tenant and Service Management, Office 365® Management and Microsoft 365 Identity Management.
In this course, participants will learn about Office 365® Management, which includes topics such as the key components of Office 365, how to move your organization to Office 365, how to configure Office 365, and how to manage Office 365 ProPlus deployments.
In this course, participants will learn about Microsoft® 365 Tenant and Service Management, which includes topics such as how to plan, manage, and customize your organization’s Microsoft 365 tenant and services.
In this course, participants will learn about the Microsoft® 365 Identity Management, which includes topics such as how to manage user security groups and licenses for cloud identities, and how to plan and implement identity synchronization, federated identities, applications, and external access.
This course covers three central elements of Microsoft® 365 enterprise administration – Microsoft 365 security management, Microsoft 365 compliance management, and Microsoft 365 device management. Participants will learn about Microsoft 365 Security Management, which includes topics such as how to manage security metrics, how to enable Azure® AD Identity Protection, how to configure Microsoft 365 security services and user Microsoft 365 Threat Intelligence. They will then learn about Microsoft 365 Compliance Management, which includes topics such as data retention and data loss prevention solutions in Microsoft 365, archiving and retention in Microsoft 365, implementing and managing data governance, and managing search and investigations. Lastly, this course will conclude with introducing participants to the world of Microsoft 365 device management – from establishing Microsoft Intune to enrolling devices to Intune, monitoring the devices, and controlling what users can do from the enrolled devices by using conditional access policies.
In this course, participants will learn about Microsoft® 365 Security Management, which includes topics such as how to manage security metrics, how to enable Azure® AD Identity Protection, how to configure Microsoft 365 security services and user Microsoft 365 Threat Intelligence.
In this course, participants will learn about Microsoft® 365 Compliance Management, which includes topics such as data retention and data loss prevention solutions in Microsoft 365, archiving and retention in Microsoft 365, implementing and managing data governance, and managing search and investigations.
This course introduces participants to the world of Microsoft® 365 device management – from establishing Microsoft Intune to enrolling devices to Intune, to monitoring the devices, to controlling what users can do from the enrolled devices by using conditional access policies. If candidates are already managing devices by using a traditional device management tool such as Configuration Manager, they will be interested to know how you can seamlessly move to modern management, in which devices are managed by Intune, and how they can benefit from new device management capabilities, such as compliance, conditional access, and Windows® Autopilot to deploy new devices from the cloud.
In this course, participants will learn about the architecture of the modern messaging infrastructure with Microsoft® Exchange Server and Exchange Online and how to deploy messaging in different scenarios and organizations. They will be guided through the initial deployment process and introduced to the messaging management tools. They will also learn how to create and manage different types of recipients, and how to create and manage Exchange Server mailbox databases, which serve as storage locations for all messaging data. Finally, participants will be introduced to messaging infrastructure organizational settings, such as how to manage authentication for your messaging environment, how to configure quotas for users in the organization, and how to configure organization sharing with the federation.
In this course, participants will learn how Microsoft® Exchange Server provides access to user mailboxes for many different clients. As all messaging clients access Exchange Server mailboxes through client access services, they will also examine how to plan, configure, and manage client access services in Exchange Server. Secondly, participants will also learn how to manage mobile devices. This course also describes the planning and configuring message transport in an Exchange Server organization. Thirdly, they will learn how to plan, configure and manage transport services to provide efficient communication between Exchange Servers, Exchange Online, and other mail servers on the Internet. Finally, they will also learn how to troubleshoot transport services when issues occur in different scenarios so that they can provide their organization with a healthy and reliable messaging infrastructure.
In this course, participants will learn about the traditional and modern solutions for messaging high availability and disaster recovery. They will be introduced to each solution and learn when to use one solution over another. They will also learn how to plan deployment, and how to perform the actual implementation.
This course introduces participants to the world of hybrid messaging. They will learn how to deploy a hybrid environment for their Exchange organization and how to migrate mailboxes to Microsoft® Exchange Online. Candidates will begin by examining available mailbox migration options and then focus on planning for a hybrid deployment. Finally, they will also learn how to implement and troubleshoot a hybrid deployment.
In this course, participants will learn about the different messaging-related security and compliance service configurations and settings with Microsoft® Exchange Server and Exchange Online. They will begin by examining the fundamentals of message hygiene with Exchange Online Protection and Exchange Advanced Threat Protection, as well as connection and spam filtering with Exchange. They will then examine messaging compliance solutions, such as retention and data loss prevention policies, as well as audit log investigations and eDiscovery search mechanisms from the messaging compliance perspective. Then they will learn how to plan a proper deployment and how to perform the basic implementation process for each solution. Finally, participants will conclude the course by examining how to manage permissions that are assigned to user and admin roles.
This course teaches participants how to solve a broad range of problems that can arise in organizations using Microsoft Exchange® Online. In this course, participants will troubleshoot many aspects of Microsoft Exchange Online, including mail flow, compliance, recipient problems, and cloud/on-premises hybrid configurations.
In this course, participants will learn to implement, manage, and monitor security and compliance solutions for Microsoft® 365 and hybrid environments. This course will teach participants to secure Microsoft 365 enterprise environments, respond to threats, perform investigations, and enforce data governance. This course will also teach participants to plan and implement security strategies that comply with their organization’s policies and regulations. Lastly, participants will become familiar with Microsoft 365 workloads and gain skills and experience in identity protection, information protection, threat protection, security management, and data governance.
Help protect against credential compromise with identity and access management. In this course, participants will learn how to secure user access to their organization’s resources. Specifically, this course covers user password protection, multi-factor authentication, how to enable Azure® Identity Protection, how to configure Active Directory® (AD) federation services, how to set up and use Azure AD Connect, and introduces them to Conditional Access. Participants will also learn about solutions for managing external access to their Microsoft 365® system.
Information protection is the concept of locating and classifying data anywhere it lives. In this course, participants will learn about information protection technologies that help secure their Microsoft 365® environment. Specifically, this course discusses information rights-managed content, message encryption, as well as labels, policies and rules that support data loss prevention and information protection. Lastly, the course explains the deployment of Microsoft® Cloud App Security.
Internal policies and external requirements for data retention and investigation may be necessary for your organization. In this course, participants will learn about archiving and retention in Microsoft 365® as well as data governance and how to conduct content searches and investigations. Specifically, this course covers data retention policies and tags, in-place records management for SharePoint, email retention, and how to conduct content searches that support eDiscovery investigations. The course also helps participants and their organization prepare for Global Data Protection Regulation (GDPR).
This course teaches participants to design, build, test, and maintain applications and solutions that are optimized for the productivity and collaboration needs of organizations using the Microsoft® 365 platform. This course also helps participants become proficient in Microsoft identity and Microsoft Graph. Participants will also gain valuable insight into UI elements (including Adaptive Cards and UI Fabric), integration points (including Microsoft Teams, Office Add-ins, SharePoint Framework, Actionable Messages), and determining workload platform targets.
In this course, participants will get an overview of Microsoft® Teams including Teams architecture and related Office 365® workloads. They will learn how to use Teams to facilitate teamwork and communication within their organization, both on and off-premises, on a wide range of devices — from desktops to tablets to phones — while taking advantage of all the rich functionality of Office 365 applications. They will plan and configure governance for Office 365 groups, implement security by configuring conditional access and implement compliance for Teams by using the necessary policies. They will also plan an upgrade from Skype® for Business to Microsoft Teams and learn how to create and manage teams as well as manage chat and collaboration experiences. This course concludes with managing communication in Microsoft Teams.
This course provides foundational knowledge on the considerations and benefits of adopting cloud services and the Software as a Service (SaaS) cloud model, with a specific focus on Microsoft® 365 cloud service offerings. Participants will begin by learning about cloud fundamentals, including an overview of cloud computing and specifically Microsoft cloud services. They will be introduced to Microsoft Azure®, and they will examine the differences between Microsoft 365 and Office 365. Then they will perform an in-depth review of Microsoft 365, including a comparison of Microsoft on-premises services versus Microsoft 365 cloud services, a review of enterprise mobility in Microsoft 365, and an analysis of how Microsoft 365 services provide collaboration. The course then analyzes how security, compliance, privacy, and trust are handled in Microsoft 365, and it concludes with a review of Microsoft 365 subscriptions, licenses, billing, and support.
This course will discuss the various methods and best practices that are in line with business and technical requirements for modelling, visualizing, and analysing data with Microsoft® 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. Lastly, the course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.
In this course, participants will learn about the business value and product capabilities of the Power Platform. They will create a simple PowerApp, connect data with Common Data Service (CDS), build a Power BI® Dashboard, and automate a process with Microsoft® Flow.
VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft® Excel® and other applications in the Microsoft Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give participants a good foundation for understanding, creating, and using VBA in their own Excel workbooks. It will also show them how to work with data across different applications, and how to package the macros and functions they create so they can be backed up, move them to other computers, and share them with other users.
This course prepares participants to have a background in designing and evaluating cybersecurity strategies in the following areas of Zero Trust, Governance Risk Compliance (GRC), security operations (SecOps), and data and applications. Participants will also learn how to design and build solutions using zero trust principles and specify security requirements for cloud infrastructure in different service models (SaaS, PaaS, IaaS).
In this course, participants will learn how to investigate, respond to, and hunt for threats using Microsoft Azure Sentinel, Azure Defender, and Microsoft 365 Defender. They will learn how to mitigate cyber threats using these technologies. Specifically, participants will configure and use Azure Sentinel as well as utilize Kusto Query Language (KQL) to perform detection, analysis, and reporting.
This course will equip participants with the knowledge and skills needed to implement identity management solutions based on Microsoft Azure AD, and its connected identity technologies. This course includes identity content for Azure AD, enterprise application registration, conditional access, identity governance, and other identity tools.
In this course, participants will learn how to protect the information in their Microsoft 365 deployment. This course focuses on data governance and information protection within an organization. The course covers the implementation of data loss prevention policies, sensitive information types, sensitivity labels, data retention policies and Office 365 message encryption among other related topics.
This course is for participants looking to familiarize themselves with the fundamentals of security, compliance, and identity (SCI) across cloud-based and related Microsoft services.
This course covers everything participants need to progress from simply knowing basic SQL to telling stories and identifying trends in data. Participants will be able to start exploring their data by identifying patterns and unlocking deeper insights. They will also gain experience working with different types of data in SQL, including time-series, geospatial, and text data. Finally, they will understand how to become productive with SQL with the help of profiling and automation to gain insights faster. By the end of the course, participants will be able to use SQL in everyday business scenarios efficiently and look at data with the critical eye of analytics professional.
You already know how to get Excel® to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But, Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you. And that's exactly what this course aims to help you do.
VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft® Excel® and other applications in the Microsoft Office application suite. This course will give participants a good foundation for understanding, creating, and using VBA in their own Excel workbooks. Participants will learn how to use the macro recorder effectively, as well as how to write their own VBA code from scratch. They will use the tools built into Excel to explore and learn VBA's capabilities and to optimize and debug their code.
This course is designed for professionals who will be responsible for managing identity, networking, storage and compute by using Windows Server® 2019, and who need to understand the scenarios, requirements, and options that are available and applicable to Windows Server 2019. The course teaches participants the fundamental administration skills required to deploy and support Windows Server 2019 in most organizations.
This course prepares participants for planning, implementing, and managing environments that include Azure® IaaS-hosted Windows Server-based workloads. The course covers how to leverage the hybrid capabilities of Azure, how to migrate virtual and physical server workloads to Azure IaaS, and how to manage and secure Azure VMs running Windows Server® 2019.
This advanced course is to cover advanced topics related to Windows Server® software-defined datacentre, Azure® Stack HCI, and other Azure Stack products. The course also describes the use of existing Microsoft® System Centre products to implement and manage software-defined datacentres with Windows Server 2019.
This course teaches IT Professionals how to migrate existing on-premises workloads and assets to the cloud, specifically to the Microsoft® Azure® platform. Participants will learn how to assess and evaluate an existing on-premises environment in preparation for cloud migration. They will also learn how to monitor and optimize their Azure-based workloads to maximize return on investment (ROI) and use Azure services to protect and manage your virtual machines, applications, and data.