Automating Excel and Access Using VBA

Automating Excel and Access Using VBA

Order this amazing, award-winning Automating Excel and Access Using VBA E-Learning course online, 1 year 24/7 access to extensive interactive videos, speeches, hands-on tasks and progress monitoring. After the course you will receive a certificate of attendance.

Course content

VBA: Getting Started with VBA in Excel

Course: 1 Hour, 56 Minutes

• Course Overview
• Getting Started with VBA
• Using Functions from VBA
• Modifying Cells from VBA
• Using Excel's Macro Record Feature
• Accepting User Input with VBA
• Inserting Rows and Columns from VBA
• Merging and Formatting Cells from VBA
• Implementing Conditional Formatting Using VBA1
• Simulating Range Selection Operations from VBA
• Understanding the Limits of a FormatConditions Object
• Inserting Formulas into Cells Using VBA
• Course Summary

VBA: Building User Interfaces with Forms in VBA & Excel

Course: 1 Hour, 23 Minutes

• Course Overview
• Adding a User Form to an Excel Workbook
• Connecting a User Form to an Excel Workbook with Buttons
• Storing Data from a User Form into an Excel Workbook
• Using a User Form to Insert rows into an Excel Spreadsheet
• Sending Mail from Excel with VBA
• Building Complex User Forms
• Opening, Closing, and Submitting User Forms
• Using a Form with Complex Controls
• Course Summary

VBA: Leveraging VBA to Work with Charts, Stocks, & MS Access

Course: 1 Hour, 58 Minutes

• Course Overview
• Working with Excel Pivot Tables from VBA
• Working with Excel Charts from VBA
• Experiment with Charts from VBA
• Fetching Stock Data into an Excel Workbook
• Automate Stock Fetching Using VBA
• Getting Started with MS Access
• Running SQL Queries in MS Access
• Querying Data in MS Access
• Building User Forms in MS Access
• Inserting Rows into a Table Using Forms and VBA
• Working with Event Handlers in Excel with VBA
• Creating and Using Event Handlers in Excel
• Course Summary

Specificaties

Taal: Engels
Kwalificaties van de Instructeur: Gecertificeerd
Cursusformaat en Lengte: Lesvideo's met ondertiteling, interactieve elementen en opdrachten en testen
Lesduur: 5:17 uur
Voortgangsbewaking: Ja
Toegang tot Materiaal: 365 dagen
Technische Vereisten: Computer of mobiel apparaat, Stabiele internetverbindingen Webbrowserzoals Chrome, Firefox, Safari of Edge.
Support of Ondersteuning: Helpdesk en online kennisbank 24/7
Certificering: Certificaat van deelname in PDF formaat
Prijs en Kosten: Cursusprijs zonder extra kosten
Annuleringsbeleid en Geld-Terug-Garantie: Wij beoordelen dit per situatie
Award Winning E-learning: Ja

Tip! Zorg voor een rustige leeromgeving, tijd en motivatie, audioapparatuur zoals een koptelefoon of luidsprekers voor audio, accountinformatie zoals inloggegevens voor toegang tot het e-learning platform.