Microsoft Access

Microsoft Access VBA Training

In this Microsoft Access VBA Training course, students will learn how to use the VBA (Visual Basic for Applications) programming language to automate their database applications. They will learn about creating Sub Procedures and Functions and see how to call these blocks of code from an event occurring in Microsoft Access, such as a button being clicked or a user saving a record. Students will be introduced...

Course Length: 2 Days Available Formats: Private Group Training Live, Instructor-Led Online Training

azure

Microsoft Azure Administrator (AZ-104T00)

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

Course Length: 4 Days Available Formats: Private Group Training Live, Instructor-Led Online Training

azure

Microsoft Azure Data Fundamentals (DP-900T00)

In this Microsoft Azure Data Fundamentals Training course, students will gain foundational knowledge of core data concepts and related Microsoft Azure data services. Students will learn about core data concepts such as relational, non-relational, big data, and analytics, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will explore fundamental relational data concepts and relational database services in Azure. They will explore Azure...

Course Length: 1 Day Available Formats: Private Group Training Live, Instructor-Led Online Training

azure

Microsoft Azure Fundamentals (AZ-900T00)

This Microsoft Azure Fundamentals (AZ-900T00) course is designed for IT personnel who are just beginning to work with Azure. Students will the fundamental concepts core to Azure including tools for Azure management and governance.

Course Length: 1 Day Available Formats: Private Group Training Live, Instructor-Led Online Training

azure

Microsoft Azure Security Technologies (AZ-500T00)

This Microsoft Azure Security Technologies Training course provides IT Security Professionals with the knowledge and skills needed to implement security controls, maintain an organization’s security posture, and identify and remediate security vulnerabilities. This course includes security for identity and access, platform protection, data and applications, and security operations.

Course Length: 4 Days Available Formats: Private Group Training Live, Instructor-Led Online Training

excel

Microsoft Excel Advanced Training

In this Microsoft Excel Advanced training course, students will learn how to use features in Excel to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply complex formulas and functions. Students will see how to create Links and External References to Worksheets and Workbooks, use Lookup functions like VLOOKUP and HLOOKUP, and watch and evaluate formulas to find and fix...

Course Length: 1 Day Available Formats: Private Group Training Live, Instructor-Led Online Training

excel

Microsoft Excel Dashboards Training

In this one-day Microsoft Excel Dashboards training class, students will learn how to create dashboards in Microsoft Excel to enable actionable insights from data. Students will see how to use tables with sorting and filtering to select data, how to create charts and implement best practices for chart design in Excel, how to use formulas, functions and perform data validation on their data and use PivotTables and...

Course Length: 1 Day Available Formats: Private Group Training Live, Instructor-Led Online Training

excel

Microsoft Excel Intermediate Training

In this Microsoft Excel Intermediate Training class, students will learn how to build on their Excel skills by using named ranges in Excel, inserting Excel Functions such as IF and SUMIF, using comparison operators such as AND, OR and NOT and using Date Functions such as DATE and NOW. In addition, students will see how to manipulate text using Text Functions like UPPER, LOWER and CONCATENATE. Students...

Course Length: 1 Day Available Formats: Private Group Training Live, Instructor-Led Online Training

excel

Microsoft Excel Introduction Training

In this Microsoft Excel Introduction Training course, students will learn how to create worksheets in Microsoft Excel, how to use formulas and perform calculations, how to format cells and worksheets, how to setup worksheets for printing and how to export data from Excel to various other formats, including PDF. This course assumes no prior experience with Excel and is a great starting point for those who are...

Course Length: 1 Day Available Formats: Private Group Training Live, Instructor-Led Online Training

excel

Microsoft Excel VBA Training

In this Microsoft Excel VBA Training course, students will learn to use VBA in Excel to create interactive worksheets and automate common worksheet tasks. Students will see how to generate VBA code from existing macros, gain an understanding of the different parts of the Visual Basic Editor, learn how code is organized in Projects, Modules and Procedures and become familiar using Objects, Properties and Methods in their...

Course Length: 2 Days Available Formats: Private Group Training Live, Instructor-Led Online Training