You are here:Courses|Microsoft|MS Office 2013|Excel 2013 Power Programming with VBA

Excel 2013 Power Programming with VBA

The course on Excel 2013 Power Programming with VBA will teach students about the Visual Basic for Applications; this course will also teach how to build programming language into Excel and other applications. This course will explain you how to write programs that automate various tasks in Excel.

Course Objectives :

  • Create sophisticated user-oriented applications
  • Comprehend the analysis of Excel application development
  • Comprehend the complete VBA
  • Comprehend the navigation of the Excel interface
  • Comprehend how to format worksheets
  • Comprehend the expanding of Excel's capabilities with VBA

Course Modules:

  • Formula Techniques
  • Understand Excel Files
  • fundamentals of Spreadsheet Application Development
  • Introduction to Visual Basic for Applications
  • Fundamentals of VBA Programming
  • Work with VBA Sub Procedures
  • Excel in a Nutshell
  • Create Function Procedures
  • VBA Programming Techniques
  • Introduction to UserForms
  • Custom Dialog Box Alternatives
  • UserForm Examples
  • Advanced UserForm Techniques
  • Develop Excel Utilities with VBA
  • Work with Pivot Tables
  • Work with Charts
  • Understand Excel's Events
  • Interact with Other Applications
  • Create and Use Add-Ins
  • Work with the Ribbon
  • Work with Shortcut Menus
  • Understand Class Modules
  • Work with Colours
  • Develop User-Oriented Applications
  • Compatibility Issues
  • Provide Help for Your Applications
  • Manipulate Files with VBA
  • Manipulate Visual Basic Components

 Ramsys Infotech Solutions runs the training in Accra-Ghana and with a number of our affiliate across the continent  

 

 

Course Regular Track
(days)
Fast Track
(days)
Excel 2013 Power Programming with VBA 5 3
Balance Days  for day of arrival and practice 1 1
Total duration 6 4

Prerequisites:

  • Excel Basic knowledge.

 

 

- See more at: http://www.koenig-solutions.com/excel-2013-programming-vba-training.aspx#sthash.lSeyNl8Y.dpuf

Our Location

Get In Touch

1st Floor of CHABAH House,

Chabah Bus Stop on the Odokor-Mallam HighWay

Opposite Total Filling Station

P. O. Box DS 2022

Accra, Ghana

Phone: +233 303 393 1256 / +233 302 325 815

Cell: +233 244036 522

Email: [email protected]