Join over 35,000 students, from 300 countries, who already obtained their computer training with us.
  Duration: 5 Days
  Registration Open Now!
  Duration: 5 Days
  Registration Open Now!
In this course, students will apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks that you can perform using various tools and functions in Excel 2016
This short course is specifically designed for anyone who uses the Microsoft Office system, especially for those who use it to prepare spreadsheets or tables.
Lesson 1: Essentials of Spreadsheet Application Development
Lesson 2: Introducing Visual Basic For Applications
Lesson 3: VBA Programming Fundamentals
Lesson 4:Working With VBA Sub Procedures
Lesson 5: Working with UserForms
Lesson 6: Understanding Excels Events
Lesson 7:Developing Applications
Lesson 8: Working with Pivot Tables
Lesson 9: Working with charts
Lesson 10: Interacting with other Applications
Lesson 11: Working with external Data and Files
Lesson 12: Leverage Custom Dialog boxes
Lesson 13: Introducing UserForms
Lesson 14: Userform Examples
Lesson 15: Advanced Userform techniques
Lesson 16: Creating and using Add ins
Lesson 17:Working with ribbon
Lesson 18: Working with shortcut menus
Lesson 19: Providing help for your applications
Lesson 20: Leveraging class modules
Lesson 21: Understanding Compatibility issues