Microsoft Office 2010 / 2013

User Rating: 0 / 5

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

Microsoft Office 2010 / 2013

Microsoft SharePoint 2010 / 2013 for End Users / Power Users

Programming in Excel

Excel VBA for Absolute Beginners


Duration: 3 Days; Instructor-led

WHAT YOU WILL LEARN

This course provides an introduction to programming for students with little or no prior programming experience. Through this course, students will gain a strong, accessible, hands-on foundation in the language skills needed for learning Visual Basic for Applications (VBA) under MS-Excel environment.

The knowledge and skill gained from this course can be applied to MS-Excel 2003, MS-Excel 2007, MD-Excel 2020 and MS-Excel 2013.

This is the entry level course for more advanced Excel VBA programming.



AUDIENCE

Any Microsoft Excel users whoever want to do extra ordinary thing from their Microsoft excel applications where but limited by the predefined features. This includes those who know nothing about computer programming.



PREREQUISITES

Before attending this course, students must be able to demonstrate the following skills:

  • Ability to use a computer keyboard and a mouse
  • Familiarity with the general operations of Microsoft Windows operating system.
  • Basic knowledge and skill in using Microsoft-Excel (Any version).

The course materials, lectures, and lab exercises are in English. To benefit fully from the instruction, students need an understanding of the English language and completion of the prerequisites.

TRAINING TOOLS

 

  • MS Windows XP Professional SP3 or higher.
  • MS Excel 2003/2007/2010/2013 (Depends on the target audience)
  • Host PC: Any PC and OS support MS-Excel.

METHODOLOGY

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise.



COURSE OBJECTIVES

This course introduces students to the techniques used in the key areas of computer programming:

  • Programming principles
  • Basic program control structures
  • Data types
  • Subroutines and Functions

At the end of the course, students will be able to start creating simple VBA solution by using MS-Excel.

COURSE OUTLINES

Intermediate Excel VBA

 

Duration: 3 Days; Instructor-led

WHAT YOU WILL LEARN

This course is the follow up course of آœExcel VBA for Absolute Beginnersآ. It provides more in depth understanding the VBA language under MS-Excel environment. Through this course, new VBA developers can learn how to leverage more advanced features of VBA.

The knowledge and skill gained from this course can be applied to MS-Office 2003, MS-Office 2007 and MS-Office 2010.

 

AUDIENCE

Any of the Microsoft office users that already knows fundamentals Excel VBA programming. This is not the first VBA course.

 

PREREQUISITES

Before attending this course, students must be able to demonstrate the following skills:

  • Familiarity with the general operations of Microsoft Windows operating system.
  • Basic knowledge and skill in using any version of Microsoft Excel.
  • Basic Excel VBA programming


The course materials, lectures, and lab exercises are in English. To benefit fully from the instruction, students need an understanding of the English language and completion of the prerequisites.

TRAINING TOOLS

  • MS Windows XP Professional SP3 or higher.
  • MS Excel 2003/2007/2010/2013 (Depends on the target audience)
  • Host PC: Any PC and OS support MS-Excel.

 

METHODOLOGY

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise.



COURSE OBJECTIVES

This course is aim to introduce some of the challenging aspects of Excel VBA programming which is not normally known by new Excel VBA developers

At the end of the course, students will be able to write more advance Excel VBA code to tackle real life problems.



COURSE OUTLINES

Module 14 - Common Pitfalls

  • Using Application.Volatile
  • Reentrant issue
  • Dealing with Undo
Disclaimer | Privacy Policy | Security Policy | Copyright | RSS Feeds
Last update :
Best view with screen resolution 1024x768.
©2017 Appsflex. All Rights Reserved.

Search

Gallery

Links

 

 

Get To Know Us

Make Money With Us

  • Become an Affiliate
  • Self-Publish With Us

Payment Method

  • PayPal
  • Credit Card
  • Wire Transfer
  • Western Union

Let Us Help You

  • Your Account
  • Help