BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Sephone Interactive Media//Eleventary//EN
BEGIN:VEVENT
UID:51495@eleventary.com
SUMMARY:VBA Excel Programming - 5 sessions in 2 weeks (6pm - 9pm)
2 days/3 days staggered schedule (see Event Details below; CLICK the Contact the Host link below (Hosted By section) to make a request with the instructor for alternative schedules)
DESCRIPTION:* This course meets as follows:\n\n Tue, Thu --- In the beginning week from 6pm - 9pm\n\n Mon, Wed, Fri --- In the following week from 6pm - 9pm\n\n\n\nFor Alternative Schedules:\n\nCLICK the Contact the Host link below (Hosted By section) to make a request with the instructor.\n\n\n\n* University students pay $600 (proof required)\n\n\n\n* Manhattan location, steps away from the Subway, close to midtown and downtown,\n\n next to Starbucks and Chase.\n\n* The student is prepared for the real world by short and long programs dealing with \n\n corporate problems instead of abstract, trivial programs. These programs are \n\n demonstrated in depth both in the manual and in the classroom lectures, even the \n\n comprehensive examples' code is commented extensively for immediate \n\n understanding.\n\n\n\n\n\n* VBA is what problem solvers use to destroy Excel data problems, VBA skills elude \n\n a lot of professionals because of companies' overemphasis on nice looking apps, \n\n high performance logic and software integration, very often the data that you need \n\n to organize, analyze and extract doesn't exist in those integrated business apps, it's \n\n in Excel and unless you're fluent in the VBA language you can spend literally all day \n\n just to organize the Excel data. Companies have been training users on proprietary \n\n apps, totally neglecting intrinsic analytical skills and personal problem solving, the \n\n situation is such that the typical Excel user can't solve simple Excel problems \n\n (because built-in functionalities are just general purpose solutions).\n\n\n\n\n\n* Theories in finance, economics, accounting, trading and hedging are taught, their \n\n nuances are analyzed in school and commercial firms, but schools and graduate \n\n programs completely overlook the all-important VBA language. Why is VBA \n\n important? Excel is a universal data workhorse, clicking, dragging and dropping in \n\n Excel just aren't enough to solve problems involving thousands or tens of thousands \n\n of records, especially where decision making or criteria setting is necessary, in \n\n these scenarios VBA is the only way.\n\n\n\n* Business software is continuously enhanced, even out-of-the-box solutions need \n\n modifications, similarly Excel can display and process data in a versatile ways \n\n but its capabilities are limited through its interface. Without VBA, the maximal \n\n potential of your data can't be achieved, for reporting, analysis, modeling or any \n\n other needs where decision making is required. Imagine working with an \n\n outdated application, imagine purchasing risk management software without \n\n upgrading, the inner mechanisms need to be improved to accommodate market \n\n practices and industry changes. Treating Excel as an out-of-the-box solution is \n\n nearly 100% comparable to buying a mission-critical solution without further \n\n enhancements.\n\n\n\n\n\n* Leverage this course to build your Excel back-end skills while boosting your \n\n professional worth (better compensation, career and industry choices).\n\n* Uncommon time saving tips shown, practical and invigorating scenarios used.\n\n\n\n* Suitable for accountants, analysts, financial engineers, SAS programmers who\n\n might need to interact on the Excel level plus non-technical users who want to not\n\n only quickly grasp the essentials of the VBA language in the context of Excel, but\n\n also learn the basics of code development approaches for solving real world\n\n problems.\n\n* Write short programs to save yourself hours of manual work.\n\n* Problem analyses are performed on practical problems as the course progresses,\n\n letting students see how the solutions were developed, giving them prototypes in\n\n problem solving.\n\n\n\n* This course emphasizes VBA the language and the Excel object model as integral\n\n parts that work in unison.\n\n\n\n* Alternative syntaxes are illustrated to highlight the gaps between efficient and\n\n inefficient coding.\n\n* Students aren't left with only syntaxes but are guided to become self-reliant solution\n\n providers through analysis rather than learn easy tips and copy code without\n\n meaningful growth.\n\n* A core set of elements and concepts links the training modules, if you learn even this \n\n small set of knowledge from this course, you'll have gained a lot that's not possible \n\n from typical basic programming exercises, this is because this course's examples \n\n are grounded in realistic and non-trivial scenarios. \n\n* Classroom interaction speeds up the understanding of concepts. Live lectures do \n\n wonders in contrast to book reading where a few hundred or over a thousand pages \n\n must be read and the reader is left to figure out just which topics are actually \n\n relevant, even worse is that the reader often doesn't know how to do problem \n\n analysis, let alone develop a solution that can be scaled and remain robust, this is \n\n because many courses and books teach only how to do generic operations such as \n\n open a file. Gjedot assumes the student wants to take this course to solve complex \n\n problems in the professional realm, not just read a few lines of VBA code.\n\n\n\n* See full and meaningful\n\nillustrations for immediate and long term growth.\n\n \n\n* A powerful, condensed set of core concepts, fully explains the power of the \n\n combined platform using VBA and Excel. Offers solution approaches (taking a \n\n problem from analysis through solution\n\ndevelopment). UNIQUE GJEDOT \n\n DIFFERENCE: \n\nTrivial how-to's are addressed but the\n\nempasis is on \n\n comprehensive walk-throughs of corporate level problems that you can\n\nrelate to. \n\n In-depth explanations + commented code guide you every step of the way.
DTSTART:20110809
DTEND:20201231
CREATED:20130423T105153
LOCATION:401 Broadway, Suite 213, New York, NY, New York, NY
URL:https://www.eleventary.com/event/vba-excel-programming-5-sessions-in-2-weeks-6pm-9pm-2-days-3-days-staggered-schedule-see-event-details-below-click-the-contact-the-host-link-below-hosted-by-section-to-make-a-request-with-the-instructor-for-alternative-schedules-51495
END:VEVENT
END:VCALENDAR