Online or onsite, instructor-led live VBA training courses demonstrate through interactive discussion and hands-on practice how to use VBA in applications such as Word, Excel and Access.
VBA training is available as "online live training" or "onsite live training". Online live training (aka "remote live training") is carried out by way of an interactive, remote desktop. Onsite live VBA training can be carried out locally on customer premises in Nantes or in NobleProg corporate training centers in Nantes.
VBA training courses are available for beginners and advanced users.
NobleProg -- Your Local Training Provider
Nantes, Zenith
NobleProg Nantes, 4 rue Edith Piaf, Saint-Herblain, france, 44821
In the Parc d'Ar Mor zone, near the Zénith.
Car : from the ring road, Porte de Chézine Exit> Boulevard du Zenith > Esplanade Georges Brassens (restaurants) > Rue Edith Piaf on the right. From the N444 road (Nantes > Lorient), Exit #1 > boulevard Marcel Paul > Rue Edith Piaf at the right.
Parking Zénith P1 (free). Once parked, you can recognize the building: it's one of the tree bulding with zinc frontage.
Bicycle: free indoor parking
Public transport :
Tramway R1, Schoelcher station + 10 mn by foot through commercial center Atlantis
Tramway R1, François Mitterrand stop + bus 50, stop at Saulzaie station or bus 71, stop at the Zénith station
Tramway R3, Marcel Paul station + bus 50, Saulzaie station
Chronobus C6, Hermeland station+ bus 71, Zénith station
Bus : lignes 50 (Saulzaie station) or 71 (Zénith station)
This instructor-led live training, available both online and onsite, is tailored for data analysts who wish to utilize advanced VBA in Excel to automate tasks.
By the end of this training, participants will be able to:
Delivered as an instructor-led live training session (available online or onsite), this program is designed for data analysts looking to leverage VBA in Excel to automate their workflows.
Upon completion of this training, participants will be able to:
Record and edit macros as needed.
Write procedures that utilize data from worksheets.
Develop custom functions.
Handle events (such as opening a worksheet or updating a cell) using event handlers.
Automate workflows and develop robust desktop applications with VBA in Microsoft Excel and Access. This comprehensive VBA training covers programming fundamentals, object-oriented coding, SQL database design, user interface development, debugging techniques, error handling, and advanced Excel analysis routines through practical exercises — empowering analysts, financial professionals, and developers to eliminate manual tasks and unlock advanced data management and reporting capabilities.
This training program addresses key challenges associated with Visual Basic for Applications programming and demonstrates techniques for accessing data via VBA. Participants will also acquire the knowledge needed to develop professional-grade database applications.
This course empowers participants to master Excel, enabling them to create, consolidate, and manage data efficiently. By leveraging specialized tools, you can significantly streamline workflows, reduce time spent on routine tasks, and design applications capable of performing new, complex functions.
Elevate your VBA expertise to an intermediate level by mastering custom interfaces, complex data types, conditional logic, looping structures, and professional debugging methods. This practical Excel VBA training covers robust error handling, performance optimization, VBA UserForms, and workflow automation through real-world exercises. Designed for data analysts, reporting specialists, and business professionals, it bridges the gap between basic macros and advanced automation solutions to meet enterprise spreadsheet requirements.
This instructor-led, live training in Nantes (online or onsite) is aimed at beginner-level analysts who wish to use Excel VBA to automate repetitive work, clean and transform data, and improve reporting processes.
By the end of this training, participants will be able to: record and edit macros, write simple VBA procedures, work with Excel objects for reporting tasks, and debug basic automation solutions.
Read more...
Last Updated:
Testimonials (6)
scope of material
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
Course - Visual Basic for Applications (VBA) w Excel - wstęp do programowania
Well structured. Good teaching techniques. Course well documented!
Sorin
Course - VBA For Access & Excel
What I liked most about the training was the trainer’s knowledge of Excel. I appreciated learning useful things like shortcuts and formulas that I can use every day.
Martin
Course - Visual Basic for Applications (VBA) for Analysts
I like the hands on training and seeing us solve for issues on the spot.
Jon Matrille - LocumTenens.com
Course - Visual Basic for Applications (VBA) in Excel - Advanced
There was a good amount of information for the time of training. Also the trainer was very engaged with the group, especially when people were having troubles or asking questions. It was very nice of him to offer help in case of future ideas.
Aleksander Jarecki - Amazon Development Center Poland Sp. z o.o.
Course - Visual Basic for Applications (VBA) in Excel (intermediate level)
Training Room and quite location and all the stuff.
Online VBA training in Nantes, VBA training courses in Nantes, Weekend VBA courses in Nantes, Evening VBA training in Nantes, VBA instructor-led in Nantes, VBA instructor in Nantes, Evening VBA courses in Nantes, VBA one on one training in Nantes, VBA instructor-led in Nantes, Weekend VBA training in Nantes, VBA trainer in Nantes, VBA private courses in Nantes, VBA coaching in Nantes, VBA on-site in Nantes, Online VBA training in Nantes, VBA boot camp in Nantes, VBA classes in Nantes
