itEnabler
+CISCO
+Android Programming Course
+SQL Scripting
+MS SQL Server 2012
- MS SQL Server 2012 Database Administration
- MS SQL Server 2012 Database Querying

+Oracle Database SQL
- Oracle Certified SQL Expert

+ITIL
+VBA Excel / Access / Word
+Web Design & Ecommerce
+Web Development &
  Programming

- SQL Scripting
- Adv SQL Scripting
- Javascript
- HTML5 with JavaScript and CSS3
+Microsoft Infrastructure Certification

CompTIA Courses


+

Basic Networking & IC3 Courses



Register Courses at IT Enabler
Home > Course List > Advanced VBA for Excel 2010
Advanced VBA Excel Course Singapore - Advanced VBA Excel 2010

Course Description and Objective:

This 2-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


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: 2 Weekdays / 2 Sats                 Time : 9.30am - 5.30pm
Part-time: 4 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
Course Outline:


Lesson 1. VBA Worksheet Data with Events

  • Introduction to Event Procedure
  • Enabling and Disable Events
  • Event Sequence
  • Worksheet Events
  • Workbook Events
  • PivotTable Events
  • Other Excel Events like onTime, OnKey method


Lesson 2 . Data Verification and Conditional Formatting

  • Adding Data Bars to a Range
  • Adding Color Scales to a Range
  • Adding Icons sets to a Range
  • Other Conditional Formatting Methods


Lesson 3. File and Folder Manipulation with VBA

  • Manipulating File and Folders
  • Changing the name of a file or folder
  • Checking and Existence of a File or Folder
  • Creating and Deleting Folders
  • Copy Files and Deleting Files


Lesson 4 . Excel Dialog Boxes

  • Excel Dialog Boxes
  • File Open and File Save As Dialog Boxes
  • Filtering Files
  • Selecting Files


Lesson 5 . Printing from Excel Using VBA

  • Controlling Page Setup
  • Controlling Page Layout, Margins, Header/Footer and Sheet Tools
  • Retrieving Current Values from Page Setup Dialog Box
  • Print Previewing a Worksheet
  • Changing the Active Printer
  • Disabling Printing and Print Preview
  • Using Printing Events


Lesson 6. Creating Dashboard Excel 2010

  • Creating Sparklines
  • Scaling the Sparklines
  • Formatting Sparklines
  • Formatting a Win/Loss Charts
  • Creating a Dashboard
  • Creating Individual Sparklines in a Dashboard


Lesson 7 . Using Excel VBA to Interact with Office Applications

  • Using the CreateObject Function
  • Creating a New Word Document Using VBA
  • Opening an Existing Word Document
  • Using the New Keyboard


Lesson 8 . Emailing from Excel Using VBA

  • Configuring VBA Excel to automate sending Email even if Outlook is closed
  • Using VBA Excel to email Ranges
  • Using VBA Excel to email Worksheets or Selected Worksheets
  • Using VBA Excel to email Workbooks
  • Using VBA Excel to send attachment even if Outlook is closed
  • Mass email Using VBA Excel


Lesson 9. Using Excel VBA to retrieve Access Database

  • Connecting to an Access Database
  • Opening an Access Database
  • Performing Access Tasks from Excel
  • Retrieving Access Data into an Excel Worksheet


Lesson 10 . Programming PivotTables and PivotCharts

  • Building a PivotTable in Excel VBA
  • Creating and Configuring PivotTable
  • Creating a PivotTable Report from an Access Database
  • Adding Fields to the Data Area
  • Formatting, Grouping and Sorting a PivotTable Report
  • Filtering a Data Set in Pivot Tables
  • Creating a PivotChart Report Using VBA
  • Understanding Slicers (Excel 2010)
  • Working with Slicers using VBA

Download Course Brochure
Course Fee :
Training Fee: S$799.00
Regn Fee: S$25.00

(All fees subject to GST 7%)
Download Course Brochure (Contact Customer Service @ 6333 4843)

Course Title   Venue Register Online
Course Mode
Start Date
End Date
Time
Advanced VBA Excel 2010/2013 SingaporeRegisterFULL-TIME21-Aug-201722-Aug-20179:30AM-5:30PM 
Advanced VBA Excel 2010/2013 SingaporeRegisterFULL-TIME25-Sep-201726-Sep-20179:30AM-5:30PM 
Advanced VBA Excel 2010/2013 SingaporeRegisterFULL-TIME19-Oct-201720-Oct-20179:30AM-5:30PM 
Advanced VBA Excel 2010/2013 SingaporeRegisterFULL-TIME23-Nov-201724-Nov-20179:30AM-5:30PM 
Advanced VBA Excel 2010/2013 SingaporeRegisterFULL-TIME11-Dec-201712-Dec-20179:30AM-5:30PM