*Outline/Enroll button belowDuration: 1-dayMaterials: 1600+ Page Manual Included
Advanced Excel Public Training Focus
|
Microsoft Excel VBA Essentials Public Training for Business |
Materials: 1600+ Page Manual Included
Microsoft Visual Basic for Applications (VBA, macros) can be used in conjunction with Microsoft Excel to automate common everyday Excel tasks and to construct automated data processing tools. VBA, a general purpose programming language, comes standard with Excel or Office. This public workshop covers the fundamentals of using VBA programming and as well as how to apply it to common Excel and data processing tasks.
For a complete workshop outline, click the Workshop Outline button below. Dates, times and pricing on enrollment page. View enrollment page now. Repeat this workshop for free as many times as you want. View offer details. Military and government discounts available, call us for details.
What You Learn at a Glance
How to use the Visual Basic (VBA) Editor and its debugging tools
Excel macro language review (Subs, Functions, variables, arrays, loops, logic...etc)
How to streamline tasks in Microsoft Excel using VBA
How to use Microsoft Excel VBA to analyze and reconcile data on worksheets
How to use Excel visual basic (VBA) to perform calculations on data
How to create summary sheets (reconcile data) using VBA
How to create charts using VBA
How to use Excel VBA to build your own custom worksheet functions
How to use the Visual Basic Macro Recorder and interpret its recordings
Beginning Microsoft Excel VBA Public Training for Business |
Materials: 1600+ Page Manual Included

Microsoft Visual Basic for Applications (VBA, macros) can be used in conjunction with Microsoft Excel to construct automated business tools. VBA, a general purpose programming language, comes standard with Excel or Office. Using Microsoft Visual Basic with Excel, powerful business analysis tools can be developed quickly and with minimum cost. VBA can be used for business tasks like report generation, creating dashboards, communicating with business databases, analyzing business data, reconciling data, automating worksheet construction, business model calculations, creating charts, the list is endless. This public workshop covers the fundamentals of using VBA programming and as well as how to apply it in real world situations.
For a complete workshop outline, click the Workshop Outline button below. Dates, times and pricing on enrollment page. View enrollment page now. Repeat this workshop for free as many times as you want. View offer details. Military and government discounts available, call us for details.
What You Learn at a Glance
How to use the Visual Basic (VBA) Editor and its debugging tools
Complete review of the VBA language (Subs, Functions, variables, arrays, loops, logic...etc)
How to command Microsoft Excel using VBA. Also discussed is how control Word and PowerPoint
How to use Microsoft Excel VBA to analyze data on single and multi worksheets
How to use Excel VBA to perform calculations on data
How to create summary sheets using VBA
How to create basic dashboards in Microsoft Excel using VBA
How to create and format single and multiple charts using VBA
Using VBA to create report generation tools in Microsoft Word and Microsoft PowerPoint using Excel VBA
How to use Excel VBA to build your own custom worksheet functions
How to use the Visual Basic Macro Recorder and interpret its recordings
How to download data from the web using VBA
How to automate the data analysis tool pack add-in using VBA
Advanced Microsoft Excel VBA Public Training for Business |
Materials: 1600+ Page Manual Included

The capability exists within Microsoft Excel and VBA to construct complex dashboard driven analysis and data processing business tools. These business tools can go far beyond simple macros becoming actual applications. Excel has a vast array of automated features like graphics, ActiveX controls, worksheets, userforms and cell ranges that when combined together allow these dashboard driven programs to be created. When you tie other programs and computer languages to Excel through VBA like Word, PowerPoint, Access, SQL Server, Lotus Notes, C and VB .Net, Excel VBA can tap into these environments obtaining the functionality it does not have. This public workshop focuses on using all of these elements to construct sophisticated data processing and analysis programs in Microsoft Excel.
For a complete workshop outline, click the Workshop Outline button below. Dates, times and pricing on enrollment page. View enrollment page now. Repeat this workshop for free as many times as you want. View offer details. Military and government discounts available, call us for details.
What You Learn at a Glance
An advanced review of the Excel VBA language
Advanced VBA data processing techniques for multi worksheets and multi workbooks
Advanced summary worksheet construction in Excel using Excel VBA
Advanced techniques for scanning Windows folders for workbooks and then opening them using VBA
How to read text files using VBA.
Advanced VBA programming techniques for creating multiple charts from multiple data sheets
How to create advanced business user interfaces on worksheets using ActiveX controls, VBA and graphics
Advanced excel dashboard construction
How to create and use userforms in VBA (wizards)
How to create event driven programs using VBA
Advanced VBA error protection techniques
How to create custom toolbars and menus to run your VBA code
How to communicate with databases using DAO and ADO in VBA and how to download data from the web using VBA
Advanced VBA techniques for communicating with other languages and programs
Excel VBA Public Workshops for Engineers & Scientists |
||
*Outline/Enroll button belowDuration: 2-daysMaterials: 1600+ Page Manual Included
Beginning Excel VBA Public Training Focus What is VBA? This public workshop covers the fundamentals of using VBA programming in the engineering and science world. From loops, variables and logic to controlling Microsoft Excel, Microsoft Word and PowerPoint to data processing. It also covers automated engineering chart construction, beginning dashboard topics, system modeling, custom worksheet functions (UDF's) and numerical analysis approaches. It uses real engineering and science examples that lets you start building useable macros in Excel right away. For a complete workshop outline, click the Workshop Outline button below. Dates, times and pricing on enrollment page. View enrollment page now. Repeat this workshop for free as many times as you want. View offer details. Military and government discounts available, call us for details.
*Outline/Enroll button belowDuration: 3-daysMaterials: 1600+ Page Manual
Advanced Excel VBA Public Training Focus What is VBA? This public workshop covers advanced engineering and science VBA topics such as automated engineering chart construction for multi worksheets; advanced control techniques of other applications such as Microsoft Word and Microsoft PowerPoint; advanced engineering dash board construction using charts, pictures, ActiveX controls and drawing shapes; engineering wizard construction using userforms; advanced worksheet layout including navigation; advanced system modeling; team linking; database communication using ADO and DAO and communicating with other computer languages like FORTRAN. It uses real world examples that lets you take your Excel applications to the top level For a complete workshop outline, click the Workshop Outline button below. Dates, times and pricing on enrollment page. View enrollment page now. Repeat this workshop for free as many times as you want. View offer details. Military and government discounts available, call us for details.
|
|
Additional Pages Microsoft Excel Classes Microsoft Excel VBA Courses Microsoft Excel Training Microsoft Excel Macros Microsoft Excel VBA Consulting Microsoft Excel Add-Ins Copyright © 2002-2010 EMAGENIT All Rights Reserved |