In this course, you will learn the skills to enable you to use the Visual Basic for Applications (VBA) programming language to simplify or automate activities and tasks using Microsoft Office applications. The course covers examples in; Excel 2016 – 2019, Word 2016 – 2019, Outlook 2016 – 2019, PowerPoint 2016 – 2019
Please Note: Microsoft Excel 2016 is used as the primary application during the course for demonstration purposes.
Delegates looking to gain enhanced skills to apply VBA to develop macros to work with Office applications. You will work with the application object models, manipulate data across applications and manage files and folders using VBA.
A dual monitor setup is required when attending this course via the QA Attend from Anywhere delivery method.
Module 1: VBA overview
Objects, Dimensions, Loops, and Decisions
Module 2: Connecting to data
Understanding connections, importing data, coding the Power Query
Module 3: Data Preparation
Importance of data preparation, data preparation techniques
Module 4: Visualise data
Report building with tables, graphs, and charts
Module 5: Analyse data
Introduction to Pivot reports, building a PivotTable, and creating the PivotChart
Module 6: Reporting the results
Introduction to external libraries – PowerPoint, Outlook, and the FileSystemObject
Experience Microsoft Office - VBA Advanced in Qatar through Bilginç IT Academy's live and interactive virtual classroom environment, accessible from your home, office, or any location. Connect with expert trainers in real time and bring the energy of classroom learning into the digital experience.
Experience Microsoft Office - VBA Advanced in a focused classroom environment in Qatar. Bilginç IT Academy's carefully selected training venues provide a professional setting where delegates can interact directly with expert trainers and peers.
Meet your team's training needs with Bilginç IT Academy's onsite Microsoft Office - VBA Advanced in Qatar solution, delivered at your office or preferred location. Align your team's development with your business goals through a training experience tailored to your organization.
Join our public courses in our Qatar facilities. Private class trainings will be organized at the location of your preference, according to your schedule.
Qatar is rapidly evolving into a sophisticated knowledge-based economy under the framework of 'Qatar National Vision 2030,' with Doha and the futuristic city of Lusail leading the charge in digital infrastructure investment. The nation hosts the renowned 'Education City,' bringing together top-tier international university campuses to foster local research in Artificial Intelligence, Cybersecurity, and Smart City technologies. Qatar’s strategic focus on digital sports technology and energy-sector ICT has positioned it as a regional leader in high-end technical innovation. Our educational frameworks in Qatar are meticulously aligned with these national goals, providing the professional workforce with essential skills in Data Analytics, Cloud Management, and IT Governance. We empower experts in Qatar to manage the massive digital projects that are defining the future of the Gulf region and the global energy market.
