FASTTRACK
• Course Calendar
• Book a Course
• About Front Runner
• Contact Us
Course Calendar | Technical/Maintenance | Frequently Asked Questions | Testimonials | Our Instructors
Microsoft Excel: VBA Development

Turn data into information with powerful tools to analyze, communicate, and share results. Excel can help you work better in teams, and help protect and control access to your work. In addition, you can work with industry-standard Extensible Markup Language (XML) data to make it easier to connect to business processes.

Register, customize or arrange private group training at our office or yours on any day! - Send this course to a Friend!
Overview: This one-day course teaches participants the skills necessary to use various functions and PivotTables. Anyone who works with multiple workbooks or needs to create and manage high end macros work with advanced features of Excel and various advanced techniques for analyzing and manipulating data in Excel.

Duration: 1 day

Fee: $590 per person

Upcoming Dates:
Please call for availability and customization.

Prerequisite: Microsoft Excel: Advanced

 Delivery: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities and assignments.

Materials: Participants receive reference materials related to course topics. Sample files used in class are available by email, or on disk. Follow up support by email or phone, on topics covered, is available to participants for 90 days.

Further Learning:
Microsoft Word: VBA Development

 Objectives: Upon successful completion attendees will be able to:
  • Customize the work area
  • Work with built-in and custom toolbars
  • Create and use styles
  • Use templates
  • Understand advanced formula construction
  • Use names
  • Use the IF and VLOOKUP functions
  • Use PivotTables
  • Create PivotTables
  • Modify PivotTables
  • Work with multiple worksheets
  • Work with workbooks
  • Link cells in different workbooks
  • Use protection and display options
  • Use comments
  • Protect workbooks
  • Use custom views
  • Run and record macros
  • View and Edit VBA code
  • Work with interactive Excel web documents
  • Save Excel Worksheets as web documents
Front Runner Training
A Division of Front Runner Publishing Solutions Inc.
21 St. Clair Ave. E, Suite 504
Toronto, ON M4T 1L8
Canada
Contact Us
Phone: 416-515-0155
Toll-Free: 1-877-999-0155
Fax:416-849-0437
View a Map (PDF) | Privacy Policy (PDF)