About this Course

This 3-day course is a follow-up course to our Visual Basic Excel 2007/2010/2013 Course. Participant who wishes to learn how to automate Excel advance features like PivotTables, Pivot Charts, Dashboard and Window File Dialogs. This course also teaches automatic sending email within Excel, automate printing, set timer to run VBA macros, retrieve data from Access and import/export data to Microsoft Office like Word and Outlook Address Book 

Participants will be able to extend your VBA excel macros to PivotTable, Sorting, Filtering, create Dashboard, PivotCharts and learn how to retrieve data from Access and import/export data to Microsoft Word and Outlook Address Book

Course Outline:

1. VBA Worksheet Data with Events

2. Programming PivotTables and PivotCharts

3. Data Verification and Conditional Formatting

4. File and Folder Manipulation with VBA

5. Excel Dialog Boxes

6. Creating Dashboard Excel 2010

7. Printing from Excel Using VBA

8. Emailing from Excel Using VBA

9. Using Excel VBA to Interact with Office Applications

10. Using Excel VBA to retrieve Access Database

Prerequisites:

Prior knowledge in VBA Excel 2007/2010/2013 is mandatory - Branches and Conditional Looping, How to manage errors in VBA Excel and Procedures & Functions in VBA Excel.

Certificate Of Attendance:

Certificate Of Attendance will be awarded to participants completing at least 75% of the course.

Training Duration:

Full-time: 3 Days                Time : 9.30am - 5.30pm 

Part-time: 6 Sessions        Time : 7.00pm - 10.00pm (twice a week)

Who Should Attend This Course?

Participants who are keen to extend their VBA Excel Programming knowledge further in the area of PivotTable, PivotCharts, filters and sorting, automated email sending of forms/excel spreadsheet, importing/export from database software like SQL Server, SAP to perform data analysis,etc

Rate this course:

Log in to submit

Comments