Automating Excel and Access Using VBA Cursus E-Learning

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.

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