De Meest Voordelige Opleider van Nederland
Award winning E-Learning & Gecertificeerde Trainers
Upgrade uw cv met een certificaat van deelname van OEM
SpringestMicrosoft PartnerEC-CouncilOfferte Aanvragen
0

Tip: we verzorgen onze trainingen tegenwoordig ook VirtueelTip: we verzorgen onze trainingen tegenwoordig ook VirtueelKlik hier voor meer informatie

Tip: we verzorgen onze trainingen tegenwoordig ook VirtueelTip: we verzorgen onze trainingen tegenwoordig ook VirtueelKlik hier voor meer informatie

VBA Visual Basic for Applications Automating Excel and Access Using VBA E-Learning

Product description
Automating Excel and Access Using VBA E-Learning 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...

Automating Excel and Access Using VBA E-Learning

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

Product specifications

Availabilty
05:17hours
Language
English
Certificate of participation
Yes
Online access
365 days

Reviews

5 / 5Based on 1 reviews
  • 5 / 5
    Posted by: Van Essen on 17 January 2021
    Een zeer volledige, maar ook wel pittige training, waarbij ik heel veel heb geleerd over Excel en Access. Doordat je stapje voor stapje mee wordt genomen door Excel en Access is het erg goed te doen en was het voor mij erg le...
    Een zeer volledige, maar ook wel pittige training, waarbij ik heel veel heb geleerd over Excel en Access. Doordat je stapje voor stapje mee wordt genomen door Excel en Access is het erg goed te doen en was het voor mij erg leerzaam. De onderwerpen worden in kleine hoofdstukken behandeld. Ik vond dat erg prettig werken. Dat maakt het erg overzichtelijk.
Create your own review

Eerder bekeken door jou

VBA Visual Basic for Applications Automating Excel and Access Using VBA E-Learning
VBA Visual Basic for ApplicationsAutomating Excel and Access Using VBA E-Learning

Automating Excel and Access Using VBA Award-winning E-Learning course Extensive interactive videos with spoken text Certified teachers Practical exercises Certificate.

€159,00 Excl. tax
Please accept cookies to help us improve this website Is this OK? YesNoMore on cookies »