Related Courses
Take your career to the next level with higher education that works for you
Course Overview
By attending this online course, delegates will learn the skills to enable them 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.
This course is delivered virtually through the GTA, tutor led in real time.
Course Content
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
Benefits
Learning Outcomes:
- Overview of the VBA Essentials
- Connecting to external data
- Preparation of datasets
- Develop charts and build data visuals
- Analyse data with Pivots
- Reporting the results in other MS applications
Prerequisites
- Delegates will have attended the QA course Introduction to VBA in Office 2016 – 2019 or have equivalent knowledge
- Able to write macros which include variable declarations with appropriate scope, intrinsic functions, decision-making structures and repeating code actions
- Have a working knowledge of Microsoft Office applications 2016 – 2019 (Excel, Word, Outlook and PowerPoint)
- Understand how to create Charts and PivotTables and apply filters and sorting to data sets
Course Tutor
QA The UK’s leading tech skills organisation
QA are a training provider who create capabilities, build confidence and break down barriers to opportunity. QA shape the next generation of technologists, leaders and innovators through training. They know that if they get it right for the individual, they will get it right for our customers. QA exist at the forefront of the digital revolution and provide the skills to build a new digital culture and enrich society – one learner at a time.
Sign In Required
Please sign in to book this course
Select which organisation you would like to book for
Select Attendees to Book
Booking Summary
Free Course Summary
Register Interest Summary
- Course
- Course Title
- Notification
- You will be notified when this course becomes available for booking