Home » Automating Excel and Access Using VBA

Opleiding: Automating Excel and Access Using VBA

Bij: OEM Office Elearning Menu

 

OEM Office Elearning Menu

P.J, Oudweg 4
1314 CH ALMERE
 

Inhoud van de cursus

Cursusinhoud
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

Heeft u niet gevonden wat u zocht?

Toelatingseisen: wat heb je nodig?

Er is geen specifieke voorkennis vereist.

Duur van de cursus

05:17 uur

Bijzonderheden

Award Winning E-learning

Plaatsen / leslocaties

Heel Nederland, E-learning, Online

Algemene informatie over de cursus

Bestel deze geweldige, bekroonde Automating Excel and Access Using VBA e-learning cursus online, 1 jaar 24/7 toegang tot uitgebreide interactieve video's, toespraken, praktische taken en voortgangsbewaking. Na de cursus ontvang je een certificaat van deelname.

Duur: 05:17 uur
Taal: Engels
Certificaat van deelname: Ja
Online toegang: 365 dagen
Voortgangsbewaking: Ja
Award Winning E-learning: Ja
Geschikt voor mobiel: Ja

Informatie aanvragen

Gegevens aangeduid met een * zijn verplicht in te vullen.
jaar
 
resterend: tekens
 
Ba965 Typ de code exact over: (hoofdlettergevoelig)
 
Copyright 2009-2021 Particuliereopleidingen.nl | Algemene voorwaarden | Overzicht van onze aanbieders | Adverteren