Microsoft
Programming and Data Wrangling with VBA and Excel
Programming and Data Wrangling with VBA and Excel — Microsoft training aligned to Microsoft skills and certification paths.
LevelAssociate
Duration3 days
ModesIn Person,Virtual
CategoryMicrosoft 365
About this course
This Microsoft course from TORQUE IT prepares learners for real-world microsoft scenarios.
Programme focus: Programming and Data Wrangling with VBA and Excel.
Catalogue path: Microsoft.
Skills developed: End User.
Available delivery locations include Cape Town, Johannesburg, MHD Cape Town, MHD Woodmead, Virtual.
Delivered by accredited instructors with hands-on labs, practical exercises and post-course support.
What you'll learn
- End User
- Programming
- Data Wrangling
- Excel
- Microsoft fundamentals
- Practical labs and exercises
- Best practices and exam preparation
Microsoft 365 learning path
82 courses across 4 vendors in Microsoft 365.
Microsoft 365 learning path
- Build a Foundation to Build AI Agents and Extend Microsoft 365 Copilot
- Copilot Immersion Experience
- Introduction to Finance in Dynamics 365
- Introduction to Microsoft 365 and AI Administration
- Introduction to Microsoft Power Platform
- Introduction to Sales in Dynamics 365
- Introduction to Service in Dynamics 365
- Introduction to Supply Chain Management in Dynamics 365
- Microsoft Office 365 Introduction
- Microsoft Sway Introduction
- Microsoft Windows 10 Introduction
- Accelerate Sales Pipelines with AI in Dynamics 365
- Architecting Aagentic AI Business Solutions
- Build Intelligent Applications
- Collaboration Communications Systems Engineer
- Configure and Govern Entitlement with Microsoft Entra ID
- Configure SIEM Security Operations using Microsoft Sentinel
- Create And Extend Custom Copilots in Microsoft Copilot Studio
- Create and Manage Automated Processes by using Power Automate
- Create and Manage Canvas Apps with Power Apps
- Data Analysis and Visualization with MS Excel
- Design and Build Integrated AI Agent Solutions in Copilot Studio
- Design and Manage Analytics Solutions using Power BI
- Draft, Analyze, and Present with Microsoft 365 Co-Pilot
- Empower your workforce with Copilot for Microsoft 365 Use Cases
- Enhance Endpoint Security with Microsoft Intune and Microsoft Copilot for Security
- Get started with Microsoft Copilot for Security
- Getting the Most from Your Documents with GenAI
- Getting the Most from your Presentations with GenAI
- Getting the Most from Your Spreadsheets with GenAI
- GitHub Copilot
- Implement Information Protection and Data Loss Prevention by using Microsoft Purview
- Implement Retention, eDiscovery, and Communication Compliance in Microsoft Purview
- Information Security Administrator
- Manage and Extend Microsoft 365 Copilot
- Managing Microsoft Teams
- Microsoft 365 Administrator
- Microsoft 365 Endpoint Administrator
- Microsoft 365 Security Administration
- Microsoft Access for Office 365: Part 1
- Microsoft Access for Office 365: Part 2
- Microsoft Access for Office 365: Part 3
- Microsoft Excel for Office 365 – Data Analysis with PivotTables
- Microsoft Excel for Office 365 (Desktop or Online): Part 1
- Microsoft Excel for Office 365 (Desktop or Online): Part 2
- Microsoft Excel for Office 365 (Desktop or Online): Part 3
- Microsoft Excel for Office 365/2021 – Data Analysis with Power Pivot
- Microsoft Identity and Access Administrator
- Microsoft Outlook for Office 365 (Desktop or Online): Part 1
- Microsoft Outlook for Office 365 (Desktop or Online): Part 2
- Microsoft Power Automate RPA Developer
- Microsoft Power BI: Data Analysis Practitioner
- Microsoft Power Platform Developer
- Microsoft PowerPoint for Office 365 (Desktop or Online): Part 1
- Microsoft PowerPoint for Office 365 (Desktop or Online): Part 2
- Microsoft Project 2019
- Microsoft Publisher for Office 365/2021
- Microsoft Security Compliance and Identity Fundamentals
- Microsoft Security Operations Analyst
- Microsoft Teams (Desktop and Browser)
- Microsoft Windows 10 Intermediate
- Microsoft Word for Office 365 (Desktop or Online): Part 1
- Microsoft Word for Office 365 (Desktop or Online): Part 2
- Microsoft Word for Office 365 (Desktop or Online): Part 3
- Power Platform Functional Consultant
- Prepare Security and Compliance to Support Microsoft 365 Copilot
- Programming and Data Wrangling with VBA and Excel You are here
- Secure and Govern your AI Agent Workforce
- Secure Azure Services and Workloads with Microsoft Defender for Cloud Regulatory Compliance Controls
- Transform Contact Center Experiences with AI in Dynamics 365
- Transform your Everyday Business Processes with Agents
- Using Microsoft Windows 11
- Using Microsoft Windows 11 (with Copilot)
- Work Smarter with Copilot in Microsoft Fabric
- Working with Copilot in Windows and Microsoft Edge
Course content
| Module | What's covered |
|---|---|
| Module 1: End User | Explore end user within the context of Programming and Data Wrangling with VBA and Excel. |
| Module 2: Programming | Explore programming within the context of Programming and Data Wrangling with VBA and Excel. |
| Module 3: Data Wrangling | Explore data wrangling within the context of Programming and Data Wrangling with VBA and Excel. |
| Module 4: Excel | Explore excel within the context of Programming and Data Wrangling with VBA and Excel. |
| Module 5: Microsoft fundamentals | Explore microsoft fundamentals within the context of Programming and Data Wrangling with VBA and Excel. |
| Module 6: Practical labs and exercises | Explore practical labs and exercises within the context of Programming and Data Wrangling with VBA and Excel. |
| Module 7: Best practices and exam preparation | Explore best practices and exam preparation within the context of Programming and Data Wrangling with VBA and Excel. |
Certification
On successful completion of this course students receive a TORQUE IT attendance certificate.
Certification exams may be booked separately through the relevant vendor or Pearson VUE testing centres.
Course dates
—
MonTueWedThuFriSatSun
Date with a session
Related courses