VBA Excel Programming - 5 sessions in 2 weeks Weekday/weekend staggered schedule B (see Event Details below; CLICK the Contact the Host link below (Hosted By section) to make a request with the instructor for alternative schedules)

Gjedot Solution Group

Monthly Event - Fourth Wednesday of every month

New York, NY

Ticket Information

* Please Select a Date
Ticket Type Sales End Price Fee Quantity
VBA Excel Programming - 5 sessions in 2 weeks days mix B 1 day before event $1,000.00 $9.95

Share VBA Excel Programming - 5 sessions in 2 weeks Weekday/weekend staggered schedule B (see Event Details below; CLICK the Contact the Host link below (Hosted By section) to make a request with the instructor for alternative schedules)

Event Details

* This course meets as follows:

   Wed, Thu --- In the beginning week from 6pm - 9pm

   Tue, Fri    --- In the following week from 6pm - 9pm

   Sat           --- In the following week from 10am - 1pm


For Alternative Schedules:
CLICK the Contact the Host link below (Hosted By section) to make a request with the instructor.

 

* University students pay $600 (proof required)


* Manhattan location, steps away from the Subway, close to midtown and downtown,

   next to Starbucks and Chase.

* The student is prepared for the real world by short and long programs dealing with

   corporate problems instead of abstract, trivial programs.  These programs are

   demonstrated in depth both in the manual and in the classroom lectures, even the

   comprehensive examples' code is commented extensively for immediate

   understanding.


* VBA is what problem solvers use to destroy Excel data problems, VBA skills elude

   a lot of professionals because of companies' overemphasis on nice looking apps,

   high performance logic  and software integration, very often the data that you need

   to organize, analyze and extract doesn't exist in those integrated business apps, it's

   in Excel and unless you're fluent in the VBA language you can spend literally all day

   just to organize the Excel data.  Companies have been training users on proprietary

   apps, totally neglecting intrinsic analytical skills and personal problem solving, the

   situation is such that the typical Excel user can't solve simple Excel problems

   (because built-in functionalities are just general purpose solutions).


* Theories in finance, economics, accounting, trading and hedging are taught, their

   nuances are analyzed in school and commercial firms, but schools and graduate

   programs completely overlook the all-important VBA language.  Why is VBA

   important?  Excel is a universal data workhorse, clicking, dragging and dropping in

   Excel just aren't enough to solve problems involving thousands or tens of thousands

   of records, especially where decision making or criteria setting is necessary, in

   these scenarios VBA is the only way.


* Business software is continuously enhanced, even out-of-the-box solutions need

   modifications, similarly Excel can display and process data in a versatile ways

   but its capabilities are limited through its interface.  Without VBA, the maximal

   potential of your data can't be achieved, for reporting, analysis, modeling or any

   other needs where decision making is required.  Imagine working with an

   outdated application, imagine purchasing risk management software without

   upgrading, the inner mechanisms need to be improved to accommodate market

   practices and industry changes.  Treating Excel as an out-of-the-box solution is

   nearly 100% comparable to buying a mission-critical solution without further

   enhancements.

* Leverage this course to build your Excel back-end skills while boosting your

   professional worth (better compensation, career and industry choices).


* Uncommon time saving tips shown, practical and invigorating scenarios used.


* Suitable for accountants, analysts, financial engineers, SAS programmers who

  might need to interact on the Excel level plus non-technical users who want to not

  only quickly grasp the essentials of the VBA language in the context of Excel, but

  also learn the basics of code development approaches for solving real world

  problems.


* Write short programs to save yourself hours of manual work.

* Problem analyses are performed on practical problems as the course progresses,

   letting students see how the solutions were developed, giving them prototypes in

   problem solving.


* This course emphasizes VBA the language and the Excel object model as integral

   parts that work in unison.


* Alternative syntaxes are illustrated to highlight the gaps between efficient and

   inefficient coding.


* Students aren't left with only syntaxes but are guided to become self-reliant solution

   providers through analysis rather than learn easy tips and copy code without

   meaningful growth.


* A core set of elements and concepts links the training modules, if you learn even this

   small set of knowledge from this course, you'll have gained a lot that's not possible

   from typical basic programming exercises, this is because this course's examples

   are grounded in realistic and non-trivial scenarios. 


* Classroom interaction speeds up the understanding of concepts.  Live lectures do

   wonders in contrast to book reading where a few hundred or over a thousand pages

   must be read and the reader is left to figure out just which topics are actually

   relevant, even worse is that the reader often doesn't know how to do problem

   analysis, let alone develop a solution that can be scaled and remain robust, this is

   because many courses and books teach only how to do generic operations such as

   open a file.  Gjedot assumes the student wants to take this course to solve complex

   problems in the professional realm, not just read a few lines of VBA code.


* See full and meaningful illustrations for immediate and long term growth.

 

* A powerful, condensed set of core concepts, fully explains the power of the

  combined platform using VBA and Excel.  Offers solution approaches (taking a

  problem from analysis through solution development).  UNIQUE GJEDOT

  DIFFERENCE:  Trivial how-to's are addressed but the empasis is on

  comprehensive walk-throughs of corporate level problems that you can relate to. 

  In-depth explanations + commented code guide you every step of the way.


Have questions about VBA Excel Programming - 5 sessions in 2 weeks Weekday/weekend staggered schedule B (see Event Details below; CLICK the Contact the Host link below (Hosted By section) to make a request with the instructor for alternative schedules)? Contact Gjedot Solution Group

Where


401 Broadway, Suite 213
New York, NY 10013

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.