Automating Excel and Access Using VBA Course E-Learning - OEM
Please accept cookies to help us improve this website Is this OK? Yes No More on cookies »
115955198 SKU 115955198

Automating Excel and Access Using VBA Course E-Learning

115955198 SKU 115955198

Automating Excel and Access Using VBA Course E-Learning

129,00 156,09 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 €126,42 each and save 2%
  • Buy 3 for €125,13 each and save 3%
  • Buy 5 for €119,97 each and save 7%
  • Buy 10 for €116,10 each and save 10%
  • Buy 25 for €109,65 each and save 15%
  • Buy 50 for €100,62 each and save 22%
  • Buy 100 for €90,30 each and save 30%
  • Buy 200 for €64,50 each and save 50%
Availability:
In stock
Delivery time:
Order before 4:00 PM and start today.
  • Bestel voor 17:00 uur en start vandaag
  • Persoonlijke service van ons deskundige team
  • Veilig betalen
  • Betaal online of op factuur
  • De laagste prijs garantie

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

Availabilty 05:17hours
Language English
Certificate of participation Yes
Online access 365 days
Progress monitoring Yes
Award Winning E-learning Yes
Suitable for mobile Yes
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

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

Microsoft Office SCORM e-Learning

Wilt u Microsoft Office e-Learning SCORM hosten in het LMS van uw organisatie? Neem contact met ons op.

Students

Thousands of satisfied trainees at OEM

Average rating

Springest: 8.7, Webwinkelkeur: 8.0

20+ years of experience

We too continue to learn

Quality

Award-winning E-Learning & Certified Tutors

Even more knowledge

Read our most recent articles

View blog