Please accept cookies to help us improve this website Is this OK? Yes No More on cookies »
Item number: 115955198

Automating Excel and Access Using VBA Course E-Learning

Item number: 115955198

Automating Excel and Access Using VBA Course E-Learning

159,00 192,39 Incl. tax

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

Read more
Discounts:
  • Buy 2 for €155,82 each and save 2%
  • Buy 3 for €154,23 each and save 3%
  • Buy 5 for €147,87 each and save 7%
  • Buy 10 for €143,10 each and save 10%
  • Buy 25 for €135,15 each and save 15%
  • Buy 50 for €124,02 each and save 22%
  • Buy 100 for €111,30 each and save 30%
  • Buy 200 for €79,50 each and save 50%
Availability:
In stock
Delivery time:
Ordered before 5 p.m.! Start today.
  • Award Winning E-learning
  • Lowest price guarantee
  • Personalized service by our expert team
  • Pay safely online or by invoice
  • Order and start within 24 hours

Automating Excel and Access Using VBA Course 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
Language English
Qualifications of the Instructor Certified
Course Format and Length Teaching videos with subtitles, interactive elements and assignments and tests
Lesson duration 5:17 Hours
Progress monitoring Yes
Access to Material 365 days
Technical Requirements Computer or mobile device, Stable internet connections Web browsersuch as Chrome, Firefox, Safari or Edge.
Support or Assistance Helpdesk and online knowledge base 24/7
Certification Certificate of participation in PDF format
Price and costs Course price at no extra cost
Cancellation policy and money-back guarantee We assess this on a case-by-case basis
Award Winning E-learning Yes
Tip! Provide a quiet learning environment, time and motivation, audio equipment such as headphones or speakers for audio, account information such as login details to access the e-learning platform.
Total
10/10 (1 Reviews)

    "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."

    Van Essen on 17 Jan 2021

Loading...

OEM Office Elearning Menu Genomineerd voor 'Beste Opleider van Nederland'

OEM Office Elearning Menu is trots genomineerd te zijn voor de titel 'Beste Opleider van Nederland' door Springest, een onderdeel van Archipel. Deze erkenning bevestigt onze kwaliteit en toewijding. Hartelijk dank aan al onze cursisten.

Reviews

Total
10/10 (1 Reviews)

    "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."

    Van Essen on 17 Jan 2021

25.000+

Deelnemers getrained

Springest: 9.1 - Edubookers 8.9

Gemiddeld cijfer

3500+

Aantal getrainde bedrijven

20+

Jaren ervaring

Even more knowledge

Read our most recent articles

View blog