Programming and Data Wrangling with VBA and Excel

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 you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users

Course Details

Price:

$885.00

Days:

Location:

Virtual

Course Overview

In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users

To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365™ (Desktop or Online) courses, Parts 1, 2, and 3

1 – Azure Virtual Desktop Architecture

Azure Virtual Desktop for the enterprise
Azure Virtual Desktop components
Personal and pooled desktops
Service updates for Azure Virtual Desktop desktops
Azure limitations for Azure Virtual Desktop
Virtual machine sizing for Azure Virtual Desktop
Azure Virtual Desktop pricing
Module assessment

2 – Design the Azure Virtual Desktop architecture

Assess network capacity and speed requirements for Azure Virtual Desktop
Azure Virtual Desktop Experience Estimator
Recommend an operating system for an Azure Virtual Desktop implementation
Balancing host pools
Recommendations for using subscriptions and management groups
Configure a location for the Azure Virtual Desktop metadata
Recommend a configuration for performance requirements
Module assessment

3 – Design for user identities and profiles

Select an appropriate licensing model for Azure Virtual Desktop based on requirements
Personal and multi-session desktop scenarios
Recommend an appropriate storage solution
Plan for a desktop client deployment
Plan for Azure Virtual Desktop client deployment – Remote Desktop Protocol (RDP)
Windows Desktop client to multiple devices
Hybrid Identity with Microsoft Entra ID
Plan for Microsoft Entra Connect for user identities
Module assessment

4 – Implement and manage networking for Azure Virtual Desktop

Plan implement remote desktop protocol shortpath
Analyze connection quality in Azure Virtual Desktop
Remote Desktop Protocol (RDP) bandwidth requirements
RDP Shortpath for Azure Virtual Desktop
RDP Shortpath for Azure Virtual Desktop sample scenarios
Manage connectivity internet premises Networks
Plan and implement an Azure Private Link solution for Azure Virtual Desktop
Create an RDP connection to a Windows VM using Azure Bastion
Monitor troubleshoot Network Watcher
Module assessment

5 – Implement and manage storage for Azure Virtual Desktop

Plan storage for Azure Virtual Desktop user data
Azure storage management
Azure Files tiers
Azure NetApp Files tiers
Implement storage accounts for Azure Virtual Desktop
Module assessment

6 – Create and configure host pools and session hosts for Azure Virtual Desktop

Prerequisites for Azure Virtual Desktop
Operating systems and Azure regions
Network and Remote Desktop client planning
Create a host pool
Create a host pool using the Azure portal
Add session hosts to a host pool
Customize Remote Desktop Protocol (RDP) properties for a host pool
Module assessment

7 – Create and manage session host image for Azure Virtual Desktop

Create a golden image in Azure
Using Azure VM Image Builder
Create an Azure Virtual Desktop image by using VM Image Builder and PowerShell
Plan for image update and management
Manage licensing for session hosts that run Windows client
Install language packs in Azure Virtual Desktop
Module assessment

8 – Manage access for Azure Virtual Desktop

Selecting an identity strategy for Azure Virtual Desktop
Selecting an authentication strategy for Azure Virtual Desktop
Role-based access control (RBAC) for Azure Virtual Desktop
Plan and implement Azure roles and role-based access control (RBAC) for Azure Virtual Desktop
Assign RBAC roles to the Azure Virtual Desktop service principals
Enforce Microsoft Entra multifactor authentication for Azure Virtual Desktop using Conditional Access
Using Azure Virtual Desktop with Microsoft Intune
Module assessment

9 – Manage security for Azure Virtual Desktop

Security recommendations for Azure Virtual Desktop
Connect your Azure subscriptions to Microsoft Defender for Cloud
Microsoft Defender for Endpoint for Azure Virtual Desktop sessions
Apply Zero Trust principles to an Azure Virtual Desktop deployment
Plan and implement Conditional Access policies for connections to Azure Virtual Desktop
Security posture management and threat protection
Module assessment

10 – Implement and manage FSLogix

Overview of FSLogix
Understand FSLogix containers
Configure FSLogix Profile Containers
Configure FSLogix Office Containers
Configure profile containers with Cloud Cache
Using FSLogix Apps RuleEditor and Rule Sets
Create and Implementing Rule Sets for Application Masking
Implement Azure NetApp Files for Azure Virtual Desktop
Module assessment

11 – Configure user experience settings

Connect to Azure Virtual Desktop with the Remote Desktop client for Windows
Configure session timeout properties
Implement the Start Virtual Machine on Connect feature
Configure Universal Print
Configure device redirections
Troubleshoot Azure Virtual Desktop clients
Module assessment

12 – Install and configure apps on a session host

Create and configure an application group
Assign users to application groups
Publish an application as a RemoteApp
Implement and manage OneDrive, including multisession environments
Implement and manage Microsoft Teams for Remote Desktop
Implement and manage Microsoft 365 Apps on Azure Virtual Desktop session hosts
Configure dynamic application delivery by using app attach or MSIX app attach
Create an application package for app attach or MSIX app attach
Module assessment

13 – Monitor and manage performance and health

Configure log collection and analysis for Azure Virtual Desktop session hosts
Monitor Azure Virtual Desktop by using Azure Monitor
Customize Azure Monitor workbooks for Azure Virtual Desktop Insights
Monitor Azure Virtual Desktop by using Azure Advisor
Implement scaling plans in host pools
Optimize capacity and performance
Module assessment

14 – Plan and implement updates, backups, and disaster recovery

Disaster recovery for Azure Virtual Desktop
Design and implement a backup strategy for Azure Virtual Desktop
Monitor costs by using Azure Cost Management
Module assessment

Class Dates & Times


01/13/2026 - 01/15/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $885.00
04/15/2026 - 04/17/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $885.00
07/14/2026 - 07/16/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $885.00

— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.

Student? Switch to our Career Center Site →